/// <summary>
/// To search Stakeholder details by different conditions
/// </summary>
/// <param name="Dv"></param>
/// <param name="Column"></param>
/// <param name="Operator"></param>
/// <param name="Value"></param>
public void FilterDataview(DataView Dv, string Column, string Operator, string Value)
{
Dv.RowFilter = Column + " " + Operator + "'" + Value + "'";
if (Dv.ToTable().Rows.Count == 0)
{
MsgStak.Msg = "Record(s) not found";
MsgStak.showmsg();
ViewState["DtStakeholder"] = Dv.ToTable();
BindStak(Dv.ToTable());
ddlCol.SelectedIndex = 0;
ddlOpe.SelectedIndex = 0;
ddlVal.SelectedIndex = 0;
}
else
{
ViewState["DtStakeholder"] = Dv.ToTable();
BindStak(Dv.ToTable());
}
}
/// <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;
}
}
}
