/// <summary>
/// To search Stakeholder Relationship Manager details by different conditions
/// </summary>
/// <param name="DvSRM"></param>
/// <param name="Column"></param>
/// <param name="Operator"></param>
/// <param name="Value"></param>
public void FilterDataView(DataView DvSRM, string Column, string Operator, string Value)
{
DvSRM.RowFilter = Column + " " + Operator + "'" + Value + "'";
if (DvSRM.ToTable().Rows.Count == 0)
{
MsgSRM.Msg = "Record(s) not found";
MsgSRM.showmsg();
ViewState["DtSRM"] = DvSRM.ToTable();;
BindSRM(DvSRM.ToTable());
ddlCol.SelectedIndex = 0;
ddlOpe.SelectedIndex = 0;
ddlVal.SelectedIndex = 0;
}
else
{
ViewState["DtSRM"] = DvSRM.ToTable();;
BindSRM(DvSRM.ToTable());
}
}
/// <summary>
/// To save and update Stakeholder Relationship Manager details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
StakeholderRelationshipManagerBAL StakeholderRelationshipManagerBAL = new StakeholderRelationshipManagerBAL();
int UserID = Convert.ToInt32(ddlSRMUser.SelectedValue.ToString());
string Status = ddlSRMStatus.SelectedValue.ToString();
bool IsActive = true;
if (Status == "Active")
{
IsActive = true;
}
else if (Status == "InActive")
{
IsActive = false;
}
if (btnSave.Text == "Save")
{
try
{
int Result = StakeholderRelationshipManagerBAL.InsertStakeholderRelationshipManager(UserID, IsActive, LoginUser, Ret);
DtSRM = SRMDetails();
ViewState["DtSRM"] = DtSRM;
BindSRM(DtSRM);
MsgSRM.Msg = "Record added successfully";
MsgSRM.showmsg();
}
catch (Exception ee)
{
if (ee.Message == "Duplicate Entry")
{
MsgSRM.Msg = "Stakeholder Relationship Manager already exists";
MsgSRM.showmsg();
ClearSRM();
}
}
finally
{
StakeholderRelationshipManagerBAL = null;
}
}
}
