public async Task <ActionResult> reupload(AccountReuploadDocumentDTO reuploadDocument)
{
try
{
if (!ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, ConstantHelper.KEY_IN_REQUIRED_FIELD);
}
Response.StatusCode = 200;
var account = await handler.reupload(reuploadDocument, Request);
//return Json(id, JsonRequestBehavior.AllowGet);
Response.Write("ok");
return(null);
}
catch (Exception ex)
{
if (ex.Message == ConstantHelper.ALREADY_REQUEST_LOAN ||
ex.Message == ConstantHelper.KEY_IN_REQUIRED_FIELD ||
ex.Message == ConstantHelper.INVALID_PIN ||
ex.Message == ConstantHelper.PIN_EXPIRED)
{
Response.StatusCode = 400;
}
else
{
Response.StatusCode = 500;
}
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
/*
* public async Task<AccountViewDTO> reupload(int id, HttpRequestBase Request)
* {
* using (var transaction = db.Database.BeginTransaction())
* {
* try
* {
*
* List<sm_doc> documents = await DocumentHelper.SaveUploadFiles(db, ConstantHelper.TABLE_ACCOUNT_ID, id, Request);// tmp not useful , just reserve data for using in the furture
* return null;
* }
* catch (Exception ex)
* {
* transaction.Rollback();
* throw new Exception(ex.Message);
* }
* }
* }
*/
public async Task <AccountViewDTO> reupload(AccountReuploadDocumentDTO reuploadDoc, HttpRequestBase Request)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
List <sm_doc> documents = await DocumentHelper.SaveUploadFiles(db, ConstantHelper.TABLE_ACCOUNT_ID, reuploadDoc.id, Request);// tmp not useful , just reserve data for using in the furture
IQueryable <sm_doc> query = from d in db.sm_doc
where d.docs_Deleted == null && d.docs_TableID == ConstantHelper.TABLE_ACCOUNT_ID && d.docs_Value == reuploadDoc.id.ToString()
orderby d.docs_docID
select d;
List <sm_doc> records = await query.Take(3).ToListAsync();
int id = 0;
if (reuploadDoc.idCard_change == 1)
{
id = records[0].docs_docID;
var tmp = await db.sm_doc.FirstOrDefaultAsync(x => x.docs_Deleted == null && x.docs_docID == id);
tmp.docs_Deleted = "1";
await db.SaveChangesAsync();
}
if (reuploadDoc.employmentLetter_change == 1)
{
id = records[1].docs_docID;
var tmp = await db.sm_doc.FirstOrDefaultAsync(x => x.docs_Deleted == null && x.docs_docID == id);
tmp.docs_Deleted = "1";
await db.SaveChangesAsync();
}
if (reuploadDoc.bankAccount_change == 1)
{
id = records[2].docs_docID;
var tmp = await db.sm_doc.FirstOrDefaultAsync(x => x.docs_Deleted == null && x.docs_docID == id);
tmp.docs_Deleted = "1";
await db.SaveChangesAsync();
}
transaction.Commit();
return(null);
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
