C#

public bool SynchProductsCategoryToCBD(IList<EcashProductCatModel> model)
        {
            con = new SqlConnection(strCon);

            cmdinsert = new SqlCommand("sp_AddProductCategory"); //needs to be created
            cmdinsert.CommandType = CommandType.StoredProcedure;
            cmdinsert.Connection = con;


            bool Error = false;
            try
            {
                con.Open();

                foreach (EcashProductCatModel ecash in model)
                {
                        cmdinsert.Parameters.Add("@CATEGORY_ID", SqlDbType.Int).Value = ecash.CATEGORY_ID;
                        cmdinsert.Parameters.Add("@CATEGORY_DESCRIPTION", SqlDbType.VarChar).Value = ecash.CATEGORY_DESCRIPTION;
                        cmdinsert.Parameters.Add("@SCHOOLID", SqlDbType.Int).Value = ecash.SCHOOLID;
                        cmdinsert.ExecuteNonQuery();
           
                }  
                Error = true;
            }
            catch (Exception ex)
            {
                Logger.LoggerClient logger = new Logger.LoggerClient();
                //Collect Data
                Logger.LoggerModel models = new Logger.LoggerModel();
                models.iTYPEID = Convert.ToInt32(GenericEnum.Logging_Type.ECASH_SYCH);
                models.sLOGGER_CLASS = "eCashDatalayer";
                models.sLOGGER_DESCRIPTION = ex.Message;
                models.sLOGGER_FUNCTION = "SynchProductsCategoryToCBD";
                models.sLOGGER_LOGGEDINUSERID = "";
                models.sLOGGER_PAGE = "NA";
                models.sLOGGER_VALUE = "NA";
                logger.LogIncident(models);
            }
            finally
            {
                con.Close();
            }
            return Error;
        }