public static Pendtxn Read(string connectionString, string ref_no, Dber dberr)
{
try
{
var PendingTxnMasterObject = new Pendtxn();
var query = string.Format("select * from Pendtxn where ref_no = {0}", ref_no);
var data = DbAccess.ExecuteQuery(connectionString, CommandType.Text, query);
//assign the data object to Error master object
if (data.Tables[0].Rows.Count > 0)
{
PendingTxnMasterObject.init_empid = data.Tables[0].Rows[0]["init_empid"].ToString();
PendingTxnMasterObject.init_csno = data.Tables[0].Rows[0]["init_csno"].ToString();
PendingTxnMasterObject.ref_no = data.Tables[0].Rows[0]["ref_no"].ToString();
PendingTxnMasterObject.tran_date = data.Tables[0].Rows[0]["tran_date"].ToString();
PendingTxnMasterObject.tran_desc = data.Tables[0].Rows[0]["tran_desc"].ToString();
PendingTxnMasterObject.tran_pvgb = data.Tables[0].Rows[0]["tran_pvgb"].ToString();
PendingTxnMasterObject.ac_no = data.Tables[0].Rows[0]["ac_no"].ToString();
PendingTxnMasterObject.cr_amt = Convert.ToDecimal(data.Tables[0].Rows[0]["cr_amt"]);
PendingTxnMasterObject.dr_amt = Convert.ToDecimal(data.Tables[0].Rows[0]["dr_amt"]);
PendingTxnMasterObject.tran_data = data.Tables[0].Rows[0]["tran_data"].ToString();
return PendingTxnMasterObject;
}
else
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_PENDTXN_READ);
return null;
}
}
catch
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_PENDTXN_READ);
return null;
}
}
public static bool Update(string connectionString, Pendtxn dataObject)
{
throw new NotImplementedException();
}
public static int Create(string connectionString, Pendtxn dataObject, Data.Dber dberr)
{
try
{
var query = string.Format(@"INSERT INTO [SBS].[dbo].[PENDTXN]
(
[TRAN_DATE]
,[AC_NO]
, [AC_NO2]
,[TRAN_PVGB]
,[INIT_EMPID]
,[INIT_CSNO]
,[DR_AMT]
,[CR_AMT]
, [TRAN_ID]
, [TRAN_DESC]
, [TRAN_DATA])
OUTPUT INSERTED.REF_NO
VALUES
('{0}' ,{1}, {2}, '{3}' , {4} , {5} ,'{6}', '{7}', {8}, '{9}', '{10}')",
dataObject.tran_date,
dataObject.ac_no == "0" ? "null" : dataObject.ac_no,
dataObject.ac_no2 == "0" ? "null" : dataObject.ac_no2,
dataObject.tran_pvgb,
dataObject.init_empid == "0" ? "null" : dataObject.init_empid,
dataObject.init_csno == "0" ? "null" : dataObject.init_csno,
dataObject.dr_amt,
dataObject.cr_amt,
dataObject.tran_id ,
dataObject.tran_desc,
dataObject.tran_data);
return (int)DbAccess.ExecuteScalar(connectionString, CommandType.Text, query);
}
catch
{
dberr.setError(Mnemonics.DbErrorCodes.DBERR_PENDTXN_NOWRITE);
return -1;
}
}