// POST api/SalesQuotation
public HttpResponseMessage PostSalesQuotation(SalesQuotation salesquotation)
{
if (ModelState.IsValid)
{
FiscalYear fiscalYear = db.FiscalYears.Where(f =>( EntityFunctions.TruncateTime(f.StartDate) <= DateTime.Now) && (EntityFunctions.TruncateTime(f.EndDate) >= DateTime.Now)).SingleOrDefault();
SalesQuotationCategory salesQuotationCategory = db.SalesQuotationCategories.Where(sq => sq.SalesQuotationCategoryID == salesquotation.SalesQuotationCategoryID).SingleOrDefault();
Collaborator custormer = db.Collaborators.Where(c => c.CollaboratorID == salesquotation.CustomerID).Include(c => c.CustomerType).SingleOrDefault();
string CustomCode = salesQuotationCategory.SalesQuotationCategoryCode + "/" + custormer.CustomerType.CustomerTypeID.ToString().PadLeft(3, '0') + "/" + fiscalYear.FiscalYearName + "/" + custormer.CollaboratorCode + "-";
int? MaxCode = Convert.ToInt32((db.SalesQuotations.Where(r => r.SalesQuotationCode.StartsWith(CustomCode)).Select(r => r.SalesQuotationCode.Substring(CustomCode.Length, 8)).ToList()).Max());
string SQCode = CustomCode + ((MaxCode + 1).ToString()).PadLeft(8, '0');
salesquotation.SalesQuotationCode = SQCode;
salesquotation.InsertBy = loginUser.UserID;
db.SalesQuotations.Add(salesquotation);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, salesquotation);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = salesquotation.SalesQuotationID }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
// PUT api/SalesQuotation/5
public HttpResponseMessage PutSalesQuotation(long id, SalesQuotation salesquotation)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != salesquotation.SalesQuotationID)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
salesquotation.Collaborator = null;
salesquotation.ProcesStatus = null;
salesquotation.UpdateBy = loginUser.UserID;
db.Entry(salesquotation).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}