public static List <ATTMeetingType> GetMeetingTypeList()
{
List <ATTMeetingType> lstMeetingType = new List <ATTMeetingType>();
try
{
foreach (DataRow row in DLLMeetingType.GetMeetingTypeListTable().Rows)
{
ATTMeetingType objMeetingType = new ATTMeetingType(
int.Parse(row["MTYPE_ID"].ToString()),
row["MTYPE_NAME"].ToString(),
row["DESCRIPTION"].ToString()
);
objMeetingType.Action = "E";
lstMeetingType.Add(objMeetingType);
}
return(lstMeetingType);
}
catch (Exception ex)
{
throw(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ATTMeetingType Mtype = new ATTMeetingType();
Mtype.MeetingTypeName = this.txtMeetingType.Text;
Mtype.MeetingTypeDesc = this.txtDescription.Text;
if (this.lstMeetingType.SelectedIndex < 0)//add mode
{
Mtype.MeetingTypeID = 0;
Mtype.Action = "A";
}
else //edit mode
{
Mtype.MeetingTypeID = ((List <ATTMeetingType>)Session["MeetingTypeLst"])[this.lstMeetingType.SelectedIndex].MeetingTypeID;
Mtype.Action = "E";
}
ObjectValidation result = BLLMeetingType.Validate(Mtype);
if (result.IsValid == false)
{
this.lblStatusMessage.Text = result.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
try
{
BLLMeetingType.AddMeetingType(Mtype);
List <ATTMeetingType> lst = ((List <ATTMeetingType>)Session["MeetingTypeLst"]);
if (Mtype.Action == "A")
{
lst.Add(Mtype);
}
else
{
lst[this.lstMeetingType.SelectedIndex] = Mtype;
}
this.lstMeetingType.DataSource = lst;
this.lstMeetingType.DataTextField = "MeetingTypeName";
this.lstMeetingType.DataValueField = "MeetingTypeID";
this.lstMeetingType.DataBind();
this.ClearME();
this.lstMeetingType.SelectedIndex = -1;
this.lblStatusMessage.Text = "Meeting Type successfully saved.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void lstMeetingType_SelectedIndexChanged(object sender, EventArgs e)
{
ATTMeetingType obj = ((List <ATTMeetingType>)Session["MeetingTypeLst"])[this.lstMeetingType.SelectedIndex];
this.ClearME();
this.txtMeetingType.Text = obj.MeetingTypeName;
this.txtDescription.Text = obj.MeetingTypeDesc;
}
public static bool AddMeetingType(ATTMeetingType obj)
{
try
{
return(DLLMeetingType.AddMeetingType(obj));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTMeetingType obj)
{
ObjectValidation result = new ObjectValidation();
if (obj.MeetingTypeName == "")
{
result.IsValid = false;
result.ErrorMessage = "Meeting type name cannot be blank.";
return(result);
}
return(result);
}
public static bool AddMeetingType(ATTMeetingType obj)
{
string SP = "";
if (obj.Action == "A")
{
SP = "SP_ADD_MEETING_TYPE";
}
else if (obj.Action == "E")
{
SP = "SP_EDIT_MEETING_TYPE";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("p_mtype_id", obj.MeetingTypeID, OracleDbType.Int16, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam("p_mtype_name", obj.MeetingTypeName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_desc", obj.MeetingTypeDesc, OracleDbType.Varchar2, ParameterDirection.Input));
GetConnection DBConn = new GetConnection();
try
{
OracleConnection Conn = DBConn.GetDbConn(Module.OAS);
SqlHelper.ExecuteNonQuery(Conn, CommandType.StoredProcedure, SP, paramArray.ToArray());
obj.MeetingTypeID = int.Parse(paramArray[0].Value.ToString());
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DBConn.CloseDbConn();
}
}