public static List <ATTMemberPosition> GetMemberPositionList(int?positionID, bool containDefault) { List <ATTMemberPosition> lst = new List <ATTMemberPosition>(); try { foreach (DataRow row in DLLMemberPosition.GetMemberPositionTable(positionID).Rows) { ATTMemberPosition obj = new ATTMemberPosition(); obj.PositionID = int.Parse(row["Position_ID"].ToString()); obj.PositionName = row["Position_Name"].ToString(); obj.Action = "E"; lst.Add(obj); } if (containDefault == true && lst.Count > 0) { ATTMemberPosition def = new ATTMemberPosition(); def.PositionID = 0; def.PositionName = "छान्नुहोस्"; lst.Insert(0, def); } return(lst); } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { ATTMemberPosition MP = new ATTMemberPosition(); MP.PositionName = this.txtPosition.Text; if (this.lstMemberPosition.SelectedIndex < 0) { MP.Action = "A"; MP.PositionID = 0; } else { MP.Action = "E"; MP.PositionID = ((List <ATTMemberPosition>)Session["MemberPositionLst"])[this.lstMemberPosition.SelectedIndex].PositionID; } ObjectValidation result = BLLMemberPosition.Validate(MP); if (result.IsValid == false) { this.lblStatusMessage.Text = result.ErrorMessage; this.programmaticModalPopup.Show(); return; } try { BLLMemberPosition.AddMemberPosition(MP); List <ATTMemberPosition> lst = ((List <ATTMemberPosition>)Session["MemberPositionLst"]); if (MP.Action == "A") { lst.Add(MP); } else { lst[this.lstMemberPosition.SelectedIndex] = MP; } this.lstMemberPosition.DataSource = lst; this.lstMemberPosition.DataTextField = "PositionName"; this.lstMemberPosition.DataValueField = "PositionID"; this.lstMemberPosition.DataBind(); this.ClearME(); this.lstMemberPosition.SelectedIndex = -1; this.lblStatusMessage.Text = "Member position sucessfully saved."; this.programmaticModalPopup.Show(); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool AddMemberPosition(ATTMemberPosition member) { try { return(DLLMemberPosition.AddMemberPosition(member)); } catch (Exception ex) { throw ex; } }
public static ObjectValidation Validate(ATTMemberPosition obj) { ObjectValidation result = new ObjectValidation(); if (obj.PositionName == "") { result.IsValid = false; result.ErrorMessage = "Member position name cannot be blank."; return(result); } return(result); }
public static bool AddMemberPosition(ATTMemberPosition member) { string SP = ""; if (member.Action == "A") { SP = "sp_add_member_position"; } else if (member.Action == "E") { SP = "sp_edit_member_position"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("p_position_id", member.PositionID, OracleDbType.Int16, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("p_position_name", member.PositionName, OracleDbType.Varchar2, ParameterDirection.Input)); GetConnection DBConn = new GetConnection(); try { OracleConnection Conn = DBConn.GetDbConn(Module.OAS); SqlHelper.ExecuteNonQuery(Conn, CommandType.StoredProcedure, SP, paramArray.ToArray()); member.PositionID = int.Parse(paramArray[0].Value.ToString()); return(true); } catch (Exception ex) { throw ex; } finally { DBConn.CloseDbConn(); } }