public static List <ATTCaseAccount> GetCaseAccount(double caseID)
{
List <ATTCaseAccount> CaseAccountList = new List <ATTCaseAccount>();
try
{
foreach (DataRow row in DLLCaseAccount.GetCaseAccount(caseID).Rows)
{
ATTCaseAccount att = new ATTCaseAccount
(
int.Parse(row["CASE_ID"].ToString()),
int.Parse(row["ACCOUNT_TYPE_ID"].ToString()),
row["TRAN_DATE"].ToString(),
int.Parse(row["TRAN_AMOUNT"].ToString()),
row["REMARKS"].ToString()
);
att.AccountTypeName = row["ACCOUNT_TYPE_NAME"].ToString();
CaseAccountList.Add(att);
}
return(CaseAccountList);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveCaseAccount(ATTCaseAccount attCA)
{
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
//OracleConnection DBConn = GetConn.GetDbConn(Module.CMS);
string InsertUpdateSQL = "";
try
{
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_INVOICE_NO", attCA.InVoiceNumber, OracleDbType.Varchar2, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_CASE_ID", attCA.CaseID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACCOUNT_TYPE_ID", attCA.AccountTypeID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_TRAN_DATE", attCA.TransactionDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_TRAN_AMOUNT", attCA.TransactionAmount, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REMARKS", attCA.Remarks, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", attCA.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
//if (attCA.Action == "A")
InsertUpdateSQL = "SP_ADD_CASE_ACCOUNT";
// else
// InsertUpdateSQL = "SP_EDIT_CASE_ACCOUNT";
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
Tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveCaseAccount(ATTCaseAccount attCA)
{
try
{
return(DLLCaseAccount.SaveCaseAccount(attCA));
}
catch (Exception ex)
{
throw ex;
}
}
