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