public void Activate(int id) { using (SEDESOLEntities entities = new SEDESOLEntities()) { SOUP_KITCHEN sk = entities.SOUP_KITCHEN.Find(id); sk.IsActive = true; entities.SaveChanges(); } }
public SoupKitchenDTO Save(SoupKitchenDTO att) { using (SEDESOLEntities db = new SEDESOLEntities()) { SOUP_KITCHEN sk = db.SOUP_KITCHEN.FirstOrDefault(v => v.Id == att.Id); if (sk != null) { SOUP_KITCHEN sk2 = db.SOUP_KITCHEN.FirstOrDefault(v => v.Name == att.Name && v.Id_State == att.Id_State && v.Id != att.Id); if (sk2 != null) { att.Message = "El comedor ha sido ingresado previamente"; } else { sk.Name = att.Name; sk.Description = att.Description; sk.Capacity = att.Capacity; sk.Address = att.Address; sk.PhoneNumber = att.PhoneNumber; sk.ContactName = att.ContactName; //sk.IsActive = att.IsActive; sk.Id_State = att.Id_State; sk.AllowAnonym = att.AllowAnonym; sk.Folio = att.Folio; sk.Id_Region = att.Id_Region; if (db.SaveChanges() > 0) { att.Id = sk.Id; att.Message = "SUCCESS"; } } } else { SOUP_KITCHEN sk2 = db.SOUP_KITCHEN.FirstOrDefault(v => v.Name == att.Name && v.Id_State == att.Id_State); if (sk2 != null) { att.Message = "El comedor ha sido ingresado previamente"; } else { sk = new SOUP_KITCHEN(); sk.Name = att.Name; sk.Description = att.Description; sk.Capacity = att.Capacity; sk.Address = att.Address; sk.PhoneNumber = att.PhoneNumber; sk.ContactName = att.ContactName; sk.IsActive = true; sk.Id_State = att.Id_State; sk.AllowAnonym = att.AllowAnonym; sk.Folio = att.Folio; sk.Id_Region = att.Id_Region; db.SOUP_KITCHEN.Add(sk); if (db.SaveChanges() > 0) { att.Id = sk.Id; att.Message = "SUCCESS"; } } } return(att); } }
public string SaveDataRation(DataTable dt) { string result = "SUCCESS"; using (SEDESOLEntities db = new SEDESOLEntities()) { foreach (DataRow item in dt.Rows) { try { string folio = item["Folio_Comedor"].ToString(); SOUP_KITCHEN sk = db.SOUP_KITCHEN.FirstOrDefault(x => x.Folio == folio); if (sk != null) { int year = Convert.ToInt32(item["Year"].ToString()); int month = Convert.ToInt32(item["Month"].ToString()); // save ration table RATION rat = new RATION(); rat.Description = "carga de excel"; rat.IsActive = true; rat.Id_SoupKitchen = sk.Id; rat.Id_Month = Convert.ToInt32(item["Month"].ToString()); rat.Id_Year = Convert.ToInt32(item["Year"].ToString()); rat.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); rat.CreateUser = "******"; rat.CreateDate = DateTime.Now; rat.HasCoupon = false; db.RATIONs.Add(rat); db.SaveChanges(); var coupList = db.COUPONs.Where(v => v.Id_Year == year && v.Id_Month == month && v.Id_SoupKitchen == sk.Id).ToList(); var yearDto = db.YEARs.FirstOrDefault(v => v.Id == year); int count; if (coupList != null) { count = coupList.Count() + 1; } else { count = 1; } string monthS = string.Empty; //string yearS = string.Empty; if (month.ToString().Count() == 1) { monthS = "0" + month.ToString(); } else { monthS = month.ToString(); } string sequential = sk.Folio + "-" + monthS + yearDto.Description.ToString().Substring(2, 2) + "-" + count.ToString(); COUPON cou = new COUPON(); cou.Description = "carga de excel"; cou.IsActive = true; cou.Id_SoupKitchen = sk.Id; cou.Id_Month = Convert.ToInt32(item["Month"].ToString()); cou.Id_Year = Convert.ToInt32(item["Year"].ToString()); cou.Id_Ration = rat.Id; cou.Sequential = sequential; cou.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); cou.CreateUser = "******"; cou.CreateDate = DateTime.Now; db.COUPONs.Add(cou); db.SaveChanges(); #region Commented update option //RATION rat = db.RATIONs.FirstOrDefault(v => v.Id_Year == year && v.Id_Month == month && v.Id_SoupKitchen == sk.Id); //if (rat != null) //{ // rat.Description = "carga de excel"; // rat.IsActive = true; // rat.Id_SoupKitchen = sk.Id; // rat.Id_Month = Convert.ToInt32(item["Month"].ToString()); // rat.Id_Year = Convert.ToInt32(item["Year"].ToString()); // rat.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // rat.CreateUser = "******"; // rat.CreateDate = DateTime.Now; // rat.HasCoupon = false; // db.SaveChanges(); //} //else //{ // rat = new RATION(); // rat.Description = "carga de excel"; // rat.IsActive = true; // rat.Id_SoupKitchen = sk.Id; // rat.Id_Month = Convert.ToInt32(item["Month"].ToString()); // rat.Id_Year = Convert.ToInt32(item["Year"].ToString()); // rat.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // rat.CreateUser = "******"; // rat.CreateDate = DateTime.Now; // rat.HasCoupon = false; // db.RATIONs.Add(rat); // db.SaveChanges(); //} //COUPON cou = db.COUPONs.FirstOrDefault(v => v.Id_Year == year && v.Id_Month == month && v.Id_SoupKitchen == sk.Id); //COUPON cou = db.COUPONs.FirstOrDefault(v => v.Id_Ration == rat.Id); //if (cou != null) //{ // cou.Description = "carga de excel"; // cou.IsActive = true; // cou.Id_SoupKitchen = sk.Id; // cou.Id_Month = Convert.ToInt32(item["Month"].ToString()); // cou.Id_Year = Convert.ToInt32(item["Year"].ToString()); // cou.Id_Ration = rat.Id; // cou.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // cou.CreateUser = "******"; // cou.CreateDate = DateTime.Now; // //cou.HasCoupon = false; // db.SaveChanges(); //} //else //{ // cou = new COUPON(); // cou.Description = "carga de excel"; // cou.IsActive = true; // cou.Id_SoupKitchen = sk.Id; // cou.Id_Month = Convert.ToInt32(item["Month"].ToString()); // cou.Id_Year = Convert.ToInt32(item["Year"].ToString()); // cou.Id_Ration = rat.Id; // cou.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // cou.CreateUser = "******"; // cou.CreateDate = DateTime.Now; // db.COUPONs.Add(cou); // db.SaveChanges(); //} #endregion } } catch (Exception ex) { return(ex.Message); } } } return(result); }