public HttpResponseMessage Post(DailyEssential item)
{
try
{
if (item != null)
{
var d = context.AddDailyItem(item);
if (d == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, false));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, d));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, false));
}
}
catch (Exception ex)
{
throw;
}
}
public HttpResponseMessage Put(DailyItemEdit item, string datefrom, string dateto)
{
try
{
var firstDay = Convert.ToDateTime(datefrom.Split(new string[] { "GMT" }, 0)[0]);
var lastDay = Convert.ToDateTime(dateto.Split(new string[] { "GMT" }, 0)[0]);
var allDates = new List <DateTime>();
for (DateTime date = firstDay; date <= lastDay; date = date.AddDays(1))
{
allDates.Add(date);
}
DailyEssential dailyitems = context.DailyEssentialDb.Where(x => x.CustMobile == item.CustMobile && x.ItemId == item.ItemId && x.EndDate > lastDay).SingleOrDefault();
var d = indianTime.Date;
if (dailyitems != null && d.AddDays(1) < dailyitems.EndDate.Date)
{
foreach (var Edate in allDates)
{
TimeSpan tsmin = new TimeSpan(00, 00, 0);
TimeSpan tsmax = new TimeSpan(23, 59, 59);
DateTime sd = Edate.Date + tsmin;
DateTime ed = Edate.Date + tsmax;
var day = Edate.DayOfWeek;
DailyItemEdit DE = context.DailyItemCancelDb.Where(x => x.CustMobile == item.CustMobile && x.ItemId == item.ItemId && x.EditDate <ed && x.EditDate> sd).SingleOrDefault();
if (DE == null)
{
if (Convert.ToString(day) == "Monday")
{
if (dailyitems.Monday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Tuesday")
{
if (dailyitems.Tuesday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Wednesday")
{
if (dailyitems.Wednesday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Thursday")
{
if (dailyitems.Thursday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Friday")
{
if (dailyitems.Friday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Saturday")
{
if (dailyitems.Saturday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Sunday")
{
if (dailyitems.Sunday == true)
{
item.CreatedDate = indianTime;
item.UpdatedDate = indianTime;
item.EditDate = Edate;
context.DailyItemCancelDb.Add(item);
int id = context.SaveChanges();
}
}
}
else
{
///////////////// else update
if (Convert.ToString(day) == "Monday")
{
if (dailyitems.Monday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Tuesday")
{
if (dailyitems.Tuesday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Wednesday")
{
if (dailyitems.Wednesday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Thursday")
{
if (dailyitems.Thursday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Friday")
{
if (dailyitems.Friday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Saturday")
{
if (dailyitems.Saturday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
else if (Convert.ToString(day) == "Sunday")
{
if (dailyitems.Sunday == true)
{
DE.UpdatedDate = indianTime;
DE.Qty = item.Qty;
context.DailyItemCancelDb.Attach(DE);
context.Entry(DE).State = EntityState.Modified;
context.SaveChanges();
}
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, item));
}
return(Request.CreateResponse(HttpStatusCode.BadRequest, false));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, false));
}
}
