/// <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 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 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;
}
}
}
