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);
}
