private void BindData() { Classes.CVendor cb = new Classes.CVendor(); List <Models.MVendor> Vendors = new List <Models.MVendor>(); if (Session["WareHouse"] != null) { string WareHouseId = Session["WareHouse"].ToString(); Vendors = cb.GetAll(); Vendors = (from o in Vendors where o.WareHouseId == WareHouseId select o).ToList(); grdVendor.DataSource = Vendors; grdVendor.DataBind(); } }
private void BindDropDown() { Classes.CVendor cv = new Classes.CVendor(); Dictionary <int, string> VendorData = new Dictionary <int, string>(); List <Models.MVendor> get = new List <Models.MVendor>(); get = cv.GetAll(); VendorData.Add(-1, "Please Select"); for (int i = 0; i < get.Count; i++) { VendorData.Add(Convert.ToInt32(get[i].id), get[i].name); } ddlVendorId.DataTextField = "Value"; ddlVendorId.DataValueField = "Key"; ddlVendorId.DataSource = VendorData; ddlVendorId.DataBind(); }
private void BindVendorsDdl() { Dictionary <int, string> Items = new Dictionary <int, string>(); List <Models.MVendor> get = new List <Models.MVendor>(); Classes.CVendor cw = new Classes.CVendor(); get = cw.GetAll(); get = get.Where(o => o.WareHouseId == Session["WareHouse"].ToString()).ToList(); Items.Add(-1, "Please select Vendor"); for (int i = 0; i < get.Count; i++) { string id = get[i].id; string name = get[i].name; Items.Add(Convert.ToInt32(id), name); } ddlVendor.DataTextField = "Value"; ddlVendor.DataValueField = "Key"; ddlVendor.DataSource = Items; ddlVendor.DataBind(); }
protected void btnSave_Click1(object sender, EventArgs e) { string vendorID = lblVendor.Text; string VendorName = txtVendorname.Text; string VendorAddress = txtVendorAddress.Text; string VendorPhone = txtVendorphone.Text; Models.MVendor mv = new Models.MVendor(); mv.id = Convert.ToString(vendorID); mv.name = VendorName; mv.Addreess = VendorAddress; mv.phone = VendorPhone; Classes.CVendor ccv = new Classes.CVendor(); if (ccv.Update(mv) < 0) { ShowFailMessage(); } else { ShowSuccessMessage(); ClearTextBoxes(Page); BindData(); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Session["WareHouse"] != null) { string WareHouseId = Session["WareHouse"].ToString(); if (Page.IsValid) { string VendorName = txtVendorName.Text; string VendorAddress = txtVendorAddress.Text; string VendorPhone = txtVendorPhoneNo.Text; Models.MVendor mv = new Models.MVendor(); mv.name = VendorName; mv.Addreess = VendorAddress; mv.phone = VendorPhone; mv.WareHouseId = WareHouseId; Classes.CVendor ccv = new Classes.CVendor(); if (ccv.Save(mv) > 0) { //ShowFailMessage(); Classes.CCashAccount ca = new Classes.CCashAccount(); Models.MCashAccount ma = new Models.MCashAccount(); ma.CashAccountName = VendorName; ma.BeginDate = DateTime.Now.ToShortDateString(); ma.ClientId = -1; ma.OpeningBalance = "0"; ma.AccountType = ma.AccountType = Common.Constants.CashAccountTypes.Vendor.ToString(); ma.VendorId = ccv.GetLastVendorId();; ma.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString()); if (ca.Save(ma) > 0) { Classes.CCashTransaction cct = new Classes.CCashTransaction(); Models.MCashTransactions mct = new Models.MCashTransactions(); mct.CashAccountId = ca.GetLastAccountId(); mct.Credit = "0"; mct.Debit = "0"; mct.Description = "Opened Client Account[" + txtVendorName.Text + "]"; mct.eDate = DateTime.Now.ToShortDateString(); mct.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString()); mct.OrderId = -1; mct.Total = "0"; mct.TransactionId = -1; mct.TransactionType = "Credit"; mct.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString()); mct.UserId = Session["UserId"].ToString(); if (cct.Save(mct) > 0) { ShowSuccessMessage(); ClearTextBoxes(Page); } else { ShowFailMessage(); } } else { ShowErrorModal("Vendor Saved but Account was not opened"); } } else { ShowFailMessage(); } } } else { ShowErrorModal("Cannot Save, No Warehouse associated with current user"); } }