public VentasCentro <Center> FillSalesCenter(VentasCentro <Center> ventasCentro, int mode = -1)
{
foreach (Center center in ventasCentro.Items)
{
foreach (Subcenter subcenter in center.Subcenters)
{
List <SalesCountedCenter> oSales = new List <SalesCountedCenter>();
foreach (LabelAndValue <DateTime> date in ventasCentro.Dates)
{
if (mode == 1)
{
SalesCountedCenter sale = subcenter.SalesCountedCenters.SingleOrDefault(o => o.PostingDate.Value.Day == date.Value.Day);
if (sale == null)
{
oSales.Add(new SalesCountedCenter());
}
else
{
oSales.Add(sale);
}
}
else if (mode == 7)
{
SalesCountedCenter weekSale = new SalesCountedCenter()
{
Amount = 0
};
foreach (SalesCountedCenter sales in subcenter.SalesCountedCenters)
{
if (sales.PostingDate.Value >= date.Value && sales.PostingDate.Value <= Convert.ToDateTime(date.Data))
{
weekSale.Amount += sales.Amount;
}
}
oSales.Add(weekSale);
}
else if (mode == 12)
{
SalesCountedCenter monthSale = new SalesCountedCenter()
{
Amount = 0
};
foreach (SalesCountedCenter sales in subcenter.SalesCountedCenters)
{
if (sales.PostingDate.Value >= date.Value &&
sales.PostingDate.Value <= new DateTime(date.Value.Year, date.Value.Month, DateTime.DaysInMonth(date.Value.Year, date.Value.Month)))
{
monthSale.Amount += sales.Amount;
}
}
oSales.Add(monthSale);
}
}
subcenter.SalesCountedCenters = oSales;
}
}
return(ventasCentro);
}
public SalesCountedCenter_View(SalesCountedCenter sc)
{
EntryNo = sc.EntryNo;
CenterCode = sc.CenterCode ?? "";
SubcenterType = sc.SubcenterType ?? "";
SubcenterCode = sc.SubcenterCode ?? "";
PostingDate = sc.PostingDate ?? DateTimeOffset.MinValue;
Schedule = sc.Schedule ?? "";
Amount = sc.Amount ?? 0;
InitialTicket = sc.InitialTicket ?? "";
FinalTicket = sc.FinalTicket ?? "";
PostingStatus = sc.PostingStatus ?? "";
ReadingDate = sc.ReadingDate ?? DateTimeOffset.MinValue;
}
public ResultAndError <SalesCountedCenter> Add(SalesCountedCenter c)
{
ResultAndError <SalesCountedCenter> result = new ResultAndError <SalesCountedCenter>();
try
{
db.SalesCountedCenters.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public bool DeleteMulti(IEnumerable <string> SalesCountedCenters)
{
List <SalesCountedCenter> oSalesCountedCenters = new List <SalesCountedCenter>();
foreach (string SalesCountedCenterNo in SalesCountedCenters)
{
SalesCountedCenter oSalesCountedCenter = Get(SalesCountedCenterNo);
if (oSalesCountedCenter != null)
{
oSalesCountedCenters.Add(oSalesCountedCenter);
}
}
db.SalesCountedCenters.RemoveRange(oSalesCountedCenters);
db.SaveChanges();
return(true);
}
public bool UpdateMulti(IEnumerable <SalesCountedCenter> oSalesCountedCenters, bool insertIfNoExists = false)
{
foreach (SalesCountedCenter SalesCountedCenter in oSalesCountedCenters)
{
SalesCountedCenter old = Get(SalesCountedCenter.EntryNo.ToString());
if (old == null && insertIfNoExists)
{
Add(SalesCountedCenter);
}
else
{
db.Entry(old).CurrentValues.SetValues(SalesCountedCenter);
}
}
db.SaveChanges();
return(true);
}
public ResultAndError <bool> UpdateReadingDate(IEnumerable <int> centersNo, DateTimeOffset readingDate)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
foreach (int no in centersNo)
{
SalesCountedCenter oSalesCountedCenter = Get(no.ToString());
oSalesCountedCenter.ReadingDate = readingDate;
db.SaveChanges();
}
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> Delete(string id)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
SalesCountedCenter SalesCountedCenter = Get(id);
if (SalesCountedCenter == null)
{
return(result.AddError("No se encontro la tarifa con el id " + id));
}
db.SalesCountedCenters.Remove(SalesCountedCenter);
db.SaveChanges();
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <SalesCountedCenter> Update(SalesCountedCenter cr, bool insertIfNoExists = false)
{
ResultAndError <SalesCountedCenter> result = new ResultAndError <SalesCountedCenter>();
try
{
SalesCountedCenter old = Get(cr.EntryNo.ToString());
if (old == null && insertIfNoExists)
{
return(Add(cr));
}
db.Entry(old).CurrentValues.SetValues(cr);
db.SaveChanges();
return(result.AddResult(cr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public IActionResult UpdSalesCountedCenter([FromBody] SalesCountedCenter SalesCountedCenter, bool insertIfNoExists = false)
{
return(Ok(sBS.Update(SalesCountedCenter, insertIfNoExists)));
}
