public static bool SaveTamelildaarFeedBack(ATTTameli tameli)
{
string InsertUpdateSQL = "SP_SAVE_TAMELILDAAR_FEEDBACK";
List <OracleParameter> paramList = new List <OracleParameter>();
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
paramList.Add(Utilities.GetOraParam(":P_CASE_ID", tameli.CaseID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_LITIGANT_ID", tameli.LitigantID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ISSUE_DATE", tameli.IssuedDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_SEQ_NO", tameli.SeqNo, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_DATE", tameli.TameliDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_YES_NO", tameli.TameliYesNo, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_SEC_CLRK_RCVD_DATE", tameli.SecClrkRcvdDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMILDAAR_REMARKS", tameli.TamilDaarRemrks, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_STATUS_ID", (tameli.TameliStatusID > 0)?tameli.TameliStatusID:null, OracleDbType.Int64, ParameterDirection.Input));
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramList.ToArray());
DLLTameliWitnessPerson.AddEditDeleteTameliWitnessPerson(tameli.TameliWitnessPersonLIST, Tran);
paramList.Clear();
//}
Tran.Commit();
return(true);
}
catch (OracleException oex)
{
Tran.Rollback();
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
//Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
public static bool AddEditDeleteTameli(List <ATTTameli> TameliLIST)
{
string InsertUpdateSQL = "";
List <OracleParameter> paramList = new List <OracleParameter>();
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
foreach (ATTTameli tameli in TameliLIST)
{
if (tameli.Action == "A")
{
InsertUpdateSQL = "SP_ADD_TAMELI";
}
else if (tameli.Action == "E")
{
InsertUpdateSQL = "SP_EDIT_TAMELI";
}
else if (tameli.Action == "D")
{
InsertUpdateSQL = "SP_DEL_TAMELI";
}
if (tameli.Action == "A" || tameli.Action == "E")
{
paramList.Add(Utilities.GetOraParam(":P_CASE_ID", tameli.CaseID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_LITIGANT_ID", tameli.LitigantID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ISSUE_DATE", tameli.IssuedDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_SEQ_NO", tameli.SeqNo, OracleDbType.Int64, ParameterDirection.InputOutput));
paramList.Add(Utilities.GetOraParam(":P_WITNESS_ID", tameli.WitnessID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ATTORNEY_ID", tameli.AttorneyID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ISSUED_BY", tameli.IssuedBy, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_RECEIVED_DATE", tameli.ReceivedDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_RECEIVED_BY", tameli.ReceivedBy, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_DATE", tameli.TameliDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_YES_NO", tameli.TameliYesNo, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_SEC_CLRK_RCVD_DATE", tameli.SecClrkRcvdDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMILDAAR_REMARKS", tameli.TamilDaarRemrks, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_VERIFIED_DATE", tameli.VerifiedDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_VERIFIED_BY", tameli.VerifiedBy, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_VERIFIED_YES_NO", tameli.VerifiedYesNo, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_VERIFIED_REMARKS", tameli.VerifiedRemarks, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ATTEND_DAYS", tameli.AttendDays, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_MYAAD_TYPE_ID", tameli.MyaadTypeID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_TYPE_ID", tameli.TameliTypeID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_STATUS_ID", tameli.TameliStatusID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_TAMELI_ORG", tameli.TameliOrg, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ENTRY_BY", tameli.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_OLD_ISSUED_DATE", tameli.OldIssueDate, OracleDbType.Varchar2, ParameterDirection.Input));
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramList.ToArray());
tameli.SeqNo = int.Parse(paramList[3].Value.ToString());
//foreach (ATTTameliWitnessPerson TWP in tameli.TameliWitnessPersonLIST)
//{
// TWP.SeqNo = tameli.SeqNo;
// TWP.IssuedDate = tameli.IssuedDate;
//}
foreach (ATTTameliMedia TWP in tameli.TameliMediaLIST)
{
TWP.SeqNo = tameli.SeqNo;
TWP.IssueDate = tameli.IssuedDate;
}
// DLLTameliWitnessPerson.AddEditDeleteTameliWitnessPerson(tameli.TameliWitnessPersonLIST, Tran);
DLLTameliMedia.AddEditDeleteTameliMedia(tameli.TameliMediaLIST, Tran);
paramList.Clear();
}
if (tameli.Action == "D")
{
DLLTameliMedia.AddEditDeleteTameliMedia(tameli.TameliMediaLIST, Tran);
DLLTameliWitnessPerson.AddEditDeleteTameliWitnessPerson(tameli.TameliWitnessPersonLIST, Tran);
paramList.Add(Utilities.GetOraParam(":P_CASE_ID", tameli.CaseID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_LITIGANT_ID", tameli.LitigantID, OracleDbType.Int64, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_ISSUE_DATE", tameli.IssuedDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramList.Add(Utilities.GetOraParam(":P_SEQ_NO", tameli.SeqNo, OracleDbType.Int64, ParameterDirection.InputOutput));
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramList.ToArray());
paramList.Clear();
}
}
Tran.Commit();
return(true);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
