public string GetCustomerIdByName(string name, PharmacyDbContext db) { if (name == "") { name = "Unknown"; } Customer customer = db.Customer.FirstOrDefault(i => i.Name == name); if (customer != null) { return(customer.Id); } else { customer = new Customer { Id = UniqueNumber.GenerateUniqueNumber(), Name = name, Mobile = txtPhone.Text, CreatedBy = currentUser, CreatedDate = DateTime.Now }; db.Customer.Add(customer); db.SaveChanges(); return(customer.Id); } }
private void btnRemove_Click(object sender, EventArgs e) { string recordId = SelectedRowId(); if (recordId == null) { return; } var choice = XtraMessageBox.Show("Sure want to delete this record?", "?? :D ??", MessageBoxButtons.YesNo); if (choice == DialogResult.Yes) { try { using (var context = PharmacyDbContext.Create()) { var commodity = new Commodity { Id = int.Parse(recordId) }; context.Commodities.Attach(commodity); context.Commodities.Remove(commodity); context.SaveChanges(); } XtraMessageBox.Show("Remove successfully", "Pharmacy management"); RefillGrid(); } catch (Exception ex) { XtraMessageBox.Show($"Some error occured\nDetails:\n{ex.Message}", "Xome Pug Found"); } } }
private void btnTodayDue_Click(object sender, EventArgs e) { DateTime today = DateTime.Today; PharmacyDbContext db = new PharmacyDbContext(); int rowNo = 1; var data = db.Voucher .ToList() .Where(d => d.CreatedDate.Date == today.Date && d.CustomerId != null) .GroupBy(o => o.CustomerId) .Select(x => new { SL = rowNo++, CustomerId = x.Key, CustomerName = x.Select(a => a.Customer.Name).FirstOrDefault(), Mobile = x.Select(a => a.Customer.Mobile).FirstOrDefault(), Due = x.Where(c => c.GLCode == GLCode.AccountReceivable).Sum(a => a.Dr - a.Cr) < 0 ? 0 : x.Where(c => c.GLCode == GLCode.AccountReceivable).Sum(a => a.Dr - a.Cr), Paid = x.Where(c => c.GLCode == GLCode.Cash).Sum(a => a.Dr), TotalSale = x.Where(c => c.GLCode == GLCode.SaleMedicine).Sum(a => a.Cr), Date = x.Select(a => a.CreatedDate).FirstOrDefault().ToString("d") }).ToList(); db.Dispose(); dgvDue.Columns.Clear(); dgvDue.DataSource = data; lblDueTotal.Text = data.Sum(x => x.Due).ToString(); // db.Voucher.Where(a => a.GLCode == GLCode.AccountReceivable && a.CustomerId != null).ToList().Sum(x => x.Dr-x.Cr).ToString(); lblPaidTotal.Text = data.Sum(x => x.Paid).ToString(); //db.Voucher.Where(a=>a.GLCode == GLCode.Cash && a.CustomerId != null).ToList().Sum(x => x.Dr).ToString(); lblTotal.Text = data.Sum(x => x.TotalSale).ToString(); AddButton(); MakeFullWidthScreen(); }
private void btnLogin_Click(object sender, EventArgs e) { string username = txtUserName.Text; string password = txtPassword.Text; try { PharmacyDbContext db = new PharmacyDbContext(); AppUser user = db.AppUser.ToList() .FirstOrDefault(x => x.Email == username && x.Password == password); if (user != null) { Home home = new Home(username); home.Show(); this.Hide(); } else { MessageBox.Show("Login failed"); } } catch (Exception exception) { Console.WriteLine(exception); } }
private void btnSave_Click(object sender, EventArgs e) { //try //{ PharmacyDbContext db = new PharmacyDbContext(); foreach (ListViewItem item in lvMedicine.Items) { Medicine medicine = new Medicine(); medicine.Name = item.SubItems[2].Text; medicine.Id = UniqueNumber.GenerateUniqueNumber(); medicine.CreatedBy = currentUser; medicine.CreatedDate = DateTime.Now; medicine.GroupId = GroupFactory.GetGroupId(item.SubItems[3].Text, currentUser); medicine.CompanyId = CompanyFactory.GetCompanyId(item.SubItems[4].Text, currentUser); db.Medicine.Add(medicine); } db.SaveChanges(); db.Dispose(); MessageBox.Show(@"Save successful!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); lvMedicine.Items.Clear(); //} //catch (Exception exception) //{ // MessageBox.Show("Saving Error:" + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); //} }
private void SaveVoucher(decimal total, string invoiceId, PharmacyDbContext db) { int count = 1; //Debit Entry Voucher voucher = new Voucher { Id = Guid.NewGuid().ToString(), EntryNo = count++, GLCode = GLCode.Expense, Dr = total, Cr = 0, InvoiceId = invoiceId, CreatedDate = DateTime.Now, CreatedBy = currentUser }; db.Voucher.Add(voucher); //Credit Entry Voucher voucherCr1 = new Voucher { Id = Guid.NewGuid().ToString(), Cr = total, GLCode = GLCode.Cash, Dr = 0, EntryNo = count++, InvoiceId = invoiceId, CreatedDate = DateTime.Now, CreatedBy = currentUser }; db.Voucher.Add(voucherCr1); }
private void btnSave_Click(object sender, EventArgs e) { string expenseType = txtExpenseType.Text; if (expenseType == "") { MessageBox.Show("Expense can't be empty!", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } PharmacyDbContext db = new PharmacyDbContext(); ExpenseType expenseTypes = new ExpenseType() { CreatedBy = currentUser, CreatedDate = DateTime.Now, Id = Guid.NewGuid().ToString(), Type = expenseType }; db.ExpenseType.Add(expenseTypes); db.SaveChanges(); db.Dispose(); MessageBox.Show("Save successful!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); txtExpenseType.Text = ""; }
private void GetAutocompleteForMedicine(PharmacyDbContext db) { var source = new AutoCompleteStringCollection(); source.AddRange(db.Medicine.ToList().Select(x => x.Name).ToArray()); txtMedicine.AutoCompleteCustomSource = source; }
private void GetAutocompleteForCustomer(PharmacyDbContext db) { var source = new AutoCompleteStringCollection(); source.AddRange(db.Customer.ToList().Select(x => x.Name + ". Mobile: " + x.Mobile).ToArray()); txtCustomerName.AutoCompleteCustomSource = source; }
private void SaveVoucher(PharmacyDbContext db, string invoiceId, decimal amount) { int count = 1; //Debit entry Voucher voucher = new Voucher { Id = Guid.NewGuid().ToString(), CustomerId = _customerId, EntryNo = count++, GLCode = GLCode.Cash, Dr = amount, Cr = 0, InvoiceId = invoiceId, CreatedDate = DateTime.Now, CreatedBy = currentUser }; db.Voucher.Add(voucher); //credit entry Voucher voucherCr2 = new Voucher { Id = Guid.NewGuid().ToString(), CustomerId = _customerId, Cr = amount, GLCode = GLCode.AccountReceivable, Dr = 0, InvoiceId = invoiceId, EntryNo = count, CreatedDate = DateTime.Now, CreatedBy = currentUser }; db.Voucher.Add(voucherCr2); }
public string GetMedicinePriceByName(string name) { PharmacyDbContext db = new PharmacyDbContext(); string rate = db.Medicine.Where(x => x.Name == name).Select(p => p.GroupId).FirstOrDefault(); return(rate); }
private string GetGroup(string id) { PharmacyDbContext db = new PharmacyDbContext(); string name = db.Groups.Where(g => g.Id == id).Select(s => s.Name).FirstOrDefault(); db.Dispose(); return(name); }
private string GetMedicineName(string id) { PharmacyDbContext db = new PharmacyDbContext(); string name = db.Medicine.Where(s => s.Id == id).Select(a => a.Name).FirstOrDefault(); db.Dispose(); return(name); }
private void Autocomplete() { PharmacyDbContext db = new PharmacyDbContext(); var source = new AutoCompleteStringCollection(); source.AddRange(db.ExpenseType.ToList().Select(x => x.Type).ToArray()); txtExpenseType.AutoCompleteCustomSource = source; }
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 txtMedicine_Leave(object sender, System.EventArgs e) { PharmacyDbContext db = new PharmacyDbContext(); string medicine = txtMedicine.Text; decimal rate = db.Medicine.Where(x => x.Name == medicine).Select(o => o.UnitPrice).FirstOrDefault(); txtUnitPrice.Text = rate.ToString(); }
private void btnPay_Click(object sender, EventArgs e) { PharmacyDbContext db = new PharmacyDbContext(); SaveInvoice(db); db.SaveChanges(); db.Dispose(); MessageBox.Show("Save successful", "Paid!", MessageBoxButtons.OK, MessageBoxIcon.Hand); }
private void SetLabelValue() { PharmacyDbContext db = new PharmacyDbContext(); lblMedicine.Text = db.Medicine.Count().ToString(); lblGroup.Text = db.Groups.Count().ToString(); lblcompany.Text = db.Company.Count().ToString(); db.Dispose(); }
public SaveMedicine(string currentUser) { this.currentUser = currentUser; InitializeComponent(); PharmacyDbContext db = new PharmacyDbContext(); GetAutocompleteForCompany(db); GetAutocompleteForGroup(db); db.Dispose(); }
private decimal GetPurchaseMedicine(string medicineId) { PharmacyDbContext db = new PharmacyDbContext(); var count = db.PurchaseSub.Where(m => m.MedicinId == medicineId) .ToList() .Sum(x => x.Quantity); db.Dispose(); return(count); }
private bool hasMadicineInStore(string medicine, string qty) { PharmacyDbContext db = new PharmacyDbContext(); string medicineId = MedicineFactory.GetMedicineIdByName(medicine, db); int totalPurchased = db.PurchaseSub.Where(i => i.MedicinId == medicineId).ToList().Sum(o => o.Quantity); int totalSale = db.SaleSub.Where(i => i.MedicinId == medicineId).ToList().Sum(o => o.Quantity); bool result = totalPurchased > (totalSale + Convert.ToInt32(qty)); return(result); }
private void GetDueDetails(string mainId) { PharmacyDbContext db = new PharmacyDbContext(); int count = 1; ShowExpenseDetails expenseDetails = new ShowExpenseDetails(mainId); expenseDetails.ShowDialog(); expenseDetails.FormClosed += DueDetails_FormClosed; }
public Salemedicine(string user) { currentUser = user; InitializeComponent(); PharmacyDbContext db = new PharmacyDbContext(); GetAutocompleteForMedicine(db); GetAutocompleteForCustomer(db); db.Dispose(); }
private void dgvExpense_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 7) { PharmacyDbContext db = new PharmacyDbContext(); DataGridView va = sender as DataGridView; string purchaseId = va.Rows[e.RowIndex].Cells[1].Value.ToString(); GetDueDetails(purchaseId); } }
private void SaveInvoice(PharmacyDbContext db) { Invoice invoice = new Invoice(); invoice.Id = Guid.NewGuid().ToString(); invoice.CreatedDate = DateTime.Now; invoice.CreatedBy = currentUser; invoice.IsActive = true; db.Invoice.Add(invoice); SaveSaleMain(db, invoice.Id); }
private void btnSubmit_click(object sender, EventArgs e) { PharmacyDbContext db = new PharmacyDbContext(); SaveInvoice(db); db.SaveChanges(); db.Dispose(); MessageBox.Show("Save successful!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearFields(); }
private void UpdateUnitPrice(string medicineName, string rate, DateTime exDate) { PharmacyDbContext db = new PharmacyDbContext(); decimal price = Convert.ToDecimal(rate); Medicine medicine = db.Medicine.FirstOrDefault(x => x.Name == medicineName); medicine.UnitPrice = price; medicine.ExpiredDate = exDate; db.SaveChanges(); db.Dispose(); }
public ShowDueDetails(List <SaleDetail> saleDetail, string customerId, string user) { currentUser = user; _customerId = customerId; InitializeComponent(); dgvSaleDetails.DataSource = saleDetail; PharmacyDbContext db = new PharmacyDbContext(); lblDue.Text = Convert.ToString(db.Voucher .Where(x => x.GLCode == GLCode.AccountReceivable && x.CustomerId == _customerId) .Sum(a => a.Dr - a.Cr)); }
public PurchaseMedicine(string user) { currentUser = user; InitializeComponent(); PharmacyDbContext db = new PharmacyDbContext(); GetAutocompleteForMedicine(db); GetAutocompleteForSupplier(db); GetAutocompleteForCompany(db); GetAutocompleteForGroup(db); db.Dispose(); }
private void btnSubmit_click(object sender, EventArgs e) { PharmacyDbContext db = new PharmacyDbContext(); SaveInvoice(db); db.SaveChanges(); db.Dispose(); MessageBox.Show("Save successful!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); btnPrint.Enabled = true; txtNote.Text = ""; lvExpense.Items.Clear(); }