public static List <ATTMeetingStatus> GetMeetingStatusList(int?msID, bool containDefault)
{
List <ATTMeetingStatus> lst = new List <ATTMeetingStatus>();
try
{
foreach (DataRow row in DLLMeetingStatus.GetMeetingStatusTable(msID).Rows)
{
ATTMeetingStatus obj = new ATTMeetingStatus();
obj.MeetingStatusID = int.Parse(row["ms_id"].ToString());
obj.MeetingStatusName = row["mstatus_name"].ToString();
obj.MeetingStatusColor = row["mstatus_color"].ToString();
obj.Action = "E";
lst.Add(obj);
}
if (lst.Count > 0 && containDefault == true)
{
ATTMeetingStatus def = new ATTMeetingStatus();
def.MeetingStatusID = -1;
def.MeetingStatusName = "छान्नुहोस्";
lst.Insert(0, def);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ATTMeetingStatus status = new ATTMeetingStatus();
status.MeetingStatusName = this.txtMeetingStatus.Text;
if (this.lstMeetingStatus.SelectedIndex < 0)
{
status.MeetingStatusID = 0;
status.MeetingStatusColor = this.ColorPicker.Color;
status.Action = "A";
}
else
{
status.MeetingStatusID = ((List <ATTMeetingStatus>)Session["MeetingStatusLst"])[this.lstMeetingStatus.SelectedIndex].MeetingStatusID;
status.MeetingStatusColor = this.ColorPicker.Color;
status.Action = "E";
}
ObjectValidation result = BLLMeetingStatus.Validate(status);
if (result.IsValid == false)
{
this.lblStatusMessage.Text = result.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
try
{
BLLMeetingStatus.AddMeetingStatus(status);
List <ATTMeetingStatus> lst = ((List <ATTMeetingStatus>)Session["MeetingStatusLst"]);
if (status.Action == "A")
{
lst.Add(status);
}
else
{
lst[this.lstMeetingStatus.SelectedIndex] = status;
}
this.lstMeetingStatus.DataSource = lst;
this.lstMeetingStatus.DataTextField = "MeetingStatusName";
this.lstMeetingStatus.DataValueField = "MeetingStatusID";
this.lstMeetingStatus.DataBind();
this.ClearME();
this.lstMeetingStatus.SelectedIndex = -1;
this.lblStatusMessage.Text = "Meeting status successfully saved.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static bool AddMeetingStatus(ATTMeetingStatus status)
{
try
{
return(DLLMeetingStatus.AddMeetingStatus(status));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTMeetingStatus obj)
{
ObjectValidation result = new ObjectValidation();
if (obj.MeetingStatusName == "")
{
result.IsValid = false;
result.ErrorMessage = "Meeting status name cannot be blank.";
return(result);
}
return(result);
}
public static bool AddMeetingStatus(ATTMeetingStatus status)
{
string SP = "";
if (status.Action == "A")
{
SP = "sp_add_meeting_status";
}
else if (status.Action == "E")
{
SP = "sp_edit_meeting_status";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("p_ms_id", status.MeetingStatusID, OracleDbType.Int16, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam("p_ms_name", status.MeetingStatusName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_ms_color", status.MeetingStatusColor, OracleDbType.Varchar2, ParameterDirection.Input));
GetConnection DBConn = new GetConnection();
try
{
OracleConnection Conn = DBConn.GetDbConn(Module.OAS);
SqlHelper.ExecuteNonQuery(Conn, CommandType.StoredProcedure, SP, paramArray.ToArray());
status.MeetingStatusID = int.Parse(paramArray[0].Value.ToString());
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DBConn.CloseDbConn();
}
}
