public static int Create(string connectionString, Finhist dataObject, Dber dberr)
{
try
{
var query = string.Format(@"INSERT INTO [SBS].[dbo].[FINHIST]
([TRAN_DATE]
,[AC_NO]
,[TRAN_TIMESTAMP]
,[TRAN_DESC]
,[REM_BAL]
,[INIT_CSNO]
,[INIT_EMPID]
,[APPRV_EMPID]
,[DR_AMT]
,[CR_AMT])
OUTPUT INSERTED.REF_NO
VALUES
('{0}' ,'{1}','{2}' ,'{3}' ,'{4}' ,{5} ,{6} ,{7} ,'{8}' ,'{9}')",
dataObject.tran_date,dataObject.ac_no,dataObject.tran_timestamp,dataObject.tran_desc,dataObject.rem_bal,
dataObject.init_csno == "0" ? "null" : dataObject.init_csno,
dataObject.init_empid == "0" ? "null" : dataObject.init_empid,
dataObject.apprv_empid == "0" ? "null" : dataObject.apprv_empid,
dataObject.dr_amt,dataObject.cr_amt);
return (int)DbAccess.ExecuteScalar(connectionString, CommandType.Text, query);
}
catch (Exception ex)
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_FINHIST_CREATE);
return -1;
}
}
public static Finhist Read(string connectionString, string ref_no, Dber dberr)
{
try
{
var FinHistMasterObject = new Finhist();
var query = string.Format("select * from FinHist where ref_no = {0}", ref_no);
var data = DbAccess.ExecuteQuery(connectionString, CommandType.Text, query);
//assign the data object to ErrorHistry master object
if (data.Tables[0].Rows.Count > 0)
{
FinHistMasterObject.ref_no = data.Tables[0].Rows[0]["ref_no"].ToString();
FinHistMasterObject.init_empid = data.Tables[0].Rows[0]["init_empid"].ToString();
FinHistMasterObject.tran_date = data.Tables[0].Rows[0]["tran_date"].ToString();
FinHistMasterObject.tran_desc = data.Tables[0].Rows[0]["tran_desc"].ToString();
FinHistMasterObject.tran_timestamp = data.Tables[0].Rows[0]["tran_timestamp"].ToString();
FinHistMasterObject.rem_bal = data.Tables[0].Rows[0]["rem_bal"].ToString();
FinHistMasterObject.cr_amt = Convert.ToDecimal(data.Tables[0].Rows[0]["cr_amt"]);
FinHistMasterObject.dr_amt = Convert.ToDecimal(data.Tables[0].Rows[0]["dr_amt"]);
FinHistMasterObject.ac_no = data.Tables[0].Rows[0]["ac_no"].ToString();
FinHistMasterObject.apprv_empid = data.Tables[0].Rows[0]["apprv_empid"].ToString();
FinHistMasterObject.init_csno = data.Tables[0].Rows[0]["init_csno"].ToString();
return FinHistMasterObject;
}
else
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_FINHIST_READ);
return null;
}
}
catch (Exception ex)
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_FINHIST_READ);
return null;
}
}
private int processTransaction(String connectionString, Entity.Cstm cstm)
{
tx = new Cp_Txnm(connectionString, TXID, dberr);
// Check if TXNM fetch for transaction type "010" is successful. Return if error encountered
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
//if (!verifyInputType(1, cstm.cs_no))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSNO);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(2, cstm.cs_type))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSTYPE);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(2, cstm.cs_fname))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSFNAME);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(2, cstm.cs_mname))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSMNAME);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(2, cstm.cs_lname))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSLNAME);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_addr1))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSADDR1);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_addr2))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSADDR2);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_city))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSCITY);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(2, cstm.cs_state))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSSTATE);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(1, cstm.cs_zip))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSZIP);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(1, cstm.cs_branch))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSBRNCH);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(1, cstm.cs_phn))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSPHN);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_email))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSEMAIL);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(1, cstm.cs_uid))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSUID);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_secq1))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSSECQ1);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_ans1))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSANS1);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_secq2))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSSECQ2);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_ans2))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSANS2);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_secq3))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSSECQ3);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
//if (!verifyInputType(3, cstm.cs_ans3))
//{
// this.dberr.setError(Mnemonics.DbErrorCodes.TXERR_FMT_CUSANS3);
// result = dberr.getErrorDesc(connectionString);
// return -1;
//}
Data.CstmD.Update(connectionString, this.cstm, this.dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
if (tx.txnmP.tran_fin_type.Equals("Y"))
{
// Write to FINHIST table
Entity.Finhist fhist = new Entity.Finhist(this.cstm.cs_no, "0", this.tx.txnmP.tran_desc,
0, 0, "0", "0", "0", "0");
Data.FinhistD.Create(connectionString, fhist, dberr);
}
else
{
// Write to NFINHIST table
Entity.Nfinhist nFhist = new Entity.Nfinhist(this.cstm.cs_no, "0", this.tx.txnmP.tran_desc, "0", "0", this.cstm.cs_no);
Data.NfinhistD.Create(connectionString, nFhist, dberr);
}
//------------------------------
//Entity.Cstm cstm = Data.CstmD.Read(connectionString, acct.actmP.cs_no1, dberr);
if (dberr.ifError())
{
result = dberr.getErrorDesc(connectionString);
return -1;
}
String mailResponse = "";
if (!Security.OTPUtility.SendMail("SBS", "*****@*****.**", cstm.cs_fname + cstm.cs_mname + cstm.cs_lname,
cstm.cs_email, "Update from SBS: you profile has been updated via trnasaction: ", tx.txnmP.tran_desc))
{
mailResponse = "Mail sent.";
}
//-------------------------------
result = "Successful!" + mailResponse;
return 0;
}
public static bool Update(string connectionString, Finhist dataObject, Dber dberr)
{
throw new NotImplementedException();
}