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();
}
}
