public HttpResponseMessage Delete(int Id)
{
Data.TrnSale DeleteSale = db.TrnSales.Where(d => d.Id == Id).First();
if (DeleteSale != null)
{
db.TrnSales.DeleteOnSubmit(DeleteSale);
try
{
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public int Post(Models.Sales value)
{
try
{
Data.TrnSale NewSale = new Data.TrnSale();
SqlDateTime SalesDate = new SqlDateTime(new DateTime(Convert.ToDateTime(value.SalesDate).Year, +
Convert.ToDateTime(value.SalesDate).Month, +
Convert.ToDateTime(value.SalesDate).Day));
SqlDateTime RenewalDate = new SqlDateTime(new DateTime(Convert.ToDateTime(value.RenewalDate).Year, +
Convert.ToDateTime(value.RenewalDate).Month, +
Convert.ToDateTime(value.RenewalDate).Day));
SqlDateTime ExpiryDate = new SqlDateTime(new DateTime(Convert.ToDateTime(value.ExpiryDate).Year, +
Convert.ToDateTime(value.ExpiryDate).Month, +
Convert.ToDateTime(value.ExpiryDate).Day));
NewSale.ProductPackageId = value.ProductPackageId;
NewSale.UserId = value.UserId;
NewSale.SalesNumber = value.SalesNumber;
NewSale.SalesDate = SalesDate.Value;
NewSale.RenewalDate = RenewalDate.Value;
NewSale.ExpiryDate = ExpiryDate.Value;
NewSale.Particulars = value.Particulars;
NewSale.Quantity = value.Quantity;
NewSale.Price = value.Price;
NewSale.Amount = value.Amount;
NewSale.IsActive = value.IsActive;
NewSale.IsRefunded = value.IsRefunded;
db.TrnSales.InsertOnSubmit(NewSale);
db.SubmitChanges();
return(NewSale.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage postSales(Entities.TrnSales objSales)
{
var defaultPeriod = from d in db.MstPeriods select d;
var lastSINumber = from d in db.TrnSales.OrderByDescending(d => d.Id) select d;
var salesInNumberResult = defaultPeriod.FirstOrDefault().Period + "-000001";
if (lastSINumber.Any())
{
var salesInNumberSplitStrings = lastSINumber.FirstOrDefault().SalesNumber;
Int32 secondIndex = salesInNumberSplitStrings.IndexOf('-', salesInNumberSplitStrings.IndexOf('-'));
var salesInNumberSplitStringValue = salesInNumberSplitStrings.Substring(secondIndex + 1);
var salesInNumber = Convert.ToInt32(salesInNumberSplitStringValue) + 000001;
salesInNumberResult = defaultPeriod.FirstOrDefault().Period + "-" + FillLeadingZeroes(salesInNumber, 6);
}
try
{
Data.TrnSale newSales = new Data.TrnSale();
newSales.PeriodId = objSales.PeriodId;
newSales.SalesDate = objSales.SalesDate;
newSales.SalesNumber = salesInNumberResult;
newSales.ManualInvoiceNumber = objSales.ManualInvoiceNumber;
newSales.Amount = objSales.Amount;
newSales.TableId = objSales.TableId;
newSales.CustomerId = objSales.CustomerId;
newSales.AccountId = objSales.AccountId;
newSales.TermId = objSales.TermId;
newSales.DiscountId = objSales.DiscountId;
newSales.SeniorCitizenId = objSales.SeniorCitizenId;
newSales.SeniorCitizenName = objSales.SeniorCitizenName;
newSales.SeniorCitizenAge = objSales.SeniorCitizenAge;
newSales.Remarks = objSales.Remarks;
newSales.SalesAgent = objSales.SalesAgent;
newSales.TerminalId = objSales.TerminalId;
newSales.PreparedBy = objSales.PreparedBy;
newSales.CheckedBy = objSales.CheckedBy;
newSales.ApprovedBy = objSales.ApprovedBy;
newSales.IsLocked = objSales.IsLocked;
newSales.IsCancelled = objSales.IsCancelled;
newSales.PaidAmount = objSales.PaidAmount;
newSales.CreditAmount = objSales.CreditAmount;
newSales.DebitAmount = objSales.DebitAmount;
newSales.BalanceAmount = objSales.BalanceAmount;
newSales.EntryUserId = UserId();
newSales.EntryDateTime = DateTime.Today;
newSales.UpdateUserId = UserId();
newSales.UpdateDateTime = DateTime.Today;
newSales.Pax = objSales.Pax;
newSales.TableStatus = objSales.TableStatus;
newSales.DiscountedPax = objSales.DiscountedPax;
db.TrnSales.InsertOnSubmit(newSales);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, newSales.Id));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, e));
}
}
