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