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 UpdateChannelPersonDecisionAndAddProcess(ATTGeneralTippaniProcess process, List <ATTGeneralTippaniProcess> lst, List <ATTGeneralTippaniAttachment> lstAttachment, TippaniSubject subject, List <ATTGeneralTippaniSummary> lstRec)
{
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)
{
if (lstRec.Count > 0)
{
DLLGeneralTippaniDetail.AddLeaveTippaniDetail(lstRec, Tran, (int)subject, subject, 0);
}
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray());
if (lst.Count > 0)
{
DLLGeneralTippaniProcess.AddGeneralTippaniProcessDetail(lst, Tran, (int)subject, subject, process.TippaniID);
}
if (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();
}
}