public async Task <IActionResult> Edit([Bind("VendorCode,VendorName,AddressL1,AddressL2,AddressL3,AddressL4,Telephone,Fax,VendorEmail,VendorContact,CreditTerm,PriceLevel,VendorTaxId,Remark,CompanyCode,Id,Is_Active,Created_Date,Created_By,Updated_Date,Updated_By")] M_Vendor m_Vendor) { if (ModelState.IsValid) { m_Vendor.Updated_By = await base.CurrentUserId(); ResultObject resultObj; try { using (var vendBll = new VendorBLL()) { resultObj = await vendBll.UpdateVendor(m_Vendor); _cache.Remove("CACHE_MASTER_VENDOR"); } return(Json(new { success = true, data = (M_Vendor)resultObj.ObjectValue, message = "Vendor Update." })); } catch (Exception ex) { return(Json(new { success = false, data = m_Vendor, message = ex.Message })); } } var err = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList(); return(Json(new { success = false, errors = err, data = m_Vendor, message = "Update Failed" })); }
// GET: Master/Vendor public async Task <IActionResult> GetVendor() { try { if (_cache.TryGetValue("CACHE_MASTER_VENDOR", out List <M_Vendor> c_lstVend)) { return(Json(new { data = c_lstVend })); } MemoryCacheEntryOptions options = new MemoryCacheEntryOptions { AbsoluteExpirationRelativeToNow = TimeSpan.FromSeconds(300), SlidingExpiration = TimeSpan.FromSeconds(60), Priority = CacheItemPriority.NeverRemove }; using (var vendBll = new VendorBLL()) { var lstVend = await vendBll.GetVendor(null); _cache.Set("CACHE_MASTER_VENDOR", lstVend, options); return(Json(new { data = lstVend })); } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } //using (var vendBll = new VendorBLL()) //{ // return Json(new { data = await vendBll.GetVendor(null) }); //} }
public async Task <IActionResult> UploadModelData(List <M_Vendor> lstVend) { var uId = await base.CurrentUserId(); lstVend.ForEach(m => { m.Created_By = uId; }); try { using (var vendBll = new VendorBLL()) { var rowaffected = await vendBll.BulkInsertVendor(lstVend); _cache.Remove("CACHE_MASTER_VENDOR"); } return(Json(new { success = true, data = lstVend, message = "Import Success." })); } catch (Exception ex) { return(Json(new { success = true, data = lstVend, message = ex.Message })); } }
protected void btnCreateVendor_Click(object sender, EventArgs e) { try { Vendor obj = new Vendor(); obj.SupName = txtVendorName.Text; obj.Email = txtEmail.Text; obj.city = txtcity.Text; obj.State = txtState.Text; obj.Country = txtCounty.Text; obj.address = txtaddress.Text; obj.ConPerson = txtConPerson.Text; obj.Credit = txtCredit.Text; obj.Discount = txtDiscount.Text; obj.Fax = txtfax.Text; obj.Phone = txtphone.Text; obj.Mobile = txtmobile.Text; obj.Pager = txtpager.Text; obj.Pincode = txtPincode.Text; obj.DateCreated = DateTime.Now; VendorBLL objAdd = new VendorBLL(); objAdd.Add(obj, connection); } catch (Exception) { throw; } finally { Clear(); } }
private void LoadData() { try { DataSet ds = new DataSet(); Vendor obj = new Vendor(); obj.supp_ID = int.Parse(Request.QueryString["Id"].ToString()); ds = VendorBLL.GetDistinct(connection, obj); // ds.Tables[0].Rows[0]["Supp_ID"].ToString(); // txtVendorName.Text = ds.Tables[0].Rows[0]["Supp_ID"].ToString(); txtID.Text = ds.Tables[0].Rows[0]["SuppID"].ToString(); txtVendorName.Text = ds.Tables[0].Rows[0]["SupName"].ToString(); txtaddress.Text = ds.Tables[0].Rows[0]["Address"].ToString(); txtcity.Text = ds.Tables[0].Rows[0]["City"].ToString(); txtState.Text = ds.Tables[0].Rows[0]["State"].ToString(); txtCounty.Text = ds.Tables[0].Rows[0]["Country"].ToString(); txtPincode.Text = ds.Tables[0].Rows[0]["Pincode"].ToString(); txtphone.Text = ds.Tables[0].Rows[0]["Phone"].ToString(); txtfax.Text = ds.Tables[0].Rows[0]["Fax"].ToString(); txtmobile.Text = ds.Tables[0].Rows[0]["Mobile"].ToString(); txtpager.Text = ds.Tables[0].Rows[0]["Pager"].ToString(); txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString(); txtConPerson.Text = ds.Tables[0].Rows[0]["ConPerson"].ToString(); txtDiscount.Text = ds.Tables[0].Rows[0]["Discount"].ToString(); txtCredit.Text = ds.Tables[0].Rows[0]["Credit"].ToString(); } catch (Exception) { throw; } }
public async Task <IActionResult> DeleteConfirmed(int?id) { if (id == null) { return(NotFound()); } ResultObject resultObj; try { if (_cache.TryGetValue("CACHE_MASTER_VENDOR", out List <M_Vendor> c_lstVend)) { var m_Vendor = c_lstVend.Find(v => v.Id == id); if (m_Vendor == null) { return(NotFound()); } m_Vendor.Updated_By = await base.CurrentUserId(); using (var vendBll = new VendorBLL()) { resultObj = await vendBll.DeleteVendor(m_Vendor); _cache.Remove("CACHE_MASTER_VENDOR"); } return(Json(new { success = true, data = (M_Vendor)resultObj.ObjectValue, message = "Vendor Deleted." })); } using (var vendBll = new VendorBLL()) { var lstVend = await vendBll.GetVendor(id); var m_Vendor = lstVend.First(); if (m_Vendor == null) { return(NotFound()); } m_Vendor.Updated_By = await base.CurrentUserId(); resultObj = await vendBll.DeleteVendor(m_Vendor); _cache.Remove("CACHE_MASTER_VENDOR"); } return(Json(new { success = true, data = (M_Vendor)resultObj.ObjectValue, message = "Vendor Deleted." })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
private void BindGrid() { ds = VendorBLL.GetAllVendors(connection); ProductSet = ds; gdvVendor.DataSource = null; gdvVendor.DataSource = ds; gdvVendor.DataBind(); //drpVendor.DataSource = ds; //drpVendor.Items.Insert(0, new ListItem("Select Product", "")); //drpVendor.DataTextField = "SupName"; //drpVendor.DataValueField = "Supp_ID"; //drpVendor.DataBind(); }
private void BindGridDistinct(int ID) { Vendor vendor = new Vendor(); vendor.supp_ID = ID; ds = VendorBLL.GetDistinct(connection, vendor); ProductSet = ds; gdvVendor.DataSource = null; gdvVendor.DataSource = ds; gdvVendor.DataBind(); //drpVendor.DataSource = ds; //drpVendor.Items.Insert(0, new ListItem("Select Product", "")); //drpVendor.DataTextField = "SupName"; //drpVendor.DataValueField = "Supp_ID"; //drpVendor.DataBind(); }
protected void gdvVendor_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { VendorBLL _vendorBll = new VendorBLL(); Label ID = (Label)gdvVendor.Rows[e.RowIndex].FindControl("lblSupID"); int id = int.Parse(ID.Text); Vendor vendor = new Vendor();//= empid.Text; vendor.supp_ID = id; _vendorBll.Delete(vendor, connection); } catch (Exception exp) { } finally { gdvVendor.EditIndex = -1; BindGrid(); } }
// GET: Master/Vendor/Edit/5 public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } ViewBag.CompCode = await base.CurrentUserComp(); try { if (_cache.TryGetValue("CACHE_MASTER_VENDOR", out List <M_Vendor> c_lstVend)) { var m_Vendor = c_lstVend.Find(v => v.Id == id); if (m_Vendor == null) { return(NotFound()); } return(PartialView(m_Vendor)); } using (var vendBll = new VendorBLL()) { var lstVend = await vendBll.GetVendor(id); var m_Vendor = lstVend.First(); if (m_Vendor == null) { return(NotFound()); } return(PartialView(m_Vendor)); } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }
//private void CheckUserAccess() //{ // if (!ReferenceEquals(Session[Constants.SESSION_USER_INFO], null)) // { // IUser user = (IUser)Session[Constants.SESSION_USER_INFO]; // if (ReferenceEquals(user, null) || user.Id == 0) // { // Response.Redirect("~/Login.aspx"); // } // if (user.UserRole.Id != (int)UserRole.Admin) // { // Response.Redirect("~/Unauthorized.aspx"); // } // } // else // { // Response.Redirect("~/Login.aspx"); // } //} private void LoadData() { VendorEntity oVendor = (VendorEntity)VendorBLL.GetVendor(Convert.ToInt32(hdnVendorID.Value)); ddlVendorType.SelectedIndex = ddlVendorType.Items.IndexOf(ddlVendorType.Items.FindByValue(oVendor.VendorType)); if (ddlVendorType.SelectedItem.Text == "CFS/ICD" || ddlVendorType.SelectedItem.Text == "ICD") { txtCfsCode.Enabled = true; rfvCfdCode.Enabled = true; ddlTerminalCode.Enabled = true; } else { txtCfsCode.Enabled = false; rfvCfdCode.Enabled = false; ddlTerminalCode.Enabled = false; } ddlLocationID.SelectedIndex = Convert.ToInt32(ddlLocationID.Items.IndexOf(ddlLocationID.Items.FindByValue(oVendor.LocationName))); PopulateDropDown((int)Enums.DropDownPopulationFor.TerminalCode, ddlTerminalCode, Convert.ToInt32(ddlLocationID.SelectedValue)); ddlSalutation.SelectedIndex = Convert.ToInt32(ddlSalutation.Items.IndexOf(ddlSalutation.Items.FindByValue(oVendor.VendorSalutation.ToString()))); if (ddlTerminalCode.Items.Count > 0) { ddlTerminalCode.SelectedIndex = Convert.ToInt32(ddlTerminalCode.Items.IndexOf(ddlTerminalCode.Items.FindByValue(oVendor.Terminalid.ToString()))); } txtName.Text = oVendor.VendorName; txtAddress.Text = oVendor.VendorAddress; txtCfsCode.Text = oVendor.CFSCode; TxtTAN.Text = oVendor.TANo; TxtPAN.Text = oVendor.PAN; TxtACNo.Text = oVendor.AcNo; TxtAcType.Text = oVendor.AcType; TxtBankName.Text = oVendor.BankName; TxtIEC.Text = oVendor.IEC; TxtEmail.Text = oVendor.EmailID; TxtBIN.Text = oVendor.BIN; TxtMob.Text = oVendor.Mobile; TxtCP.Text = oVendor.CP; }
private void LoadAddress() { if (!ReferenceEquals(Session[Constants.SESSION_SEARCH_CRITERIA], null)) { SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA]; if (!ReferenceEquals(searchCriteria, null)) { BuildSearchCriteria(searchCriteria); CommonBLL commonBll = new CommonBLL(); gvwVendor.PageIndex = searchCriteria.PageIndex; if (searchCriteria.PageSize > 0) { gvwVendor.PageSize = searchCriteria.PageSize; } gvwVendor.DataSource = VendorBLL.GetVendor(searchCriteria, 0); gvwVendor.DataBind(); } } }
public ActionResult aaaa(int VenId) { return(Json(VendorBLL.ShowByName1(VenId), JsonRequestBehavior.AllowGet)); }
public ActionResult ShowByName1(string name) { return(Json(VendorBLL.ShowByName1(name), JsonRequestBehavior.AllowGet)); }
//根据供应商用户名或工号查询 public ActionResult ShowByName(int pageIndex, int pageSize, int VenId, string VenName) { return(Json(VendorBLL.ShowByName(pageIndex, pageSize, VenId, VenName), JsonRequestBehavior.AllowGet)); }
public ActionResult PageListDemo(int pageIndex, int PageSize) { return(Json(VendorBLL.PageListDemo(pageIndex, PageSize), JsonRequestBehavior.AllowGet)); }
public ActionResult GetRows() { return(Json(VendorBLL.GetRows(), JsonRequestBehavior.AllowGet)); }
public ActionResult updataVendor(Vendor d) { return(Json(VendorBLL.updataVendor(d), JsonRequestBehavior.AllowGet)); }
public ActionResult VendorByids(int id) { return(Json(VendorBLL.VendorByid(id), JsonRequestBehavior.AllowGet)); }
//添加供应商 public ActionResult VendorAdd(Vendor ven) { return(Json(VendorBLL.VendorAdd(ven), JsonRequestBehavior.AllowGet));; }
private void DeleteLocation(int locId) { VendorBLL.DeleteVndor(locId); LoadAddress(); ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('" + ResourceManager.GetStringWithoutName("ERR00010") + "');</script>", false); }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { oVendorBll = new VendorBLL(); oVendorEntity = new VendorEntity(); //oUserEntity = (UserEntity)Session[Constants.SESSION_USER_INFO]; // This section has been commented temporarily oVendorEntity.VendorType = ddlVendorType.SelectedValue; oVendorEntity.LocationID = Convert.ToInt32(ddlLocationID.SelectedValue); oVendorEntity.VendorSalutation = Convert.ToInt32(ddlSalutation.SelectedValue); oVendorEntity.VendorName = txtName.Text.Trim(); oVendorEntity.VendorAddress = txtAddress.Text.Trim(); oVendorEntity.CompanyID = 1;//Need to populate from data base. This will be the company ID of the currently loggedin user. oVendorEntity.VendorActive = true; oVendorEntity.AcNo = TxtACNo.Text; oVendorEntity.AcType = TxtAcType.Text; oVendorEntity.BankName = TxtBankName.Text; oVendorEntity.BIN = TxtBIN.Text; oVendorEntity.EmailID = TxtEmail.Text; oVendorEntity.IEC = TxtIEC.Text; oVendorEntity.Mobile = TxtMob.Text; oVendorEntity.TANo = TxtTAN.Text; oVendorEntity.PAN = TxtPAN.Text; oVendorEntity.CP = TxtCP.Text; oVendorEntity.CFSCode = txtCfsCode.Text.Trim(); if (ddlTerminalCode.Items.Count > 0 && ddlTerminalCode.SelectedIndex > 0) { oVendorEntity.Terminalid = Convert.ToInt32(ddlTerminalCode.SelectedValue); } if (hdnVendorID.Value == "0") // Insert { oVendorEntity.CreatedBy = _userId; // oUserEntity.Id; oVendorEntity.CreatedOn = DateTime.Today.Date; oVendorEntity.ModifiedBy = _userId; // oUserEntity.Id; oVendorEntity.ModifiedOn = DateTime.Today.Date; switch (oVendorBll.AddEditVndor(oVendorEntity)) { case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); break; case 1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00009"); ClearAll(); break; } } else // Update { oVendorEntity.VendorId = Convert.ToInt32(hdnVendorID.Value); oVendorEntity.ModifiedBy = _userId;// oUserEntity.Id; oVendorEntity.ModifiedOn = DateTime.Today.Date; switch (oVendorBll.AddEditVndor(oVendorEntity)) { case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); break; case 1: Response.Redirect("~/MasterModule/vendor-list.aspx"); break; } } } }
public async Task <IActionResult> GetVendor(string vcode) { try { if (_cache.TryGetValue("CACHE_MASTER_VENDOR", out List <M_Vendor> c_lstVend)) { if (string.IsNullOrEmpty(vcode)) { return(Json(new { success = true, data = c_lstVend, message = "Get Vendor Success" })); } else { M_Vendor m_Vendor = c_lstVend.Find(v => v.VendorCode == vcode); if (m_Vendor != null) { return(Json(new { success = true, data = m_Vendor, message = "Get Vendor Success" })); } else { return(Json(new { success = false, data = string.Empty, message = "Vendor Not Found" })); } } } MemoryCacheEntryOptions options = new MemoryCacheEntryOptions { AbsoluteExpirationRelativeToNow = TimeSpan.FromSeconds(300), SlidingExpiration = TimeSpan.FromSeconds(60), Priority = CacheItemPriority.NeverRemove }; using (var vendBll = new VendorBLL()) { var lstVend = await vendBll.GetVendor(null); _cache.Set("CACHE_MASTER_VENDOR", lstVend, options); if (string.IsNullOrEmpty(vcode)) { return(Json(new { success = true, data = lstVend, message = "Get Vendor Success" })); } else { M_Vendor m_Vendor = lstVend.Find(v => v.VendorCode == vcode); if (m_Vendor != null) { return(Json(new { success = true, data = m_Vendor, message = "Get Vendor Success" })); } else { return(Json(new { success = false, data = string.Empty, message = "Vendor Not Found" })); } } } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }