protected void txtRfid_TextChanged(object sender, EventArgs e) { try { if (txtRfid.Text == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Error','Please Enter Rfid Number')", true); } else { Membership objMember = ProductSalesController.GetMembersByRfid(txtRfid.Text); if (objMember != null) { pnlMember.Visible = true; MemberId = objMember.ID; MemberItemTotalSale objTotalsale = ProductSalesController.GetTotalSalesbyMemberId(MemberId); if (objTotalsale == null) { txtMemName.Text = objMember.Lead.firstName + " " + objMember.Lead.lastName; txtMemCnt.Text = objMember.Lead.mobileNumber; txtMemDOB.Text = ((DateTime)objMember.Lead.dateOfBirth).ToString("dd/MM/yyyy"); } else if (objTotalsale != null && objTotalsale.isPaid) { txtMemName.Text = objMember.Lead.firstName + " " + objMember.Lead.lastName; txtMemCnt.Text = objMember.Lead.mobileNumber; txtMemDOB.Text = ((DateTime)objMember.Lead.dateOfBirth).ToString("dd/MM/yyyy"); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Error','Previous Payment of this Member is not paid. No more sales Possible')", true); ClearMemberValues(); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Error','Incorrect Rfid Number or Member is Deactivated')", true); ClearMemberValues(); } } } catch (Exception ex) { throw ex; } }
public MemberItemTotalSale UpdateTotalSale(MemberItemTotalSale objTotalSales) { try { objTotalSales.updateDate = DateTime.Now; using (var context = new FitnessCenterEntities()) { context.MemberItemTotalSales.Attach(context.MemberItemTotalSales.Single(x => x.ID == objTotalSales.ID)); context.MemberItemTotalSales.ApplyCurrentValues(objTotalSales); context.SaveChanges(); return(objTotalSales); } } catch (Exception ex) { throw ex; } }
public MemberItemTotalSale InsertTotalSales(MemberItemTotalSale objTotalSales) { try { objTotalSales.insertDate = DateTime.Now; objTotalSales.isDeleted = false; using (var context = new FitnessCenterEntities()) { context.MemberItemTotalSales.AddObject(objTotalSales); context.SaveChanges(); return(objTotalSales); } } catch (Exception ex) { throw ex; } }
public void InsertTrans() { try { decimal totalAmount = 0; long qty = 0, itemID = 0; totalAmount = Convert.ToDecimal(ShowTotal()); MemberItemTotalSale objTotalSale = new MemberItemTotalSale(); objTotalSale.totalAmount = totalAmount; objTotalSale.discount = Convert.ToDecimal(txtDis.Text); objTotalSale.finalAmount = Convert.ToDecimal(txtFinalAmt.Text); objTotalSale.memberId = MemberId; objTotalSale.isPaid = false; objTotalSale = new ProductSalesController().InsertTotalSales(objTotalSale); foreach (var obj in lstSales) { MemberItemSale objsale = new MemberItemSale(); objsale.memberId = obj.memberId; objsale.itemId = obj.itemId; itemID = obj.itemId; objsale.amount = obj.amount; qty = obj.quantity; objsale.quantity = obj.quantity; objsale.totalAmount = obj.totalAmount; objsale.memberFinalSaleID = objTotalSale.ID; new ProductSalesController().InsertProductSale(objsale); } ItemMaster objItem = ItemController.GetItemsById(itemID); //var Inventory = new FitnessCenterEntities().ItemMasters.FirstOrDefault(x => x.isDeleted == false && x.ID == itemID); objItem.Inventory = objItem.Inventory - qty; objItem = new ItemController().UpdateItems(objItem); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Success','Items Sold Successfully')", true); } catch (Exception ex) { throw ex; } }