/// <summary> /// To filter details in grid on different conditions selected by user /// </summary> /// <param name="DvFilter"></param> /// <param name="Column"></param> /// <param name="Operator"></param> /// <param name="Value"></param> public void FilterDataview(DataView DvFilter, string Column, string Operator, string Value) { DvFilter.RowFilter = Column + " " + Operator + "'" + Value + "'"; if (DvFilter.ToTable().Rows.Count == 0) { MsgVen.Msg = "Record(s) not found"; MsgVen.showmsg(); ViewState["DtVen"] = DvFilter.ToTable(); BindVen(DvFilter.ToTable()); ddlCol.SelectedIndex = 0; ddlOpe.SelectedIndex = 0; ddlVal.SelectedIndex = 0; } else { ViewState["DtVen"] = DvFilter.ToTable(); BindVen(DvFilter.ToTable()); } }
/// <summary> /// To save Vendor details /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { VendorBAL VendorBAL = new VendorBAL(); int UserID = Convert.ToInt32(ddlVenUser.SelectedValue.ToString()); string Status = ddlVenStatus.SelectedValue.ToString(); bool IsActive = true; if (Status == "Active") { IsActive = true; } else if (Status == "InActive") { IsActive = false; } if (btnSave.Text == "Save") { try { int Result = VendorBAL.InsertVendor(UserID, IsActive, LoginUser, Ret); DtVen = VenDetails(); ViewState["DtVen"] = DtVen; BindVen(DtVen); MsgVen.Msg = "Record added successfully"; MsgVen.showmsg(); } catch (Exception ee) { if (ee.Message == "Duplicate Entry") { MsgVen.Msg = "Duplicate Entry!"; MsgVen.showmsg(); ClearVen(); } } finally { VendorBAL = null; } } }