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