/// <summary> /// To edit Stakeholder 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 StakID; StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); LinkButton lblIsActive = (GrdStakeholder.Rows[Idx].FindControl("lnkEdit") as LinkButton); Label lblStatus = (GrdStakeholder.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"; } StakID = Convert.ToInt32(lnk.CommandArgument.ToString()); lblSelectID.Text = StakID.ToString(); Session["StakID"] = lblSelectID.Text; IntResult = StakeHolderBAL.UpdateStakeholder(StakID, Status, LoginUser, Ret); } }
/// <summary> /// To get Stakeholder having active status /// </summary> /// <param name="IsActive"></param> /// <returns></returns> protected DataTable SActiveDetails(bool IsActive) { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); DataTable DtSActDet = new DataTable(); try { DtSActDet = StakeHolderBAL.LoadActiveStakeholder(LoginUser, Ret, IsActive); } catch { throw; } finally { StakeHolderBAL = null; } return(DtSActDet); }
/// <summary> /// To get Stakeholder details from Stakeholder Business access layer /// </summary> /// <returns></returns> protected DataTable StakDetails() { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); DataTable DtStakDet = new DataTable(); try { DtStakDet = StakeHolderBAL.LoadAllStakeholder(LoginUser, Ret); } catch { throw; } finally { StakeHolderBAL = null; } return(DtStakDet); }
/// <summary> /// To get specific Stakeholder details /// </summary> /// <param name="StakID"></param> /// <returns></returns> protected DataTable GetUserDetails(int StakID) { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); DataTable DtGetUser = new DataTable(); try { DtGetUser = StakeHolderBAL.SelectStakeholderID(StakID, LoginUser, Ret); } catch { throw; } finally { StakeHolderBAL = null; } return(DtGetUser); }
/// <summary> /// To save and update Stakeholder details /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); int UserID = Convert.ToInt32(ddlStakUser.SelectedValue.ToString()); string Status = ddlStakStatus.SelectedValue.ToString(); bool IsActive = true; if (Status == "Active") { IsActive = true; } else if (Status == "InActive") { IsActive = false; } if (btnSave.Text == "Save") { try { int Result = StakeHolderBAL.InsertStakeholder(UserID, IsActive, LoginUser, Ret); DtStakeholder = StakDetails(); ViewState["DtStakeholder"] = DtStakeholder; BindStak(DtStakeholder); MsgStak.Msg = "Record added successfully"; MsgStak.showmsg(); } catch (Exception ee) { if (ee.Message == "Duplicate Entry") { MsgStak.Msg = "Stakeholder already exists"; MsgStak.showmsg(); ClearStak(); } } finally { StakeHolderBAL = null; } } }
protected DataTable SActiveDetails(bool IsActive) { StakeHolderBAL sBAL = new StakeHolderBAL(); DataTable dTable = new DataTable(); try { dTable = sBAL.LoadActiveStakeholder(LoginUser, Ret, IsActive); } catch { throw; } finally { sBAL = null; } return dTable; }
/// <summary> /// To get Stakeholder details from Stakeholder Business access layer /// </summary> /// <returns></returns> protected DataTable StakDetails() { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); DataTable DtStakDet = new DataTable(); try { DtStakDet = StakeHolderBAL.LoadAllStakeholder(LoginUser, Ret); } catch { throw; } finally { StakeHolderBAL = null; } return DtStakDet; }
/// <summary> /// To get Stakeholder having active status /// </summary> /// <param name="IsActive"></param> /// <returns></returns> protected DataTable SActiveDetails(bool IsActive) { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); DataTable DtSActDet = new DataTable(); try { DtSActDet = StakeHolderBAL.LoadActiveStakeholder(LoginUser, Ret, IsActive); } catch { throw; } finally { StakeHolderBAL = null; } return DtSActDet; }
/// <summary> /// To get specific Stakeholder details /// </summary> /// <param name="StakID"></param> /// <returns></returns> protected DataTable GetUserDetails(int StakID) { StakeHolderBAL StakeHolderBAL = new StakeHolderBAL(); DataTable DtGetUser = new DataTable(); try { DtGetUser = StakeHolderBAL.SelectStakeholderID(StakID, LoginUser, Ret); } catch { throw; } finally { StakeHolderBAL = null; } return DtGetUser; }