/// <summary> /// To edit content developer details in grid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnkEdit_Click(object sender, EventArgs e) { LinkButton lnk = sender as LinkButton; GridViewRow row = (GridViewRow)lnk.Parent.Parent; int Idx = row.RowIndex; int IntResult = 0; bool Status; int VenID; VendorBAL VendorBAL = new VendorBAL(); LinkButton lblIsActive = (GrdVendor.Rows[Idx].FindControl("lnkEdit") as LinkButton); Label lblStatus = (GrdVendor.Rows[Idx].FindControl("lnkStatus") as Label); { if (lblStatus.Text == "Active" || lblStatus.Text == "True") { Status = false; lblStatus.Text = "InActive"; lblIsActive.Text = "Activate"; } else { Status = true; lblStatus.Text = "Active"; lblIsActive.Text = "Deactivate"; } VenID = Convert.ToInt32(lnk.CommandArgument.ToString()); lblSelectID.Text = VenID.ToString(); Session["VenID"] = lblSelectID.Text; IntResult = VendorBAL.UpdateVendor(VenID, Status, LoginUser, Ret); } }
/// <summary> /// To get specific Vendor details /// </summary> /// <param name="VenID"></param> /// <returns></returns> protected DataTable GetUserDetails(int VenID) { VendorBAL VendorBAL = new VendorBAL(); DataTable DtGetUser = new DataTable(); try { DtGetUser = VendorBAL.SelectVendorID(VenID, LoginUser, Ret); } catch { throw; } finally { VendorBAL = null; } return(DtGetUser); }
/// <summary> /// To bind Vendor of 'Active' and 'InActive' Status /// </summary> /// <returns></returns> protected DataTable VenDetails() { VendorBAL VendorBAL = new VendorBAL(); DataTable DtVenDet = new DataTable(); try { DtVenDet = VendorBAL.LoadAllVendor(LoginUser, Ret); } catch { throw; } finally { VendorBAL = null; } return(DtVenDet); }
/// <summary> /// To Load Active Status Vedor details from 'Vendor Business Access Layer' /// </summary> /// <param name="IsActive"></param> /// <returns></returns> protected DataTable VenActiveDetails(bool IsActive) { VendorBAL VendorBAL = new VendorBAL(); DataTable DtVenActDet = new DataTable(); try { DtVenActDet = VendorBAL.LoadActiveVendor(LoginUser, Ret, IsActive); } catch { throw; } finally { VendorBAL = null; } return(DtVenActDet); }
/// <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; } } }
/// <summary> /// To bind Vendor of 'Active' and 'InActive' Status /// </summary> /// <returns></returns> protected DataTable VenDetails() { VendorBAL VendorBAL = new VendorBAL(); DataTable DtVenDet = new DataTable(); try { DtVenDet = VendorBAL.LoadAllVendor(LoginUser, Ret); } catch { throw; } finally { VendorBAL = null; } return DtVenDet; }
/// <summary> /// To Load Active Status Vedor details from 'Vendor Business Access Layer' /// </summary> /// <param name="IsActive"></param> /// <returns></returns> protected DataTable VenActiveDetails(bool IsActive) { VendorBAL VendorBAL = new VendorBAL(); DataTable DtVenActDet = new DataTable(); try { DtVenActDet = VendorBAL.LoadActiveVendor(LoginUser, Ret, IsActive); } catch { throw; } finally { VendorBAL = null; } return DtVenActDet; }
/// <summary> /// To get specific Vendor details /// </summary> /// <param name="VenID"></param> /// <returns></returns> protected DataTable GetUserDetails(int VenID) { VendorBAL VendorBAL = new VendorBAL(); DataTable DtGetUser = new DataTable(); try { DtGetUser = VendorBAL.SelectVendorID(VenID, LoginUser, Ret); } catch { throw; } finally { VendorBAL = null; } return DtGetUser; }