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