public static bool DeleteAppointmentEvents(ATTAppointment objAppointment)
{
string deleteSQL = "SP_DEL_APPOINTMENT";
int countAppointee = objAppointment.LstAppointee.Count;
OracleParameter[] paramArray = new OracleParameter[2];
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objAppointment.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_APPOINTMENT_ID", objAppointment.AppointmentID, OracleDbType.Int64, ParameterDirection.InputOutput);
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
if (countAppointee > 0)
{
DLLAppointee.DeleteAppointee(objAppointment, null, Tran);
}
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, deleteSQL, paramArray);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw (ex);
}
finally
{
GetConn.CloseDbConn();
}
}
public static List <ATTAppointment> SetAppointment(DataRow row, string dateString, ATTUserLogin login)
{
try
{
List <ATTAppointment> lstAppointmentEvents = new List <ATTAppointment>();
ATTAppointment objAppointment = new ATTAppointment(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["APPOINTMENT_ID"].ToString()),
int.Parse(row["APPOINTMENT_CALLEDBY"].ToString()),
row["APPOINTMENT_SUBJECT"].ToString(),
row["APPOINTMENT_DATE"].ToString(),
row["START_TIME"].ToString(),
row["END_TIME"].ToString(),
int.Parse(row["STATUS"].ToString()),
row["VENUE"].ToString()
);
lstAppointmentEvents.Add(objAppointment);
if (tblAppointee.Rows.Count > 0)
{
objAppointment.LstAppointee = SetAppointee(row);
}
return(lstAppointmentEvents);
}
catch (Exception ex)
{
throw(ex);
}
}
public static string SaveAppointmentEvents(ATTAppointment objAppointment)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
string saveSQL = "SP_ADD_APPOINTMENT";
string eventIDs = "";
int countAppointee = objAppointment.LstAppointee.Count;
OracleParameter[] paramArray = new OracleParameter[11];
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objAppointment.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_APPOINTMENT_ID", null, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[2] = Utilities.GetOraParam(":P_APPOINTMENT_CALLED_BY", objAppointment.AppointmentCalledBy, OracleDbType.Int64, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":P_APPOINTMENT_SUBJECT", objAppointment.AppointmentSubject, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":P_APPOINTMENT_DATE", objAppointment.AppointmentDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":P_START_TIME", objAppointment.StartTime, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":P_END_TIME", objAppointment.EndTime, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":P_VENUE", objAppointment.Venue, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":P_STATUS", objAppointment.Status, OracleDbType.Int64, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", objAppointment.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", objAppointment.EntryOn, OracleDbType.Date, ParameterDirection.Input);
try
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, saveSQL, paramArray);
objAppointment.AppointmentID = int.Parse(paramArray[1].Value.ToString());
eventIDs += paramArray[1].Value.ToString() + "/";
if (countAppointee > 0)
{
eventIDs += DLLAppointee.SaveAppointee(objAppointment, 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();
}
}
public static string SaveAppointmentEvents(ATTAppointment objAppointment)
{
try
{
return(DLLAppointment.SaveAppointmentEvents(objAppointment));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteAppointmentEvents(ATTAppointment objAppointment)
{
try
{
DLLAppointment.DeleteAppointmentEvents(objAppointment);
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
public static string SaveAppointee(ATTAppointment objAppointment, OracleTransaction Tran)
{
try
{
string saveSQL = "SP_ADD_APPOINTEE";
//string appointeeIDs = "";
string outdoorAppointeeName;
string outdoorAppointeeOrgName;
foreach (ATTAppointee objAppointee in objAppointment.LstAppointee)
{
OracleParameter[] paramArray = new OracleParameter[11];
objAppointee.OrgID = objAppointment.OrgID;
objAppointee.AppointmentID = objAppointment.AppointmentID;
if (objAppointee.IsIndoorAppointee == "N")
{
outdoorAppointeeName = objAppointee.Appointee;
outdoorAppointeeOrgName = objAppointee.OutdoorOrgName;
}
else
{
outdoorAppointeeName = "";
outdoorAppointeeOrgName = "";
}
paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", objAppointee.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":P_APPOINTMENT_ID", objAppointee.AppointmentID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":P_AP_ID", null, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[3] = Utilities.GetOraParam(":P_APPOINTEE_ID", objAppointee.AppointeeID, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[4] = Utilities.GetOraParam(":P_IS_INDOOR_APPOINTEE", objAppointee.IsIndoorAppointee, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":P_OUTDOOR_APPOINTEE_NAME", outdoorAppointeeName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":P_OUTDOOR_APPOINTEE_ORG_NAME", outdoorAppointeeOrgName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":P_FLAG", objAppointee.Flag, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":P_REMARK", objAppointee.Remark, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", objAppointee.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", objAppointee.EntryOn, OracleDbType.Date, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, saveSQL, paramArray);
}
return("");
}
catch (Exception ex)
{
throw (ex);
}
}
public static bool UpdateAppointmentEvents(ATTAppointment objAppointment)
{
try
{
if (DLLAppointment.UpdateAppointmentEvents(objAppointment))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation ValidateAppointmentEntry(ATTAppointment objAppointment)
{
ObjectValidation OV = new ObjectValidation();
if (objAppointment.Status <= 0)
{
OV.IsValid = false;
OV.ErrorMessage = "Please select Status.";
return(OV);
}
if (objAppointment.StartTime == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Please Enter Start Time.";
return(OV);
}
if (objAppointment.AppointmentSubject == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Please Enter Subject.";
return(OV);
}
if (objAppointment.AppointmentDate == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Please Enter Appointment Date.";
return(OV);
}
if (objAppointment.Venue == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Please Enter Venue.";
return(OV);
}
return(OV);
}
public static bool DeleteAppointee(ATTAppointment objAppointment, ATTAppointee objAppointee, OracleTransaction Tran)
{
try
{
string deleteSQL = "SP_DEL_APPOINTEE";
int? orgID;
int? appointmentID;
//int? appointeeID ;
int?apID;
if (objAppointment != null)
{
orgID = objAppointment.OrgID;
appointmentID = objAppointment.AppointmentID;
//appointeeID = null;
apID = null;
}
else
{
orgID = objAppointee.OrgID;
appointmentID = objAppointee.AppointmentID;
//appointeeID = objAppointee.AppointeeID;
apID = objAppointee.ApID;
}
OracleParameter[] paramArray = new OracleParameter[3];
paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", orgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":P_APPOINTMENT_ID", appointmentID, OracleDbType.Int64, ParameterDirection.Input);
//paramArray[2] = Utilities.GetOraParam(":P_APPOINTEE_ID", appointeeID, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[2] = Utilities.GetOraParam(":P_AP_ID", apID, OracleDbType.Int64, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, deleteSQL, paramArray);
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
