public static List <ATTAppointee> SetAppointee(DataRow appRow) { try { List <ATTAppointee> lstAppointee = new List <ATTAppointee>(); foreach (DataRow row in tblAppointee.Rows) { if (int.Parse(appRow["ORG_ID"].ToString()) == int.Parse(row["ORG_ID"].ToString()) && int.Parse(appRow["APPOINTMENT_ID"].ToString()) == int.Parse(row["APPOINTMENT_ID"].ToString()) ) { int? appointeeID; string appointee = ""; string outdoorAppointeeOrgName; if (row["APPOINTEE_ID"].ToString() != "") { appointeeID = int.Parse(row["APPOINTEE_ID"].ToString()); appointee = row["FIRST_NAME"].ToString() + (row["MID_NAME"].ToString() == "" ? "" : " " + row["MID_NAME"].ToString()) + (row["SUR_NAME"].ToString() == "" ? "" : " " + row["SUR_NAME"].ToString()); outdoorAppointeeOrgName = ""; } else { appointeeID = null; appointee = row["OUTDOOR_APPOINTEE_NAME"].ToString(); outdoorAppointeeOrgName = row["OUTDOOR_APPOINTEE_ORG_NAME"].ToString(); } ATTAppointee objAppointee = new ATTAppointee(); objAppointee.OrgID = int.Parse(row["ORG_ID"].ToString()); objAppointee.AppointmentID = int.Parse(row["APPOINTMENT_ID"].ToString()); objAppointee.ApID = int.Parse(row["AP_ID"].ToString()); objAppointee.AppointeeID = appointeeID; objAppointee.Appointee = appointee; objAppointee.IsIndoorAppointee = row["IS_INDOOR_APPOINTEE"].ToString(); objAppointee.Action = "N"; objAppointee.OutdoorOrgName = outdoorAppointeeOrgName; objAppointee.EntryOn = DateTime.Parse(row["ENTRY_ON"].ToString()); objAppointee.Flag = row["flag"].ToString(); objAppointee.Remark = row["remark"].ToString(); lstAppointee.Add(objAppointee); } } return(lstAppointee); } catch (Exception ex) { throw(ex); } }
public static bool SaveAppointee(ATTAppointee objAppointee, OracleTransaction Tran) { try { string saveSQL = "SP_ADD_APPOINTEE"; //string appointeeIDs = ""; string outdoorAppointeeName; string outdoorAppointeeOrgName; if (objAppointee.IsIndoorAppointee == "N") { outdoorAppointeeName = objAppointee.Appointee; outdoorAppointeeOrgName = objAppointee.OutdoorOrgName; } else { outdoorAppointeeName = ""; outdoorAppointeeOrgName = ""; } OracleParameter[] paramArray = new OracleParameter[11]; //if (objAppointee.Action == "A") //{ 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(true); } catch (Exception ex) { throw (ex); } }
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); } }