protected void imgbtnDelete_Click(object sender, ImageClickEventArgs e) { try { ImageButton imb = new ImageButton(); imb = (ImageButton)sender; if (imb != null) { Int32 ID = ToInt32(imb.CommandArgument); TransSaleHeader o = new TransSaleHeader(); using (BillingEntities cre = new BillingEntities()) { o = cre.TransSaleHeaders.FirstOrDefault(w => w.SaleHeaderID.Equals(ID)); if (o != null) { cre.TransSaleHeaders.Remove(o); cre.SaveChanges(); } }; } ShowMessageBox("ลบรายการสำเร็จ."); BindData(); } catch (Exception ex) { } }
protected void btnModalSave_Click(object sender, EventArgs e) { try { //Validate if (txtMUnitCode.Text == "") { ShowMessageBox("กรุณาระบุ ชื่อลูกค้า !!!"); ModalPopupExtender1.Show(); return; } if (txtMUnitName.Text == "") { ShowMessageBox("กรุณาระบุ รหัส !!!"); ModalPopupExtender1.Show(); return; } MasUnit o = new MasUnit(); if (hddMode.Value == "Add") // Add { o = new MasUnit(); o.UnitCode = txtMUnitCode.Text; o.UnitName = txtMUnitName.Text; o.Active = "Y"; o.CreatedBy = GetUsername(); o.CreatedDate = DateTime.Now; using (BillingEntities cre = new BillingEntities()) { cre.MasUnits.Add(o); cre.SaveChanges(); }; } else //Edit { int objID = ToInt32(hddID.Value); using (BillingEntities cre = new BillingEntities()) { o = cre.MasUnits.FirstOrDefault(w => w.UnitID.Equals(objID)); if (o != null) { o.UnitCode = txtMUnitCode.Text; o.UnitName = txtMUnitName.Text; o.UpdatedBy = GetUsername(); o.UpdatedDate = DateTime.Now; } cre.SaveChanges(); }; } BindData(); ShowMessageBox("บันทึกข้อมูลสำเร็จ."); } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
// ************************************************************************************************* // Process report for selected client for specific billdate // ************************************************************************************************* public void createBill(int cltID, DateTime?billDate) { // get list of reports to run for Client BillingEntities cltBilling = new BillingEntities(); string rptBillPeriod = billDate.Value.ToString("MM"); DateTime? rptBillDate = billDate; string rptBillMonth = rptBillDate.Value.ToString("MM"); string rptBillYear = rptBillDate.Value.Year.ToString(); var rptList = (from c in cltBilling.BillDeliveries where c.CltID == cltID && c.Active == true select c).ToList <BillDelivery>(); if (rptList != null) { foreach (var rpt in rptList) { GetRptData(cltID, rptBillMonth, rptBillYear, rpt.ID); } } // get list of master reports to run for current day var masterList = (from m in cltBilling.BillDeliveries where m.CltID == cltID && m.Active == true && m.ReportGroup == "Master" select m).ToList <BillDelivery>(); if (masterList != null) { foreach (var mlst in masterList) { GetRptData(mlst.CltID.Value, rptBillMonth, rptBillYear, mlst.ID); } } }
protected void BindData() { try { List <MasUnit> lst = new List <MasUnit>(); string Name = txtUnitName.Text; string Code = txtUnitCode.Text; using (BillingEntities cre = new BillingEntities()){ lst = cre.MasUnits.Where(w => w.UnitCode.Contains(Code) && w.UnitName.Contains(Name)).ToList(); }; if (lst != null && lst.Count > 0) { gv.DataSource = lst; } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void BindDDL() { try { List <MasSender> lst = new List <MasSender>(); using (BillingEntities cre = new BillingEntities()) { lst = cre.MasSenders.ToList(); }; if (lst != null && lst.Count > 0) { ddlSender.DataSource = lst; ddlSender.DataValueField = "SenderID"; ddlSender.DataTextField = "SenderName"; Session["ReportSaleDeliDDL"] = lst; } else { ddlSender.DataSource = null; Session["ReportSaleDeliDDL"] = null; } ddlSender.DataBind(); } catch (Exception ex) { } }
protected void btnLogin_Click(object sender, EventArgs e) { if (txtUser.Text == "") { lbMsg.Text = "กรุณาระบุ Username !!!"; return; } if (txtPass.Text == "") { lbMsg.Text = "กรุณาระบุ Password !!!"; return; } MasUserLogin o = new MasUserLogin(); Session["Username"] = txtUser.Text; using (BillingEntities cre = new BillingEntities()) { o = cre.MasUserLogins.FirstOrDefault(w => w.Username.Equals(txtUser.Text) && w.Password.Equals(txtPass.Text)); if (o != null && o.Active == "Y") { Session["Username"] = o.Username; o.LastLogin = DateTime.Now; cre.SaveChanges(); } else { lbMsg.Text = "Username, Password ไม่ถูกต้อง !!!"; return; } }; Response.Redirect("/Default.aspx"); }
public ActionResult RegisterParty(PartyVM vmObject) { BillingEntities entity = new BillingEntities(); Party modelObj = new Party(); modelObj.Name = vmObject.Name; modelObj.Address = vmObject.Address; modelObj.MobileNo = vmObject.MobileNo; modelObj.CompanyName = vmObject.CompanyName; modelObj.GSTN_Number = vmObject.GSTN_Number; modelObj.PanNo = vmObject.PanNo; //modelObj.Registered = vmObject.Registered.Sele ; modelObj.Registered = "Registered"; var val = Request.Form["Registered"]; //if(ModelState.IsValid) //{ entity.RegisterParty(modelObj.Name, modelObj.CompanyName, modelObj.Address, modelObj.MobileNo, modelObj.GSTN_Number, modelObj.PanNo); //} //else //{ // return View("RegisterParty"); //} return(View("Success")); }
protected void imgbtnDelete_Click(object sender, ImageClickEventArgs e) { try { ImageButton imb = (ImageButton)sender; if (imb != null) { MasUnit obj = new MasUnit(); int objID = ToInt32(imb.CommandArgument); using (BillingEntities cre = new BillingEntities()) { obj = cre.MasUnits.FirstOrDefault(w => w.UnitID.Equals(objID)); if (obj != null) { obj.Active = "N"; obj.UpdatedBy = GetUsername(); obj.UpdatedDate = DateTime.Now; } //cre.MasUnits.Remove(obj); cre.SaveChanges(); }; BindData(); } else { SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod()); } } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void BindDDL() { try { DataTable dt = new DataTable(); dt.Columns.Add("Text"); dt.Columns.Add("Val"); DataRow dr; #region Month DateTimeFormatInfo monthsInfo = DateTimeFormatInfo.GetInstance(null); for (int i = 1; i < 13; i++) { dr = dt.NewRow(); dr["Text"] = monthsInfo.GetMonthName(i); dr["Val"] = i.ToString(); dt.Rows.Add(dr); } if (dt != null && dt.Rows.Count > 0) { ddlMonth.DataSource = dt; ddlMonth.DataTextField = "Text"; ddlMonth.DataValueField = "Val"; } else { ddlMonth.DataSource = null; } ddlMonth.DataBind(); ddlMonth.SelectedIndex = ddlMonth.Items.IndexOf(ddlMonth.Items.FindByValue(DateTime.Now.Month.ToString())); //ToInt32(obj.PayType); #endregion #region Year List <Int32> lstYear = new List <Int32>(); using (BillingEntities cre = new BillingEntities()) { lstYear = cre.TransSaleHeaders.Select(s => s.ReceivedDate.HasValue ? s.ReceivedDate.Value.Year : 0).Distinct().OrderByDescending(od => od).ToList(); } if (lstYear != null) { ddlYear.DataSource = lstYear; ddlYear.SelectedIndex = ddlYear.Items.IndexOf(ddlYear.Items.FindByValue(DateTime.Now.Year.ToString())); //ToInt32(obj.PayType); } else { ddlYear.DataSource = null; } ddlYear.DataBind(); #endregion } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
public ActionResult Delete(int id) { BillingEntities db = new BillingEntities(); var getdata = db.Bills.FirstOrDefault(m => m.B_no == id); db.Bills.Remove(getdata); db.SaveChanges(); return(RedirectToAction("Display", "Home")); }
// ************************************************************************************************* // **** This will get the last bill date for client **** // ************************************************************************************************* private DateTime?GetBillDate(int rptcltID) { BillingEntities billRptDate = new BillingEntities(); var rptBillDateInfo = (from x in billRptDate.BillingLogs where x.CltID == rptcltID orderby x.BatchID descending select x.BillDate).FirstOrDefault(); return(rptBillDateInfo); }
protected void BindData() { try { List <ReportSaleDTO> lst = new List <ReportSaleDTO>(); DateTime dateFrom = string.IsNullOrEmpty(txtDateFrom.Text) ? DateTime.MinValue : DateTime.ParseExact(txtDateFrom.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); DateTime dateTo = string.IsNullOrEmpty(txtDateTo.Text) ? DateTime.MaxValue : DateTime.ParseExact(txtDateTo.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")).AddDays(1); string SaleNo = txtSaleNo.Text; string Serial = txtSn.Text; using (BillingEntities cre = new BillingEntities()) { lst = (from h in cre.TransSaleHeaders join d in cre.TransSaleDetails on h.SaleHeaderID equals d.SaleHeaderID join i in cre.MasItems on d.ItemID equals i.ItemID where h.ReceivedDate >= dateFrom && h.ReceivedDate < dateTo //date == DateTime.MinValue ? true : h.ReceivedDate.HasValue ? h.ReceivedDate.Value == date : true select new ReportSaleDTO() { HeaderID = h.SaleHeaderID, DetailID = d.SaleDetailID, Tel = h.Tel, CustomerName = h.DeliveryName, Address = h.DeliverCountry + " " + h.DeliverProvince, District = h.DeliverDistrict, Country = h.DeliverCountry, Province = h.DeliverProvince, PostalCode = h.DeliverPostalCode, SaleNumber = h.SaleNumber, ItemCode = i.ItemCode, ItemName = i.ItemName, WarrantyDate = h.WarrantyDate, SerialNumber = d.SerialNumber, }).OrderBy(od => od.HeaderID).ToList(); }; if (lst != null && lst.Count > 0) { //lstMod = ModDataFromSale(lst); gv.DataSource = lst; Session["ReportWarranty"] = lst; } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
public ActionResult Update(int ID) { BillingEntities db = new BillingEntities(); BillModel dt = new BillModel(); var getdata = db.Bills.FirstOrDefault(m => m.B_no == ID); dt.Product = getdata.Product; dt.Price = getdata.Price; dt.Date = (DateTime)getdata.Date; return(View(dt)); }
protected void SearchItem() { try { string ItemCode = txtSearchItemCode.Text.ToLower(); string ItemName = txtSearchItemName.Text.ToLower(); List <MasItemDTO> lst = new List <MasItemDTO>(); using (BillingEntities cre = new BillingEntities()) { //lst = (from i in cre.MasItems // join d in cre.Inventories on i.ItemID equals d.ItemID // where i.Active.Equals("Y") && d.Amount > 0 // select new MasItemDTO() // {emName, // ItemCode = i.I // ItemID = i.ItemID, // ItemName = i.IttemCode, // ItemDesc = i.ItemDesc, // ItemPrice = i.ItemPrice.HasValue ? i.ItemPrice.Value : 0, // Amount = d.Amount, // }).ToList(); if (lst != null) { if (!string.IsNullOrEmpty(ItemCode)) { lst = lst.Where(w => w.ItemCode.ToLower().Contains(ItemCode)).ToList(); } if (!string.IsNullOrEmpty(ItemName)) { lst = lst.Where(w => w.ItemName.ToLower().Contains(ItemName)).ToList(); } lst = lst.OrderBy(od => od.ItemID).ToList(); gvItemSearch.DataSource = lst; gvItemSearch.DataBind(); } else { gvItemSearch.DataSource = null; gvItemSearch.DataBind(); } }; } catch (Exception ex) { gvItemSearch.DataSource = null; gvItemSearch.DataBind(); } }
protected void BindData() { try { if (string.IsNullOrEmpty(txtDateFrom.Text) || string.IsNullOrEmpty(txtDateTo.Text)) { ShowMessageBox("กรุณาระบุวันที่ที่ต้องการค้นหา. !!!"); return; } List <InventoryDTO> lst = new List <InventoryDTO>(); string Code = txtItemCode.Text; string Name = txtItemName.Text; DateTime dateFrom = string.IsNullOrEmpty(txtDateFrom.Text) ? DateTime.MinValue : DateTime.ParseExact(txtDateFrom.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); DateTime dateTo = string.IsNullOrEmpty(txtDateTo.Text) ? DateTime.MaxValue : DateTime.ParseExact(txtDateTo.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")).AddDays(1); using (BillingEntities cre = new BillingEntities()) { //lst = cre.Inventories.Where(w => w.Amount > 0).ToList(); //lst = (from l in cre.InventoryLogs // join i in cre.Inventories on l.InventoryID equals i.InventoryID // join m in cre.MasItems on i.ItemID equals m.ItemID // where l.Amount > 0 // && (l.Action.Equals("Inbound") || l.Action.Equals("Outbound")) // && l.UpdatedDate >= dateFrom && l.UpdatedDate < dateTo // select new InventoryDTO() // { // InventoryID = l.InventoryID, // ItemID = m.ItemID, // ItemCode = m.ItemCode, // ItemName = m.ItemName, // Amount = l.Amount.HasValue ? l.Amount.Value : 0, // UpdatedDate = l.UpdatedDate.HasValue ? l.UpdatedDate.Value : DateTime.Now, // UpdatedBy = l.UpdatedBy, // }).OrderByDescending(od => od.UpdatedDate).ThenBy(od => od.ItemCode).ToList(); }; if (lst != null && lst.Count > 0) { gv.DataSource = lst; } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { } }
public ActionResult Insert(BillModel d) { BillingEntities db = new BillingEntities(); Bill B = new Bill(); B.Product = d.Product; B.Price = d.Price; B.Date = d.Date; db.Bills.Add(B); db.SaveChanges(); ViewBag.Text = "Details Inserted"; return(RedirectToAction("Display", "Home")); }
public ActionResult Update(int ID, BillModel dt) { BillingEntities db = new BillingEntities(); var getdata = db.Bills.FirstOrDefault(m => m.B_no == ID); getdata.Product = (string)dt.Product; getdata.Price = (Decimal)dt.Price; getdata.Date = (DateTime)dt.Date; db.SaveChanges(); ViewBag.Text = "Details Updated"; return(RedirectToAction("Display", "Home")); }
protected void LoginUser_LoggedIn(object sender, EventArgs e) { var loginForm = (System.Web.UI.WebControls.Login)sender; BillingEntities db = new BillingEntities(); User user = db.Users.FirstOrDefault(s => s.Login.ToLower() == loginForm.UserName.ToLower()); if (user == null) return; db.UsersLogs.AddObject(new UsersLog { Date = DateTime.Now, Text = "User logged in from Ip " + Request.UserHostAddress, UserId = user.Id }); //user.IpAddress = Request.UserHostAddress; db.SaveChanges(); }
protected void imgbtnView_Click(object sender, ImageClickEventArgs e) { try { ModalPopupExtender1.Show(); ImageButton imb = new ImageButton(); DateTime dateFrom = string.IsNullOrEmpty(txtDateFrom.Text) ? DateTime.MinValue : DateTime.ParseExact(txtDateFrom.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); DateTime dateTo = string.IsNullOrEmpty(txtDateTo.Text) ? DateTime.MaxValue : DateTime.ParseExact(txtDateTo.Text + " 235959", "dd/MM/yyyy HHmmss", new System.Globalization.CultureInfo("en-US")); string ItemCode = ""; imb = (ImageButton)sender; List <ReportSaleItemDTO> lst = new List <ReportSaleItemDTO>(); if (imb != null) { ItemCode = imb.CommandArgument; using (BillingEntities cre = new BillingEntities()) { lst = (from d in cre.GetReportSaleItemItemCode(dateFrom, dateTo, ItemCode) select new ReportSaleItemDTO() { SaleHeaderID = d.SaleHeaderID, SaleNumber = d.SaleNumber, ItemCode = d.ItemCode, }).OrderBy(od => od.ItemCode).ToList(); } if (lst != null && lst.Count > 0) { //ModData(lst); gvSale.DataSource = lst; } else { gvSale.DataSource = null; } gvSale.DataBind(); } } catch (Exception ex) { } }
public ActionResult Display() { BillingEntities db = new BillingEntities(); DataModel dt = new DataModel(); var get = db.Bills.ToList(); List <BillModel> lst = new List <BillModel>(); foreach (var item in get) { lst.Add(new BillModel { B_no = item.B_no, Product = item.Product, Price = (int)item.Price, Date = (DateTime)item.Date }); } dt.list = lst; return(View(dt)); }
protected void imgbtnEdit_Click(object sender, ImageClickEventArgs e) { try { ImageButton imb = (ImageButton)sender; MasItem obj = new MasItem(); if (imb != null) { int objID = ToInt32(imb.CommandArgument); using (BillingEntities cre = new BillingEntities()) { obj = cre.MasItems.FirstOrDefault(w => w.ItemID.Equals(objID)); }; if (obj != null) { hddID.Value = imb.CommandArgument; txtMCode.Text = obj.ItemCode; txtMName.Text = obj.ItemName; txtMDesc.Text = obj.ItemDesc; //txtMPrice.Text = obj.ItemPrice.HasValue ? obj.ItemPrice.Value.ToString("###,##0") : "0"; txtMPrice.Text = obj.ItemPrice.HasValue ? obj.ItemPrice.Value.ToString("###,##0") : "0"; ModalPopupExtender1.Show(); hddMode.Value = "Edit"; } else { SendMailError("obj is null, objID = " + imb.CommandArgument, System.Reflection.MethodBase.GetCurrentMethod()); } } else { SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod()); } } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void imgbtnEdit_Click(object sender, ImageClickEventArgs e) { try { ImageButton imb = (ImageButton)sender; MasUserLogin obj = new MasUserLogin(); if (imb != null) { using (BillingEntities cre = new BillingEntities()) { obj = cre.MasUserLogins.FirstOrDefault(w => w.Username.Equals(imb.CommandArgument)); }; if (obj != null) { txtMUsername.Text = obj.Username; chkActive.Checked = obj.Active == "Y" ? true : false; ModalPopupExtender1.Show(); hddMode.Value = "Edit"; } else { SendMailError("obj is null, objID = " + imb.CommandArgument, System.Reflection.MethodBase.GetCurrentMethod()); } } else { SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod()); } } catch (Exception ex) { ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ."); SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
// ************************************************************************************************* // **** This process will get a list of all reports to process for current date **** // ************************************************************************************************* public void createBill() { // get list of special reports to run for current day BillingEntities rptBilling = new BillingEntities(); string rptBillPeriod = DateTime.Now.ToString("dd"); var cltList = (from c in rptBilling.BillDeliveries where c.BillPeriod == rptBillPeriod && c.Active == true select c).ToList <BillDelivery>(); if (cltList != null) { foreach (var clt in cltList) { //DateTime? rptBillDate = GetBillDate(clt.CltID.Value); DateTime?rptBillDate = DateTime.Now; if (clt.Current == "Ahead") { rptBillDate = DateTime.Now.AddMonths(1); } string rptBillMonth = rptBillDate.Value.ToString("MM"); string rptBillYear = rptBillDate.Value.Year.ToString(); GetRptData(clt.CltID.Value, rptBillMonth, rptBillYear, clt.ID); } } // get list of master reports to run for current day var masterList = (from m in rptBilling.BillDeliveries where m.BillPeriod == rptBillPeriod && m.Active == true && m.ReportGroup == "Master" select m).ToList <BillDelivery>(); if (masterList != null) { foreach (var mlst in masterList) { //DateTime? rptBillDate = GetBillDate(mlst.CltID.Value); DateTime?rptBillDate = DateTime.Now; string rptBillMonth = rptBillDate.Value.ToString("MM"); string rptBillYear = rptBillDate.Value.Year.ToString(); GetRptData(mlst.CltID.Value, rptBillMonth, rptBillYear, mlst.ID); } } }
public override string[] GetRolesForUser(string username) { BillingEntities db=new BillingEntities(); User user = db.Users.FirstOrDefault(s => s.Login == username); return user!=null && user.IsAdmin ? new string[] {"Admin"} : new string[0]; }
public override bool ValidateUser(string username, string password) { BillingEntities db=new BillingEntities(); User user = db.Users.FirstOrDefault(s => s.Login == username); return (user != null) && (user.Password == password); }
public EquipmentRepository(BillingEntities context) : base(context) { AutoSave = true; }
public FacilityRepository(BillingEntities context) : base(context) { AutoSave = true; _context = context; }
protected void BindData() { try { List <ReportSaleItemDTO> lst = new List <ReportSaleItemDTO>(); DateTime dateFrom = string.IsNullOrEmpty(txtDateFrom.Text) ? DateTime.MinValue : DateTime.ParseExact(txtDateFrom.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); DateTime dateTo = string.IsNullOrEmpty(txtDateTo.Text) ? DateTime.MaxValue : DateTime.ParseExact(txtDateTo.Text + " 235959", "dd/MM/yyyy HHmmss", new System.Globalization.CultureInfo("en-US")); //Int32 itemID = ToInt32(ddlMItem.SelectedItem.Value); string ItemCode = "", Group = ""; //ItemCode = ddlItem.SelectedItem.Value; ItemCode = txtItemCode.Text; Group = chkShow.Checked ? "1" : ""; using (BillingEntities cre = new BillingEntities()) { lst = (from d in cre.GetReportSaleItem(dateFrom, dateTo, ItemCode, Group) select new ReportSaleItemDTO() { //HeaderID = h.SaleHeaderID, //CustomerName = h.CustomerName, //ReceivedDate = h.ReceivedDate, //SaleNumber = h.SaleNumber, ItemCode = d.ItemCode, ItemName = d.ItemName, ItemPrice = d.ItemPrice.Value, Amount = d.sumAmt.Value, }).OrderBy(od => od.ItemCode).ToList(); //lst = (from h in cre.TransSaleHeaders // join d in cre.TransSaleDetails on h.SaleHeaderID equals d.SaleHeaderID // join i in cre.MasItems on d.ItemID equals i.ItemID // where i.ItemCode.Contains(ItemCode) // && h.ReceivedDate > dateFrom && h.ReceivedDate < dateTo // //&& dateFrom == DateTime.MinValue ? true : h.ReceivedDate.HasValue ? h.ReceivedDate.Value == date : true // select new ReportSaleItemDTO() // { // //HeaderID = h.SaleHeaderID, // //CustomerName = h.CustomerName, // //ReceivedDate = h.ReceivedDate, // //SaleNumber = h.SaleNumber, // ItemCode = i.ItemCode, // ItemName = i.ItemName, // ItemPrice = d.ItemPrice.Value, // Discount = d.Discount.Value, // Amount = d.Amount.Value, // }).OrderBy(od => od.ItemCode).ToList(); }; if (Group == "1") { gv.Columns[3].Visible = true; gv.Columns[4].Visible = true; } else { gv.Columns[3].Visible = false; gv.Columns[4].Visible = false; } if (lst != null && lst.Count > 0) { //ModData(lst); gv.DataSource = lst; Session["ReportSaleItem"] = lst; } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }
public UserRoleRepository(BillingEntities context) : base(context) { AutoSave = true; }
public LoginTrackingRepository(BillingEntities context) : base(context) { AutoSave = true; _context = context; }
public DashboardBudgetRepository(BillingEntities context) : base(context) { AutoSave = true; _context = context; }
public SystemConfigurationRepository(BillingEntities context) : base(context) { AutoSave = true; }
protected void BindData() { try { List <ReportSummarySaleMonthDTO> lstResult = new List <ReportSummarySaleMonthDTO>(); List <ReportSaleMonthDTO> lst = new List <ReportSaleMonthDTO>(); List <MasValueList> lstVal = new List <MasValueList>(); double xx = string.IsNullOrEmpty(txtXX.Text) ? 0 : Convert.ToDouble(txtXX.Text); double MM200 = string.IsNullOrEmpty(txtMM200.Text) ? 0 : Convert.ToDouble(txtMM200.Text); double MM225 = string.IsNullOrEmpty(txtMM225.Text) ? 0 : Convert.ToDouble(txtMM225.Text); string Month = ddlMonth.SelectedValue; string Year = ddlYear.SelectedValue; string date = "01/" + Month.PadLeft(2, '0') + "/" + Year; string SaleName = ddlSaleName.SelectedItem.Text; DateTime dateFrom = DateTime.ParseExact(date, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); DateTime dateTo = dateFrom.AddMonths(1).AddSeconds(-1); xx = xx / 100; MM200 = MM200 / 100; MM225 = MM225 / 100; using (BillingEntities cre = new BillingEntities()) { lstVal = cre.MasValueLists.Where(w => w.FUNC.Equals("PAYMENT")).ToList(); lst = (from h in cre.TransSaleHeaders join d in cre.TransSaleDetails on h.SaleHeaderID equals d.SaleHeaderID join i in cre.MasItems on d.ItemID equals i.ItemID where h.ReceivedDate >= dateFrom && h.ReceivedDate < dateTo && (string.IsNullOrEmpty(SaleName) ? true : h.SaleName.Equals(SaleName)) //&& dateFrom == DateTime.MinValue ? true : h.ReceivedDate.HasValue ? h.ReceivedDate.Value == date : true select new ReportSaleMonthDTO() { HeaderID = h.SaleHeaderID, DetailID = d.SaleDetailID, Remark = h.Remark, CustomerName = h.CustomerName, //CustomerAddress = h.CustomerAddress, //CustomerDistrict = h.CustomerDistrict, //CustomerCountry = h.CustomerCountry, //CustomerProvince = h.CustomerProvince, //CustomerPostalCode = h.CustomerPostalCode, ReceivedDate = h.ReceivedDate, //WarrantyDate = h.WarrantyDate, SaleNumber = h.SaleNumber, SaleName = h.SaleName, ItemCode = i.ItemCode, //ItemName = i.ItemName, //SerialNumber = d.SerialNumber, //ItemDescription = i.ItemDesc, ItemPrice = d.ItemPrice.Value, Discount = d.Discount.Value, Amount = d.Amount.Value, //Tel = h.Tel, //Address = h.CustomerAddress, //District = h.CustomerDistrict, //Country = h.CustomerCountry, //Province = h.CustomerProvince, //PostalCode = h.CustomerPostalCode, PayTypeID = h.PayType, BillTypeID = h.BillType, VAT = xx, MAXMIG200 = MM200, MAXMIG225 = MM225, //VisImgBtn = "true", ConsignmentNo = h.ConsignmentNo, AccountTransfer = h.AccountTransfer, Installment = h.Installment, }).OrderBy(od => od.ReceivedDate).ThenBy(od => od.SaleNumber).ThenBy(od => od.DetailID).ToList(); }; if (lst != null && lst.Count > 0) { lstResult = ModData(lst, lstVal); gv.DataSource = lstResult; Session["ReportSummarySaleMonth"] = lstResult; } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }