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); } }