public async Task <ActionResult> BankDetails(TBL_SETTINGS_BANK_DETAILS objval) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { var checkbankinfo = await db.TBL_SETTINGS_BANK_DETAILS.Where(x => x.SL_NO == objval.SL_NO).FirstOrDefaultAsync(); if (checkbankinfo == null) { objval.CREATED_DATE = DateTime.Now; //objval.CREATED_BY = long.Parse(Session["UserId"].ToString()); objval.CREATED_BY = MemberCurrentUser.MEM_ID; // For pawer admin created by vakue is 0 after that if admin logged in then create bank then created by id values is goes to admin id objval.CREATED_BY = 0; //long memid = long.Parse(objval.UserName); objval.MEM_ID = MemberCurrentUser.MEM_ID; objval.ISDELETED = 0; objval.CREATED_BY = MemberCurrentUser.MEM_ID; db.TBL_SETTINGS_BANK_DETAILS.Add(objval); await db.SaveChangesAsync(); //return RedirectToAction("Index"); } else { checkbankinfo.MEM_ID = MemberCurrentUser.MEM_ID; checkbankinfo.BANK = objval.BANK; checkbankinfo.IFSC = objval.IFSC; checkbankinfo.MICR_CODE = objval.MICR_CODE; checkbankinfo.CITY = objval.CITY; checkbankinfo.BRANCH = objval.BRANCH; checkbankinfo.CONTACT = objval.CONTACT; checkbankinfo.STATE = objval.STATE; checkbankinfo.ADDRESS = objval.ADDRESS; checkbankinfo.DISTRICT = objval.DISTRICT; db.Entry(checkbankinfo).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); //return RedirectToAction("Index"); } ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- MemberBankDetails(Admin), method:- BankDetails (POST) Line No:- 224", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); throw ex; } } }
public async Task <ActionResult> BankDetails(TBL_SETTINGS_BANK_DETAILS objval) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { var checkbankinfo = await db.TBL_SETTINGS_BANK_DETAILS.Where(x => x.SL_NO == objval.SL_NO).FirstOrDefaultAsync(); if (checkbankinfo == null) { objval.CREATED_DATE = DateTime.Now; objval.CREATED_BY = CurrentUser.USER_ID; objval.CREATED_BY = 0; objval.MEM_ID = 0; objval.ISDELETED = 0; //objval.STATE = objval.STATENAME; db.TBL_SETTINGS_BANK_DETAILS.Add(objval); await db.SaveChangesAsync(); //return RedirectToAction("Index"); } else { checkbankinfo.MEM_ID = 0; checkbankinfo.BANK = objval.BANK; checkbankinfo.ACCOUNT_HOLDERNAME = objval.ACCOUNT_HOLDERNAME; checkbankinfo.IFSC = objval.IFSC; checkbankinfo.MICR_CODE = objval.MICR_CODE; checkbankinfo.CITY = objval.CITY; checkbankinfo.BRANCH = objval.BRANCH; checkbankinfo.CONTACT = objval.CONTACT; checkbankinfo.STATE = objval.STATE; //checkbankinfo.STATE = objval.STATENAME; checkbankinfo.ADDRESS = objval.ADDRESS; checkbankinfo.DISTRICT = objval.DISTRICT; checkbankinfo.ACCOUNT_NO = objval.ACCOUNT_NO; db.Entry(checkbankinfo).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); //return RedirectToAction("Index"); } ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- PowerAdminBankDetails(PowerAdmin), method:- BankDetails (POST) Line No:- 212", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); throw ex; } } }
public ActionResult BankDetails(TBL_SETTINGS_BANK_DETAILS objval) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { var checkbankinfo = db.TBL_SETTINGS_BANK_DETAILS.Where(x => x.SL_NO == objval.SL_NO).FirstOrDefault(); if (checkbankinfo == null) { objval.CREATED_DATE = DateTime.Now; objval.CREATED_BY = CurrentUser.USER_ID; objval.CREATED_BY = 0; objval.MEM_ID = 0; objval.ISDELETED = 0; db.TBL_SETTINGS_BANK_DETAILS.Add(objval); db.SaveChanges(); //return RedirectToAction("Index"); } else { checkbankinfo.MEM_ID = 0; checkbankinfo.BANK = objval.BANK; checkbankinfo.IFSC = objval.IFSC; checkbankinfo.MICR_CODE = objval.MICR_CODE; checkbankinfo.CITY = objval.CITY; checkbankinfo.BRANCH = objval.BRANCH; checkbankinfo.CONTACT = objval.CONTACT; checkbankinfo.STATE = objval.STATE; checkbankinfo.ADDRESS = objval.ADDRESS; checkbankinfo.DISTRICT = objval.DISTRICT; checkbankinfo.ACCOUNT_NO = objval.ACCOUNT_NO; db.Entry(checkbankinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //return RedirectToAction("Index"); } ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); throw ex; } } }