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)); } }