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