private static SetReconUpldObj addRecord(IList <string> rowData, IList <string> columnNames)
{
try
{
var obj = new SetReconUpldObj()
{
PAYREFNO = rowData[0].Trim(),
AMOUNT = rowData[1].ToDecimal(),
PAYMENTDATE = rowData[2].ToDateTime(),
VALUEDATE = rowData[3].ToDateTime(),
//RECEIPTNO = rowData[4].Trim(),
CUSTOMERNAME = rowData[4].Trim(),
PAYMENTMETHOD = rowData[5].Trim(),
//TRANSACTIONSTATUS = rowData[7].Trim(),
//DEPOSITSLIPNO = rowData[8].Trim(),
BANKNAME = rowData[6].Trim(),
//BRANCHNAME = rowData[10].Trim(),
//PAYERID = rowData[11].Trim(),
//VALUEGRANTED = rowData[12].Trim(),
//RECONCILE = rowData[13].ToInt32(),
VALIDATIONERRORSTATUS = true,
};
return(obj);
}
catch (Exception ex)
{
return(new SetReconUpldObj());
}
}
public int PostSetReconUpload(SetReconUpldObj obj, int postType, string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("@PID", obj.PID, DbType.String);
p.Add("@PAYREFNO", obj.PAYREFNO, DbType.String);
p.Add("@AMOUNT", obj.AMOUNT, DbType.Decimal);
p.Add("@PAYMENTDATE", obj.PAYMENTDATE, DbType.DateTime);
p.Add("@VALUEDATE", obj.VALUEDATE, DbType.DateTime);
//p.Add("@RECEIPTNO", obj.RECEIPTNO, DbType.String);
p.Add("@CUSTOMERNAME", obj.CUSTOMERNAME, DbType.String);
p.Add("@PAYMENTMETHOD", obj.PAYMENTMETHOD, DbType.String);
//p.Add("@TRANSACTIONSTATUS", obj.TRANSACTIONSTATUS, DbType.String);
//p.Add("@DEPOSITSLIPNO", obj.DEPOSITSLIPNO, DbType.String);
p.Add("@BANKNAME", obj.BANKNAME, DbType.String);
//p.Add("@BRANCHNAME", obj.BRANCHNAME, DbType.String);
//p.Add("@PAYERID", obj.PAYERID, DbType.String);
//p.Add("@VALUEGRANTED", obj.VALUEGRANTED, DbType.String);
// p.Add("@RECONCILE", obj.RECONCILE, DbType.Int32);
p.Add("@BATCHID", null, DbType.String);
p.Add("USERID", userId, DbType.String);
p.Add("@CREATEDATE", DateTime.Now, DbType.DateTime);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.String);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
p.Add("POSTSEQUENCE", obj.POSTSEQUENCE, DbType.Int32);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_SETRECON", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
