public static bool AddLeaveTippaniDetail ( List <ATTGeneralTippaniSummary> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP; List <OracleParameter> paramArray; try { foreach (ATTGeneralTippaniDetail detail in lst) { if (detail.Action != "N") { SP = DLLGeneralTippaniDetail.GetLeaveLevelSP(detail.LeaveLevel, detail.Action); paramArray = DLLGeneralTippaniDetail.GetLeaveLevelSpParameter(detail, tippaniID); SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); paramArray.Clear(); } } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddTrainingTippaniDetail ( List <ATTGeneralTippaniDetail> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniDetail detail in lst) { if (detail.Action != "N") { if (detail.Action == "A") { SP = "SP_ADD_TRAINING_TIPPANI_DETAIL"; } else if (detail.Action == "E") { SP = "SP_EDIT_TRN_TIPPANI_DETAIL"; } else if (detail.Action == "D") { SP = "sp_del_tippani_detail"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", detail.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_EMP_ID", detail.EmpID, OracleDbType.Double, ParameterDirection.Input)); if (detail.Action != "D") { paramArray.Add(Utilities.GetOraParam("P_TRN_SUBJECT", detail.TrnSubject, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_INSTITUTION_ID", detail.TrnInstitutionID, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TRN_FROM_DATE", detail.TrnFromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TRN_TO_DATE", detail.TrnToDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TRN_REMARKS", detail.TrnRemark, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TRN_ENTRY_BY", detail.TrnEntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); //detail.TippaniSNO = int.Parse(paramArray[2].Value.ToString()); paramArray.Clear(); } } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddCommitteeTippaniDetail ( List <ATTGeneralTippaniDetail> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniDetail detail in lst) { if (detail.Action != "N") { if (detail.Action == "A") { SP = "sp_add_comm_by_tippani_detail"; } else if (detail.Action == "E") { SP = ""; } else if (detail.Action == "D") { SP = "SP_DEL_TIPPANI_DETAIL"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", detail.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_EMP_ID", detail.EmpID, OracleDbType.Double, ParameterDirection.Input)); if (detail.Action != "D") { paramArray.Add(Utilities.GetOraParam("p_com_org_id", detail.CommitteeOrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_committee_id", detail.CommitteeID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_ENTRY_BY", detail.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); //detail.TippaniSNO = int.Parse(paramArray[2].Value.ToString()); paramArray.Clear(); } } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddGeneralTippaniDetail ( List <ATTGeneralTippaniDetail> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { try { if (subject == TippaniSubject.Leave) //1. leave tippani { DLLGeneralTippaniDetail.AddLeaveTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Visit) //2. visit tippani { DLLGeneralTippaniDetail.AddVisitTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Posting) //3. posting tippani { DLLGeneralTippaniDetail.AddPostingTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Training) //4. training tippani { DLLGeneralTippaniDetail.AddTrainingTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Deputation) //5. deputaion tippani { DLLGeneralTippaniDetail.AddDeputationTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Punishment) //6. punishment tippani { DLLGeneralTippaniDetail.AddPunishmentTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Award) //7. award tippani { DLLGeneralTippaniDetail.AddAwardTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } else if (subject == TippaniSubject.Committee) //8. committee tippani { DLLGeneralTippaniDetail.AddCommitteeTippaniDetail(lst, tran, tippaniSubjectID, subject, tippaniID); } return(true); } catch (Exception ex) { throw ex; } }
public static int AddCommitteeByTippani ( ATTCommitteeByTippani comm, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP = ""; if (comm.Action == "A") { SP = "SP_ADD_COMMITTEE_BY_TIPPANI"; } else if (comm.Action == "E") { SP = "SP_UP_COMMITTEE_BY_TIPPANI"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("p_comm_org_id", comm.CommitteeOrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_committee_id", comm.CommitteeID, OracleDbType.Int16, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("p_committee_name", comm.CommitteeName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_description", comm.Description, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_type", comm.Type, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_org_id", comm.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_tippani_id", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_entry_by", comm.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); try { SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); int CID = int.Parse(paramArray[1].Value.ToString()); comm.CommitteeID = CID; return(CID); } catch (Exception ex) { throw ex; } }
public static int AddCommitteeByTippani ( ATTCommitteeByTippani comm, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { try { return(DLLCommitteeByTippani.AddCommitteeByTippani(comm, tran, tippaniSubjectID, subject, tippaniID)); } catch (Exception ex) { throw ex; } }
public static bool AddAttachment(List <ATTGeneralTippaniAttachment> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID, int processID) { try { return(DLLGeneralTippaniAttachment.AddAttachment(lst, tran, tippaniSubjectID, subject, tippaniID, processID)); } catch (Exception ex) { throw ex; } }
public static bool UpdateChannelPersonDecisionAndAddProcess(ATTGeneralTippaniProcess process, List <ATTGeneralTippaniProcess> lst, List <ATTGeneralTippaniAttachment> lstAttachment, TippaniSubject subject) { string SP = "SP_UPD_CHNL_PERSON_DECISION"; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("P_ORG_ID", process.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", process.TippaniID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_PRC_ID", process.TippaniProcessID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_NOTE", process.Note, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_STATUS", process.Status, OracleDbType.Int64, ParameterDirection.Input)); GetConnection DBConn = new GetConnection(); OracleConnection Conn = DBConn.GetDbConn(Module.OAS); OracleTransaction Tran = Conn.BeginTransaction(); try { if (process != null) { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray()); if (lst != null && lst.Count > 0) { DLLGeneralTippaniProcess.AddGeneralTippaniProcessDetail(lst, Tran, (int)subject, subject, process.TippaniID); } if (lstAttachment != null && lstAttachment.Count > 0) { DLLGeneralTippaniAttachment.AddAttachment(lstAttachment, Tran, (int)subject, subject, process.TippaniID, process.TippaniProcessID); } } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { Tran.Dispose(); DBConn.CloseDbConn(); } }
//public static bool SendBackTippani(ATTGeneralTippaniProcess process, int tippaniSubjectID, List<ATTGeneralTippaniAttachment> lstAttachment) //{ // string SP = ""; // SP = "SP_ADD_TIPPANI_PROCESS_DETAIL"; // List<OracleParameter> paramArray = new List<OracleParameter>(); // paramArray.Add(Utilities.GetOraParam("P_ORG_ID", process.OrgID, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", process.TippaniID, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_TIPPANI_PROCESS_ID", process.TippaniProcessID, OracleDbType.Int32, ParameterDirection.InputOutput)); // paramArray.Add(Utilities.GetOraParam("P_SEND_BY", process.SendBy, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_SEND_ON", process.SendOn, OracleDbType.Varchar2, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_SEND_TO", process.SendTo, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_NOTE", process.Note, OracleDbType.Varchar2, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_STATUS", process.Status, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_SEND_TYPE", process.SendType, OracleDbType.Varchar2, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_TIPPANI_SUBJECT_ID", tippaniSubjectID, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_IS_CHANEL_PERSON", process.IsChannelPerson, OracleDbType.Varchar2, ParameterDirection.Input)); // GetConnection DBConn = new GetConnection(); // try // { // OracleConnection Conn = DBConn.GetDbConn(Module.OAS); // SqlHelper.ExecuteNonQuery(Conn, CommandType.StoredProcedure, SP, paramArray.ToArray()); // process.TippaniProcessID = int.Parse(paramArray[2].Value.ToString()); // //if (lstAttachment.Count > 0) // // DLLGeneralTippaniAttachment.AddAttachment(lstAttachment, Tran, 0, TippaniSubject.Visit, process.TippaniID, process.TippaniProcessID); // paramArray.Clear(); // return true; // } // catch (Exception ex) // { // throw ex; // } // finally // { // DBConn.CloseDbConn(); // } //} /***************************************************************************/ public static bool AddGeneralTippaniProcessDetail(List <ATTGeneralTippaniProcess> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniProcess process in lst) { if (process.Action == "A") { SP = "SP_ADD_TIPPANI_PROCESS_DETAIL"; } else if (process.Action == "E") { SP = "SP_EDIT_TIPPANI_PROCESS_DETAIL"; } else if (process.Action == "D") { SP = "SP_ADD_TIPPANI_PROCESS_DETAIL"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", process.OrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_PROCESS_ID", process.TippaniProcessID, OracleDbType.Int32, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_SENDER_ORG_ID", process.SenderOrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_SENDER_UNIT_ID", process.SenderUnitID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_SEND_BY", process.SendBy, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_SEND_ON", process.SendOn, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REC_ORG_ID", process.ReceiverOrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REC_UNIT_ID", process.ReceiverUnitID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_SEND_TO", process.SendTo, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_NOTE", process.Note, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_STATUS", process.Status, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_SEND_TYPE", process.SendType, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_SUBJECT_ID", tippaniSubjectID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_IS_CHANEL_PERSON", process.IsChannelPerson, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_entry_by", process.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); process.TippaniProcessID = int.Parse(paramArray[2].Value.ToString()); paramArray.Clear(); } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddGeneralTippaniProcess(List <ATTGeneralTippaniProcess> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID) { return(false); //string SP = ""; //List<OracleParameter> paramArray = new List<OracleParameter>(); //try //{ // foreach (ATTGeneralTippaniProcess process in lst) // { // if (process.Action == "A") // SP = "SP_ADD_TIPPANI_PROCESS"; // else if (process.Action == "E") // SP = "SP_EDIT_TIPPANI_PROCESS"; // else if (process.Action == "D") // SP = "SP_ADD_TIPPANI_PROCESS"; // paramArray.Add(Utilities.GetOraParam("P_ORG_ID", process.OrgID, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_TIPPANI_PROCESS_ID", process.TippaniProcessID, OracleDbType.Int32, ParameterDirection.InputOutput)); // paramArray.Add(Utilities.GetOraParam("P_PROCESS_BY", process.ProcessBy, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_PROCESS_ON", process.ProcessOn, OracleDbType.Varchar2, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_PROCESS_TO", process.ProcessTo, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_STATUS", process.Status, OracleDbType.Int32, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam("P_SEND_TYPE", process.SendType, OracleDbType.Varchar2, ParameterDirection.Input)); // SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); // process.TippaniProcessID = int.Parse(paramArray[2].Value.ToString()); // paramArray.Clear(); // } // return true; //} //catch (Exception ex) //{ // throw ex; //} }
//public static bool SendBackTippani(ATTGeneralTippaniProcess process, int subjectID, List<ATTGeneralTippaniAttachment> lstAttachment) //{ // try // { // return DLLGeneralTippaniProcess.SendBackTippani(process, subjectID, lstAttachment); // } // catch (Exception ex) // { // throw ex; // } //} /*********************************************************/ public static bool AddGeneralTippaniProcessDetail(List <ATTGeneralTippaniProcess> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID) { try { return(DLLGeneralTippaniProcess.AddGeneralTippaniProcessDetail(lst, tran, tippaniSubjectID, subject, tippaniID)); } catch (Exception ex) { throw ex; } }
public static bool UpdateChannelPersonDecisionAndAddProcess(ATTGeneralTippaniProcess process, List <ATTGeneralTippaniProcess> lst, List <ATTGeneralTippaniAttachment> lstAttachment, TippaniSubject subject, List <ATTGeneralTippaniSummary> lstRec) { try { return(DLLGeneralTippaniProcess.UpdateChannelPersonDecisionAndAddProcess(process, lst, lstAttachment, subject, lstRec)); } catch (Exception ex) { throw ex; } }
public static bool AddDeputationTippaniDetail ( List <ATTGeneralTippaniDetail> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniDetail detail in lst) { if (detail.Action != "N") { if (detail.Action == "A") { SP = "SP_ADD_DEP_TIPPANI_DETAIL"; } else if (detail.Action == "E") { SP = "SP_EDIT_DEP_TIPPANI_DETAIL"; } else if (detail.Action == "D") { SP = "sp_del_tippani_detail"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", detail.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_EMP_ID", detail.EmpID, OracleDbType.Double, ParameterDirection.Input)); if (detail.Action != "D") { paramArray.Add(Utilities.GetOraParam("P_DEP_ORG_ID", detail.DepOrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DES_ID", detail.DepDesID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CREATED_DATE", detail.DepCreatedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_ID", detail.DepPostID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_FROM_DATE", detail.DepFromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DECISION_DATE", detail.DepDecisionDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DEP_TO_ORG_ID", detail.DepToOrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_LEAVE_DATE", detail.DepLeaveDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_RESPONSIBILITY", detail.DepResponsibility, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_ENTRY_BY", detail.DepEntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); //detail.TippaniSNO = int.Parse(paramArray[2].Value.ToString()); paramArray.Clear(); } } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddPostingTippaniDetail ( List <ATTGeneralTippaniDetail> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniDetail detail in lst) { if (detail.Action != "N") { if (detail.Action == "A") { SP = "SP_ADD_POSTING_TIPPANI_DETAIL"; } else if (detail.Action == "E") { SP = "SP_EDIT_POSTING_TIPPANI_DETAIL"; } else if (detail.Action == "D") { SP = "sp_del_tippani_detail"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", detail.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); //paramArray.Add(Utilities.GetOraParam("P_TIPPANI_SNO", detail.TippaniSNO, OracleDbType.Int16, ParameterDirection.InputOutput)); if (detail.Action == "D") { paramArray.Add(Utilities.GetOraParam("P_EMP_ID", detail.EmpID, OracleDbType.Double, ParameterDirection.Input)); } else { paramArray.Add(Utilities.GetOraParam("P_POST_ORG_ID", detail.PostOrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_EMP_ID", detail.EmpID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DES_ID", detail.DesID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CREATED_DATE", detail.CreatedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_ID", detail.PostID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_FROM_DATE", detail.FromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_TO_DATE", detail.ToDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_JOINING_DATE", detail.JoiningDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DECISION_DATE", detail.DecisionDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_LEAVE_DATE", detail.LeaveDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POSTING_TYPE_ID", detail.PostingTypeID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POSTING_CLASS", "", OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_ENTRY_BY", detail.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_ENTRY_DATE", DateTime.Now, OracleDbType.Date, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); paramArray.Clear(); if (detail.Action == "D") { SP = "sp_reset_post_occupied_tippani"; paramArray.Add(Utilities.GetOraParam("P_ORG_ID", detail.PostOrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DES_ID", detail.DesID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CREATED_DATE", detail.CreatedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_POST_ID", detail.PostID, OracleDbType.Int32, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); paramArray.Clear(); } } } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddVisitTippaniDetail ( List <ATTGeneralTippaniDetail> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID ) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniDetail detail in lst) { if (detail.Action != "N") { if (detail.Action == "A") { SP = "SP_ADD_VISIT_TIPPANI_DETAIL"; } else if (detail.Action == "E") { SP = "SP_EDIT_VISIT_TIPPANI_DETAIL"; } else if (detail.Action == "D") { SP = "SP_del_tippani_detail"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", detail.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); //paramArray.Add(Utilities.GetOraParam("P_TIPPANI_SNO", detail.TippaniSNO, OracleDbType.Int16, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_EMP_ID", detail.EmpID, OracleDbType.Double, ParameterDirection.Input)); if (detail.Action != "D") { paramArray.Add(Utilities.GetOraParam("P_PURPOSE", detail.VisitPurpose, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_LOCATION", detail.VisitLocation, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_COUNTRY", detail.VisitCountryID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VISIT_FROM_DATE", detail.VisitFromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VISIT_TO_DATE", detail.VisitToDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VEHICLE", detail.VisitVehicle, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REMARKS", detail.VisitRemark, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VISIT_ENTRY_BY", detail.VisitEntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VISIT_ENTRY_DATE", detail.VisitEntryOn, OracleDbType.Date, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); //detail.TippaniSNO = int.Parse(paramArray[2].Value.ToString()); paramArray.Clear(); } } return(true); } catch (Exception ex) { throw ex; } }
public static bool AddAttachment(List <ATTGeneralTippaniAttachment> lst, object tran, int tippaniSubjectID, TippaniSubject subject, int tippaniID, int processID) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); try { foreach (ATTGeneralTippaniAttachment attachment in lst) { if (attachment.Action != "N") { if (attachment.Action == "A") { SP = "SP_ADD_TIPPANI_ATTACHMENT"; } else if (attachment.Action == "E") { SP = "SP_EDIT_TIPPANI_ATTACHMENT"; } else if (attachment.Action == "D") { SP = "SP_DEL_TIPPANI_ATTACHMENT"; } paramArray.Add(Utilities.GetOraParam("P_ORG_ID", attachment.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", tippaniID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_PROCESS_ID", processID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_ATTACHMENT_ID", attachment.AttachmentID, OracleDbType.Int16, ParameterDirection.InputOutput)); if (attachment.Action != "D") { paramArray.Add(Utilities.GetOraParam("P_DOC_NAME", attachment.DocumentName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DESCRIPTION", attachment.Description, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CONTENT", attachment.RawContent, OracleDbType.Blob, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_entry_by", attachment.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(tran as OracleTransaction, CommandType.StoredProcedure, SP, paramArray.ToArray()); attachment.AttachmentID = int.Parse(paramArray[3].Value.ToString()); paramArray.Clear(); } } return(true); } catch (Exception ex) { throw ex; } }