public StringBuilder GenerateValueMealText(CSHVMLP0 ValueMeal)
{
StringBuilder sb = new StringBuilder();
sb.Append("05,");
sb.Append(ValueMeal.STATUS.Trim() + ",");
sb.Append(ValueMeal.VMLNUM.ToString() + ",");
if (ValueMeal.VMLNAM != null)
{
sb.Append(ValueMeal.VMLMIC.ToString() + ",");
}
else
{
sb.Append(",");
}
if (ValueMeal.VMLQUA != null)
{
sb.Append(ValueMeal.VMLQUA.ToString() + System.Environment.NewLine);
}
else
{
sb.Append(System.Environment.NewLine);
}
return(sb);
}
public bool UpdateValueMeal(ValueMealViewModel VMViewModel, string user)
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
if (VMViewModel.VMLNUM == null || VMViewModel.VMLNUM.Equals(""))
{
return(false);
}
// Existing
foreach (var v in VMViewModel.MenuItemList)
{
// Delete overwritten MIMMIC entry
if (!v.PreviousMIMMIC.Equals(v.MIMMIC) && db.CSHVMLP0.Where(o => o.VMLNUM.ToString().Equals(VMViewModel.VMLNUM)).Any())
{
CSHVMLP0 VMRowToDelete = db.CSHVMLP0.Single(o => o.VMLID.Equals(VMViewModel.VMLNUM + v.PreviousMIMMIC));
db.CSHVMLP0.Remove(VMRowToDelete);
db.SaveChanges();
}
// Skip if MIMMIC is null
if (v.MIMMIC == null || v.MIMMIC.Equals(""))
{
continue;
}
CSHVMLP0 VMRow = new CSHVMLP0();
VMRow.VMLID = VMViewModel.VMLNUM + v.MIMMIC;
VMRow.VMLNUM = int.Parse(VMViewModel.VMLNUM);
VMRow.VMLNAM = VMViewModel.VMLNAM.ToString();
VMRow.VMLMIC = int.Parse(v.MIMMIC);
if (v.VMLQUA != null && !v.VMLQUA.Equals(""))
{
VMRow.VMLQUA = int.Parse(v.VMLQUA);
}
VMRow.VMLPRI = double.Parse(VMViewModel.VMLPRI);
VMRow.VMLPRO = double.Parse(VMViewModel.VMLPRO);
try
{
if (db.CSHVMLP0.Where(o => o.VMLID.Equals(VMRow.VMLID)).Any())
{
CSHVMLP0 rowToDelete = db.CSHVMLP0.Single(o => o.VMLID.Equals(VMRow.VMLID));
db.CSHVMLP0.Remove(rowToDelete);
VMRow.STATUS = "E";
db.CSHVMLP0.Add(VMRow);
}
else
{
VMRow.STATUS = "A";
db.CSHVMLP0.Add(VMRow);
}
db.SaveChanges();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Source);
System.Diagnostics.Debug.WriteLine(e.Message);
System.Diagnostics.Debug.WriteLine(e.StackTrace);
System.Diagnostics.Debug.WriteLine(e.InnerException);
Exception f = e.InnerException;
while (f != null)
{
System.Diagnostics.Debug.WriteLine("INNER:");
System.Diagnostics.Debug.WriteLine(f.Message);
System.Diagnostics.Debug.WriteLine(f.Source);
f = f.InnerException;
}
System.Diagnostics.Debug.WriteLine(e.Data);
return(false);
}
}
// New
if (!VMViewModel.MIMMIC[0].Equals(""))
{
for (int i = 0; i < VMViewModel.MIMMIC.Count(); i++)
{
CSHVMLP0 VMRow = new CSHVMLP0();
VMRow.VMLID = VMViewModel.VMLNUM + VMViewModel.MIMMIC[i];
VMRow.VMLNUM = int.Parse(VMViewModel.VMLNUM);
VMRow.VMLNAM = VMViewModel.VMLNAM.ToString();
VMRow.VMLMIC = int.Parse(VMViewModel.MIMMIC[i]);
if (VMViewModel.VMLQUA[i] != null && !VMViewModel.VMLQUA[i].Equals(""))
{
VMRow.VMLQUA = int.Parse(VMViewModel.VMLQUA[i]);
}
VMRow.VMLPRI = double.Parse(VMViewModel.VMLPRI);
VMRow.VMLPRO = double.Parse(VMViewModel.VMLPRO);
try
{
if (db.CSHVMLP0.Where(o => o.VMLID.Equals(VMRow.VMLID)).Any())
{
CSHVMLP0 rowToDelete = db.CSHVMLP0.Single(o => o.VMLID.Equals(VMRow.VMLID));
db.CSHVMLP0.Remove(rowToDelete);
VMRow.STATUS = "E";
db.CSHVMLP0.Add(VMRow);
}
else
{
VMRow.STATUS = "A";
db.CSHVMLP0.Add(VMRow);
}
db.SaveChanges();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Source);
System.Diagnostics.Debug.WriteLine(e.Message);
System.Diagnostics.Debug.WriteLine(e.StackTrace);
System.Diagnostics.Debug.WriteLine(e.InnerException);
Exception f = e.InnerException;
while (f != null)
{
System.Diagnostics.Debug.WriteLine("INNER:");
System.Diagnostics.Debug.WriteLine(f.Message);
System.Diagnostics.Debug.WriteLine(f.Source);
f = f.InnerException;
}
System.Diagnostics.Debug.WriteLine(e.Data);
return(false);
}
}
}
return(true);
}
}
