public ActionResult TodayTotalSale() { var status = ""; if (Authenticated) { try { var Todaydate = DateTime.Now.Date; var TomorrowDate = DateTime.Now.Date.AddDays(1); var obj = db.SaleMains.Where(x => x.CreatedOn > Todaydate && x.CreatedOn < TomorrowDate && x.CreatedBy == ActiveUserId).Select(x => x.NetTotal); if (obj.Count() > 0) { var sale = new SaleMain(); sale.NetTotal = 0; foreach (var item in obj) { sale.NetTotal += item; } status = JsonConvert.SerializeObject(sale.NetTotal); } else { status = JsonConvert.SerializeObject(0); } } catch (Exception ex) { ApplicationExceptionLogging(ex.Message, ex.StackTrace, " AdminDashboard", "TodayTotalSale"); } } return(Content(status)); }
private void UpdateCustomerMain(PharmacyDbContext db) { SaleMain main = db.SaleMain.Where(a => a.CustomerId == _customerId).OrderByDescending(x => x.Id).FirstOrDefault(); main.DuePaid += Convert.ToDecimal(txtDuePay.Text); db.Entry(main).State = EntityState.Modified; }
private void SaveSaleMain(PharmacyDbContext db, string invoiceId) { string customerName = txtCustomerName.Text; string[] name = customerName.Split('.'); customerName = name[0].Trim(); SaleMain main = new SaleMain(); main.Id = Guid.NewGuid().ToString(); main.InvoiceId = invoiceId; main.CreatedBy = currentUser; main.CreatedDate = DateTime.Now; main.CustomerId = GetCustomerIdByName(customerName, db);//.GetCompanyId(txtGrandTotal.Text, db, currentUser); main.TotalAmount = Convert.ToDecimal(lblTotal.Text); main.Due = Convert.ToDecimal(txtDue.Text); main.Paid = Convert.ToDecimal(txtPaid.Text); main.Discount = Convert.ToDecimal(txtDiscount.Text); main.GrandTotal = (main.TotalAmount - main.Discount); main.Note = txtNote.Text; db.SaleMain.Add(main); SaveVoucher(main.GrandTotal, main.Paid, main.Due, main.CustomerId, invoiceId, db); SaveSaleSub(db, main.Id); }
protected void Page_Load(object sender, EventArgs e) { if (Request["BillNo"] != null && Request["BillNo"] != "") { var BillNo = int.Parse(Request["BillNo"].ToString()); var Client = db.ClientDetails.FirstOrDefault(); //ClientName.InnerText = Client.Name; ClientAddress.InnerText = Client.Address; ClientPhone.InnerText = Client.ContactNo; ClientEmail.InnerText = Client.Email; SaleMain objSaleMain = db.SaleMains.Where(x => x.Id == BillNo).SingleOrDefault(); Customer objCustomer = db.Customers.Where(x => x.Id == objSaleMain.CustomerId).FirstOrDefault(); if (objCustomer.IsResaler == true) { changeHide.Visible = false; } else { RemainBalHide.Visible = false; trPBal.Visible = false; } var RemainBalance = (db.CustomerPayments.Where(x => x.CustomerId == objCustomer.Id).Sum(cp => cp.Debit)) - (db.CustomerPayments.Where(x => x.CustomerId == objCustomer.Id).Sum(cp => cp.Credit)); List <SaleDetail> objSaleDetail = db.SaleDetails.Where(x => x.SMId == objSaleMain.Id).ToList(); var qty = 0; var str = db.InvoiceDetail(objSaleMain.Id); List <InvoiceDetail_Result> objList = new List <InvoiceDetail_Result>(); if (objCustomer.Id == 1) { dvCustomer.InnerHtml = "Customer: WalkIn "; } else { dvCustomer.InnerHtml = "Customer: " + objCustomer.Name; } dvDate.InnerHtml = "Date: " + DateTime.Parse(objSaleMain.CreatedOn.ToString()).Date.ToString("dd MMM yyyy"); dvTime.InnerHtml = "Time: " + DateTime.Parse(objSaleMain.CreatedOn.ToString()).ToString("hh:mm tt"); dvBillNo.InnerHtml = "Invoice # " + objSaleMain.InvoiceNo; foreach (InvoiceDetail_Result item in str) { objList.Add(item); } rptBillItems.DataSource = objList; rptBillItems.DataBind(); lbltotalbill.InnerHtml = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0"); decimal BillDisc = 0; if (objSaleMain.BillDiscountType == 1) // Amount { BillDisc = decimal.Parse(Convert.ToDecimal(objSaleMain.BillDiscount).ToString("#,##0")); } else // %age { BillDisc = (decimal.Parse(objSaleMain.TotalAfterDiscount.ToString()) * decimal.Parse(objSaleMain.BillDiscount.ToString())) / 100; } decimal strDisc = Convert.ToDecimal(objSaleMain.ItemDiscount) + Convert.ToDecimal(BillDisc); lbldiscount.InnerHtml = Convert.ToDecimal(strDisc).ToString("#,##0"); if (decimal.Parse(lbldiscount.InnerHtml) <= 0) { trdisc.Visible = false; } lblAdjustment.InnerHtml = Convert.ToDecimal(objSaleMain.Adjustment).ToString("#,##0"); if (decimal.Parse(lblAdjustment.InnerHtml) <= 0) { tradjustment.Visible = false; } var pBalance = (RemainBalance + objSaleMain.NetTotal) - objSaleMain.Recieved; if (pBalance < 0) { pBal.InnerHtml = '(' + Convert.ToDecimal(-pBalance).ToString("#,##0") + ')'; } else { pBal.InnerHtml = pBalance.ToString(); } lblnetpayable.InnerHtml = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0"); lblcashreceived.InnerHtml = Convert.ToDecimal(objSaleMain.Recieved).ToString("#,##0"); lblreturnback.InnerHtml = Convert.ToDecimal(objSaleMain.Change).ToString("#,##0"); if (RemainBalance < 0) { var negB = -1 * RemainBalance; rBal.InnerHtml = '(' + Convert.ToDecimal(negB).ToString("#,##0") + ')'; } else { rBal.InnerHtml = Convert.ToDecimal(RemainBalance).ToString("#,##0"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request["BillNo"] != null && Request["BillNo"] != "") { var BillNo = int.Parse(Request["BillNo"].ToString()); var Client = db.ClientDetails.FirstOrDefault(); ClientName.InnerText = Client.Name; ClientAddress.InnerText = Client.Address; ClientPhone.InnerText = Client.ContactNo; ClientEmail.InnerText = Client.Email; SaleMain objSaleMain = db.SaleMains.Where(x => x.Id == BillNo).SingleOrDefault(); Customer objCustomer = db.Customers.Where(x => x.Id == objSaleMain.CustomerId).FirstOrDefault(); //if (objCustomer.IsResaler == true) //{ // changeHide.Visible = false; //} //else //{ // RemainBalHide.Visible = false; // trPBal.Visible = false; //} var RemainBalance = (db.CustomerPayments.Where(x => x.CustomerId == objCustomer.Id).Sum(cp => cp.Debit)) - (db.CustomerPayments.Where(x => x.CustomerId == objCustomer.Id).Sum(cp => cp.Credit)); List <SaleDetail> objSaleDetail = db.SaleDetails.Where(x => x.SMId == objSaleMain.Id).ToList(); var qty = 0; var str = db.InvoiceDetailForReseller(objSaleMain.Id); List <InvoiceDetailForReseller_Result> objList = new List <InvoiceDetailForReseller_Result>(); dvCustomer.InnerHtml = "Customer: <b>" + objCustomer.Name + "</b>"; CusAddress.InnerHtml = "Address: " + objCustomer.Address; CusRef.InnerHtml = "Ref # : " + objSaleMain.Refrence; CusPhone.InnerHtml = "Phone # : " + objCustomer.Contact; dvDate.InnerHtml = "Date: <b>" + DateTime.Parse(objSaleMain.CreatedOn.ToString()).Date.ToString("dd MMM yyyy") + "</b>"; //dvTime.InnerHtml = "Time: " + DateTime.Parse(objSaleMain.CreatedOn.ToString()).ToString("hh:mm tt"); dvBillNo.InnerHtml = "Invoice # :<b>" + objSaleMain.InvoiceNo + "</b>"; foreach (InvoiceDetailForReseller_Result item in str) { objList.Add(item); } rptBillItems.DataSource = objList; rptBillItems.DataBind(); tPrice.Text = "Total : "; //lbltotalbill.InnerHtml = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0"); InvoBal.InnerText = "Invoice Bill # : " + Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0"); decimal BillDisc = 0; if (objSaleMain.BillDiscountType == 1) // Amount { BillDisc = decimal.Parse(Convert.ToDecimal(objSaleMain.BillDiscount).ToString()); } else // %age { BillDisc = (decimal.Parse(objSaleMain.TotalAfterDiscount.ToString()) * decimal.Parse(objSaleMain.BillDiscount.ToString())) / 100; } decimal strDisc = Convert.ToDecimal(objSaleMain.ItemDiscount) + Convert.ToDecimal(BillDisc); //lbldiscount.InnerHtml = Convert.ToDecimal(strDisc).ToString("#,##0"); tDiscount.Text = Convert.ToDecimal(strDisc).ToString("#,##0"); tQty.Text = Convert.ToDecimal(objSaleMain.TotalQty).ToString("#,##0"); tAmountAfterDiscount.Text = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0"); tAmount.Text = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0"); //if (decimal.Parse(lbldiscount.InnerHtml) <= 0) //{ // trdisc.Visible = false; //} //lblAdjustment.InnerHtml = Convert.ToDecimal(objSaleMain.Adjustment).ToString("#,##0"); //if (decimal.Parse(lblAdjustment.InnerHtml) <= 0) //{ // tradjustment.Visible = false; //} var pBalance = (RemainBalance + objSaleMain.NetTotal) - objSaleMain.Recieved; //if (pBalance < 0) //{ // pBal.InnerHtml = '(' + Convert.ToDecimal(-pBalance).ToString("#,##0") + ')'; //} //else //{ // pBal.InnerHtml = pBalance.ToString(); //} //lblnetpayable.InnerHtml = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0"); //lblcashreceived.InnerHtml = Convert.ToDecimal(objSaleMain.Recieved).ToString("#,##0"); //lblreturnback.InnerHtml = Convert.ToDecimal(objSaleMain.Change).ToString("#,##0"); if (RemainBalance < 0) { var negB = -1 * RemainBalance; //rBal.InnerHtml = '(' + Convert.ToDecimal(negB).ToString("#,##0") + ')'; CurBal.InnerText = "(" + Convert.ToDecimal(negB).ToString("#,##0") + ")"; } else { CurBal.InnerText = Convert.ToDecimal(RemainBalance).ToString("#,##0"); //rBal.InnerHtml = Convert.ToDecimal(RemainBalance).ToString("#,##0"); } if (pBalance < 0) { var negB = -1 * pBalance; //rBal.InnerHtml = '(' + Convert.ToDecimal(negB).ToString("#,##0") + ')'; PreBal.InnerText = "(" + Convert.ToDecimal(negB).ToString("#,##0") + ")"; } else { PreBal.InnerText = Convert.ToDecimal(pBalance).ToString("#,##0"); //rBal.InnerHtml = Convert.ToDecimal(RemainBalance).ToString("#,##0"); } InvoBal.InnerText = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0"); NetBill.InnerText = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0"); Rec.InnerText = Convert.ToDecimal(objSaleMain.Recieved).ToString("#,##0"); var Digits = n2w.ConvertAmount(Convert.ToDouble(objSaleMain.NetTotal)); DigitToWords.InnerText = Digits.ToString(); } }