// POST api/SalesBill
public HttpResponseMessage PostSalesBill(SalesBill salesbill)
{
if (ModelState.IsValid)
{
FiscalYear fiscalYear = db.FiscalYears.Where(f => (EntityFunctions.TruncateTime(f.StartDate) <= DateTime.Now) && (EntityFunctions.TruncateTime(f.EndDate) >= DateTime.Now)).SingleOrDefault();
SalesBillCategory salesBillCategory = db.SalesBillCategories.Where(sb => sb.SalesBillCategoryID == salesbill.SalesBillCategoryID).SingleOrDefault();
Collaborator custormer = db.Collaborators.Where(c => c.CollaboratorID == salesbill.CustomerID).Include(c => c.CustomerType).SingleOrDefault();
string CustomCode = salesBillCategory.SalesBillCategoryCode + "/" + custormer.CustomerType.CustomerTypeID.ToString().PadLeft(3, '0') + "/" + fiscalYear.FiscalYearName + "/" + custormer.CollaboratorCode + "-";
//string CustomCode = "SB-" + DateTime.Now.ToString("yyyyMMdd");
ControlVoucher controlvoucher = new ControlVoucher();
long SalesCOAID =(long)db.AccCOAMappings.Where(a => a.AccCOAConfigID == 18 && a.CompanyID == loginUser.CompanyID).Select(a=>a.AccCOAID).FirstOrDefault();
long CustomerCOAID = (long)db.Collaborators.Where(c => c.CollaboratorID == salesbill.CustomerID).Select(c => c.CustomerCOAID).FirstOrDefault();
salesbill.VoucherNO = controlvoucher.CreateVoucher(CustomerCOAID, SalesCOAID, (decimal)salesbill.GrandTotal, (long)1, (DateTime)salesbill.Date);
int? MaxCode = Convert.ToInt32((db.SalesBills.Where(r => r.SalesBillCode.StartsWith(CustomCode)).Select(r => r.SalesBillCode.Substring(CustomCode.Length, 8)).ToList()).Max());
string SBCode = CustomCode + ((MaxCode + 1).ToString()).PadLeft(8, '0');
salesbill.SalesBillCode = SBCode;
salesbill.Date = DateTime.Now.ToLocalTime();
salesbill.InsertBy = loginUser.UserID;
db.SalesBills.Add(salesbill);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, salesbill);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = salesbill.SalesBillID }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
// PUT api/SalesBill/5
public HttpResponseMessage PutSalesBill(long id, SalesBill salesbill)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != salesbill.SalesBillID)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
salesbill.Collaborator = null;
salesbill.ProcesStatus = null;
salesbill.UpdateBy = loginUser.UserID;
db.Entry(salesbill).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
