public async Task <ActionResult> WebPukalSedutMaint(WebPukalSedutList pukalSedut)
{
decimal _PukalAmt = 0;
Decimal.TryParse(pukalSedut.PukalAmt, out _PukalAmt);
var ResultInfo = await objPukalAcctOps.SavePukalSedut(pukalSedut.AcctNo, _PukalAmt, BaseClass.GetClaimsInfo("userid"));
return(Json(new { result = ResultInfo }, JsonRequestBehavior.AllowGet));
}
public async Task <List <WebPukalSedutList> > GetPukalSedutList(string refCd, string AcctOfficeCd, string status)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
var webPukalSedutLst = new List <WebPukalSedutList>();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@RefCd", refCd);
Parameters[1] = new SqlParameter("@AcctOfficeCd", AcctOfficeCd);
Parameters[2] = new SqlParameter("@Sts", status);
var execResult = await objDataEngine.ExecuteCommandAsync("WebPukalSedutListSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var pukalSedut = new WebPukalSedutList();
pukalSedut.AcctNo = Convert.ToInt32(execResult["AcctNo"]);
pukalSedut.CompanyName = Convert.ToString(execResult["CmpyName1"]);
pukalSedut.ActivationDate = DateConverter(execResult["ActivationDate"]);
pukalSedut.TerminationDate = DateConverter(execResult["TerminationDate"]);
pukalSedut.PukalAmt = ConverterDecimal(execResult["PukalAmt"]);
pukalSedut.StmtDate = DateConverter(execResult["StmtDate"]);
pukalSedut.Status = Convert.ToString(execResult["Sts"]);
pukalSedut.UserId = Convert.ToString(execResult["UserId"]);
webPukalSedutLst.Add(pukalSedut);
}
return(webPukalSedutLst);
}
catch (Exception ex)
{
return(null);
throw ex;
}
finally
{
objDataEngine.CloseConnection();
}
}
