public static bool DeleteMeetingEvents(ATTMeeting objMeeting)
{
string deleteSQL = "SP_DEL_MEETING";
int CountMeetingAgenda = objMeeting.LstMeetingAgenda.Count;
int CountMeetingParticipant = objMeeting.LstMeetingParticipant.Count;
OracleParameter[] paramArray = new OracleParameter[2];
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objMeeting.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_MEETING_ID", objMeeting.MeetingID, OracleDbType.Int64, ParameterDirection.Input);
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
if (CountMeetingAgenda > 0)
{
DLLMeetingAgenda.DeleteMeetingAgenda(objMeeting, Tran);
}
if (CountMeetingParticipant > 0)
{
DLLMeetingParticipant.DeleteMeetingParticipant(objMeeting, Tran);
}
DLLMeetingMinute.DeleteMeetingMinute(objMeeting, Tran);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, deleteSQL, paramArray);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw (ex);
}
finally
{
GetConn.CloseDbConn();
}
}
public static string SaveMeetingEvents(ATTMeeting objMeeting)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
if (objMeeting.VenueType == "INS")
{
int bookedVenueCount = CheckVenueAvailability(objMeeting, Tran);
if (bookedVenueCount < 1)
{
Tran.Commit();
return("-1");
}
int venueInUseCount = CheckVenueInUse(objMeeting, Tran);
if (venueInUseCount > 0)
{
Tran.Commit();
return("-2");
}
}
string SaveSQL = "SP_ADD_MEETING";
string eventIDs = "";
int CountMeetingAgenda = objMeeting.LstMeetingAgenda.Count;
int CountMeetingParticipant = objMeeting.LstMeetingParticipant.Count;
OracleParameter[] paramArray = new OracleParameter[18];
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objMeeting.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_MEETING_ID", null, OracleDbType.Int64, ParameterDirection.Output);
paramArray[2] = Utilities.GetOraParam(":P_MTYPE_ID", objMeeting.MeetingTypeID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":P_VENUE_ID", objMeeting.VenueID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":P_MEETING_SUBJECT", objMeeting.Subject, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":P_MEETING_DATE", objMeeting.MeetingDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":P_CALLED_BY", objMeeting.CalledBy, OracleDbType.Int64, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":P_START_TIME", objMeeting.StartTime, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":P_END_TIME", objMeeting.EndTime, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", objMeeting.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", objMeeting.EntryOn, OracleDbType.Date, ParameterDirection.Input);
paramArray[11] = Utilities.GetOraParam(":P_STATUS", objMeeting.Status, OracleDbType.Int64, ParameterDirection.Input);
paramArray[12] = Utilities.GetOraParam(":P_REMARKS", objMeeting.Remark, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[13] = Utilities.GetOraParam(":P_IS_GRP_CALLER ", objMeeting.IsGrpCaller, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[14] = Utilities.GetOraParam(":P_CALLED_BY_P_ID", objMeeting.CalledByPID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[15] = Utilities.GetOraParam(":P_VENUE_TYPE", objMeeting.VenueType, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[16] = Utilities.GetOraParam(":P_VENUE_DATA", objMeeting.VenueData, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[17] = Utilities.GetOraParam(":P_VENUE_BOOKING_ID", objMeeting.VenueBookingID, OracleDbType.Int64, ParameterDirection.Input);
try
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SaveSQL, paramArray);
objMeeting.MeetingID = int.Parse(paramArray[1].Value.ToString());
eventIDs += paramArray[1].Value.ToString() + "/";
if (CountMeetingAgenda > 0)
{
eventIDs += DLLMeetingAgenda.SaveMeetingAgenda(objMeeting, Tran);
}
if (CountMeetingParticipant > 0)
{
eventIDs += DLLMeetingParticipant.SaveMeetingParticipant(objMeeting, Tran);
}
Tran.Commit();
if (eventIDs.Length > 0)
{
eventIDs = eventIDs.Substring(0, eventIDs.Length - 1);
}
return(eventIDs);
}
catch (Exception ex)
{
Tran.Rollback();
throw (ex);
}
finally
{
GetConn.CloseDbConn();
}
}