public etblBankDetail GetBankDetailByPropId() { etblBankDetail objBank = new etblBankDetail(); try { objBank = BL_tblBankDetailM.GetSingleRecordById(Convert.ToInt32(Session["PropId"].ToString())); } catch (Exception) { throw; } return(objBank); }
//Get Single Record public static etblBankDetail GetSingleRecordById(int id) { etblBankDetail eobj = new etblBankDetail(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblBankDetailMs.SingleOrDefault(u => u.iPropId == id); if (dbobj != null) { eobj = (etblBankDetail)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj); } else { eobj.iPropId = id; } } return(eobj); }
//Add new record public static int AddRecord(etblBankDetail eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblBankDetailM dbuser = (OneFineRate.tblBankDetailM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblBankDetailM()); db.tblBankDetailMs.Add(dbuser); db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Add new record public static int AddOrUpdateRecord(etblBankDetail eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var existingRecord = db.tblBankDetailMs.Find(eobj.iPropId); if (existingRecord != null) { existingRecord.dCommission = eobj.dCommission; existingRecord.dtActionDate = eobj.dtActionDate; existingRecord.dtModifyDate = eobj.dtModifyDate; existingRecord.iActionBy = eobj.iActionBy;; existingRecord.iModifyBy = eobj.iModifyBy; existingRecord.sBaneficiariesName = eobj.sBaneficiariesName; existingRecord.sBankAccountNo = eobj.sBankAccountNo; existingRecord.sBankName = eobj.sBankName; existingRecord.sBranchAddress = eobj.sBranchAddress; existingRecord.sBranchName = eobj.sBranchName; existingRecord.sFEmailId = eobj.sFEmailId; existingRecord.sFFaxNo = eobj.sFFaxNo; existingRecord.sFName = eobj.sFName; existingRecord.sFPhoneNo = eobj.sFPhoneNo; existingRecord.sIfscCode = eobj.sIfscCode; existingRecord.sMicrCode = eobj.sMicrCode; existingRecord.sRegisteredEntityName = eobj.sRegisteredEntityName; existingRecord.sGstinNumber = eobj.sGstinNumber; existingRecord.iStateId = eobj.iStateId; existingRecord.sPanNumber = eobj.sPanNumber; existingRecord.sEntityType = eobj.sEntityType; //if (string.IsNullOrEmpty(existingRecord.sCancelledCheque) && !string.IsNullOrEmpty(eobj.sCancelledCheque)) //{ // existingRecord.sCancelledCheque = eobj.sCancelledCheque; //} //if (string.IsNullOrEmpty(existingRecord.sLetterhead_BankAccount) && !string.IsNullOrEmpty(eobj.sLetterhead_BankAccount)) //{ // existingRecord.sLetterhead_BankAccount = eobj.sLetterhead_BankAccount; //} //if (string.IsNullOrEmpty(existingRecord.sPanCard) && !string.IsNullOrEmpty(eobj.sPanCard)) //{ // existingRecord.sPanCard = eobj.sPanCard; //} if (!string.IsNullOrEmpty(eobj.sCancelledCheque)) { existingRecord.sCancelledCheque = eobj.sCancelledCheque; } if (!string.IsNullOrEmpty(eobj.sLetterhead_BankAccount)) { existingRecord.sLetterhead_BankAccount = eobj.sLetterhead_BankAccount; } if (!string.IsNullOrEmpty(eobj.sPanCard)) { existingRecord.sPanCard = eobj.sPanCard; } db.Entry(existingRecord).State = System.Data.Entity.EntityState.Detached; db.Entry(existingRecord).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 2; } else { retval = AddRecord(eobj); } } catch (DbEntityValidationException e) { string validationMessage = string.Empty; foreach (var eve in e.EntityValidationErrors) { foreach (var ve in eve.ValidationErrors) { validationMessage += ve.ErrorMessage; } } throw new DbEntityValidationException(validationMessage); } } return(retval); }
public ActionResult Add(etblBankDetail bank) { if (ModelState.IsValid) { try { bank.dtActionDate = DateTime.UtcNow; if (Session["UserDetails"] != null) { bank.iActionBy = Convert.ToInt16(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId); } var containerName = Convert.ToInt32(Session["PropId"].ToString()).ToString(); if (bank.CancelledCheque != null) { using (MemoryStream target = new MemoryStream()) { bank.CancelledCheque.InputStream.CopyTo(target); byte[] data = target.ToArray(); // Since old file will automatically replaced by new one (as their name is same ) , So no need to delete exiting one. var absoluteUrl = clsUtils.fnUploadFileINBlobStorage(containerName, "cancelledcheque" + Path.GetExtension(bank.CancelledCheque.FileName), data, false); bank.sCancelledCheque = containerName + "/cancelledcheque" + Path.GetExtension(bank.CancelledCheque.FileName); } } if (bank.PanCard != null) { using (MemoryStream target = new MemoryStream()) { bank.PanCard.InputStream.CopyTo(target); byte[] data = target.ToArray(); var absoluteUrl = clsUtils.fnUploadFileINBlobStorage(containerName, "pancard" + Path.GetExtension(bank.PanCard.FileName), data, false); bank.sPanCard = containerName + "/pancard" + Path.GetExtension(bank.PanCard.FileName); } } if (bank.Letterhead_BankAccount != null) { using (MemoryStream target = new MemoryStream()) { bank.Letterhead_BankAccount.InputStream.CopyTo(target); byte[] data = target.ToArray(); var absoluteUrl = clsUtils.fnUploadFileINBlobStorage(containerName, "letterheadbankaccount" + Path.GetExtension(bank.Letterhead_BankAccount.FileName), data, false); bank.sLetterhead_BankAccount = containerName + "/letterheadbankaccount" + Path.GetExtension(bank.Letterhead_BankAccount.FileName); } } var returnValue = BL_tblBankDetailM.AddOrUpdateRecord(bank); if (returnValue == 1) { TempData["msg"] = "Details has been added"; } else if (returnValue == 2) { TempData["msg"] = "Details has been modified"; } return(RedirectToAction("Index")); } catch (Exception ex) { TempData["ERROR"] = ex.Message; } } else { TempData["ERROR"] = "Validation failed ! Please correct the errors and try again."; } return(View("BankDetail", bank)); }