public Sys_Bank SetToModelObject(SysBank model, int userid, string url) { //const string chars = "AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz0123456789"; //var random = new Random(); //var result = new string( // Enumerable.Repeat(chars, 8) // .Select(s => s[random.Next(s.Length)]) // .ToArray()); Sys_Bank entity = new Sys_Bank(); entity.BankID = model.BankID; entity.BankCode = DalCommon.GetPreDefineNextCodeByUrl(url); entity.BankName = model.BankName; entity.BankCategory = model.BankCategory; entity.BankType = model.BankType; entity.BankBINNo = model.BankBINNo; entity.BankSwiftCode = model.BankSwiftCode; entity.IsActive = model.IsActive == "Active"; entity.SetOn = model.BankID == 0 ? DateTime.Now : _context.Sys_Bank.FirstOrDefault(ob => ob.BankID == model.BankID).SetOn; entity.SetBy = model.BankID == 0 ? userid : _context.Sys_Bank.FirstOrDefault(ob => ob.BankID == model.BankID).SetBy; entity.ModifiedOn = model.BankID == 0 ? (DateTime?)null : DateTime.Now; entity.ModifiedBy = model.BankID == 0 ? (int?)null : userid; entity.IPAddress = string.Empty; return(entity); }
public ValidationMsg Delete(string bankID) { try { using (var tx = new TransactionScope()) { Sys_Bank delete = repository.BankRepository.GetByID(Convert.ToInt32(bankID)); if (delete != null) { var deleteBranch = repository.BranchRepository.Get().Where(ob => ob.BankID == delete.BankID).ToList(); foreach (var item in deleteBranch) { Sys_Branch deleteBranchItem = repository.BranchRepository.GetByID(Convert.ToInt32(item.BranchID)); repository.BranchRepository.Delete(deleteBranchItem); save = repository.Save(); } repository.BankRepository.Delete(delete); save = repository.Save(); } tx.Complete(); vmMsg.Type = Enums.MessageType.Delete; vmMsg.Msg = "Deleted Sucessfully"; } } catch { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to delete."; } return(vmMsg); }
public ValidationMsg Save(SysBank model, int _userid, string pageUrl)//, string pageUrl { vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { model.BankCode = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045"); if (model.BankCode != null) { Sys_Bank tblBank = SetToBankModelObject(model, _userid);//, _userid _context.Sys_Bank.Add(tblBank); _context.SaveChanges(); if (model.Branches.Count > 0) { foreach (var branch in model.Branches) { branch.BankID = tblBank.BankID; Sys_Branch tblBranch = SetToBranchModelObject(branch, _userid); _context.Sys_Branch.Add(tblBranch); _context.SaveChanges(); } } _context.SaveChanges(); tx.Complete(); //BankID = tblBank.BankID; vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Saved Successfully."; } } } } catch (DbEntityValidationException e) { StringBuilder sb = new StringBuilder(); foreach (var eve in e.EntityValidationErrors) { sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } throw new DbEntityValidationException(sb.ToString(), e); } return(vmMsg); }
public ValidationMsg Save(SysBank model, int userid, string url) { vmMsg = new ValidationMsg(); try { #region Save using (var tx = new TransactionScope()) { using (_context) { #region Bank Sys_Bank tblSysBank = SetToModelObject(model, userid, url); _context.Sys_Bank.Add(tblSysBank); _context.SaveChanges(); #endregion #region Branches if (model.Branches != null) { foreach (var branch in model.Branches) { branch.BankID = tblSysBank.BankID; _context.Sys_Branch.Add(BranchModelConversion(branch, tblSysBank.BankID)); _context.SaveChanges(); } } #endregion _context.SaveChanges(); tx.Complete(); BankID = tblSysBank.BankID; vmMsg.ReturnId = tblSysBank.BankID; vmMsg.ReturnCode = tblSysBank.BankCode; vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Saved Successfully."; } } #endregion } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to save."; } return(vmMsg); }
public Sys_Bank SetToBankModelObject(SysBank model, int _userid)//int _userid { Sys_Bank entity = new Sys_Bank(); entity.BankID = model.BankID; entity.BankCode = model.BankCode; entity.BankName = model.BankName; entity.BankCategory = model.BankCategory; entity.BankType = model.BankType; entity.IsActive = model.IsActive == "Active"; entity.SetOn = DateTime.Now; entity.SetBy = _userid; entity.IPAddress = GetIPAddress.LocalIPAddress(); return(entity); }
public ValidationMsg Update(SysBank model, int _userid) { vmMsg = new ValidationMsg(); try { #region Update using (var tx = new TransactionScope()) { using (_context) { #region Crust Leather Transfer Sys_Bank bank = SetToBankModelObject(model, _userid); var OriginalEntity = _context.Sys_Bank.First(m => m.BankID == model.BankID); OriginalEntity.BankCode = bank.BankCode; OriginalEntity.BankName = bank.BankName; OriginalEntity.BankCategory = bank.BankCategory; OriginalEntity.BankType = bank.BankType; OriginalEntity.IsActive = bank.IsActive; OriginalEntity.ModifiedOn = DateTime.Now; OriginalEntity.ModifiedBy = _userid; _context.SaveChanges(); #endregion #region Save NEW Data & Update Existing Crust Leather Transfer Data if (model.Branches != null) { foreach (SysBranch branch in model.Branches) { branch.BankID = model.BankID; if (branch.BranchID == 0) { branch.BankID = bank.BankID; Sys_Branch tblBranch = SetToBranchModelObject(branch, _userid); _context.Sys_Branch.Add(tblBranch); //INV_CLTransferTo tblQCSelection = SetToCLTransferToModelObject(objCLTransferToItem, userid); //_context.INV_CLTransferTo.Add(tblQCSelection); } else { Sys_Branch branchEntity = SetToBranchModelObject(branch, _userid); var OriginalIssueItemEntity = _context.Sys_Branch.First(m => m.BranchID == branch.BranchID); OriginalIssueItemEntity.BranchID = branchEntity.BranchID; OriginalIssueItemEntity.BankID = branchEntity.BankID; OriginalIssueItemEntity.BanchCode = branchEntity.BanchCode; OriginalIssueItemEntity.BranchName = branchEntity.BranchName; OriginalIssueItemEntity.Address1 = branchEntity.Address1; OriginalIssueItemEntity.Address2 = branchEntity.Address2; OriginalIssueItemEntity.Address3 = branchEntity.Address3; OriginalIssueItemEntity.LCBalance = branchEntity.LCBalance; // OriginalIssueItemEntity.IsActive = branchEntity.IsActive == "Active"; OriginalIssueItemEntity.SetOn = branchEntity.SetOn; OriginalIssueItemEntity.SetBy = branchEntity.SetBy; OriginalIssueItemEntity.ModifiedBy = _userid; OriginalIssueItemEntity.ModifiedOn = DateTime.Now; OriginalIssueItemEntity.IPAddress = GetIPAddress.LocalIPAddress(); OriginalIssueItemEntity.SetOn = DateTime.Now; OriginalIssueItemEntity.SetBy = _userid; } } } #endregion _context.SaveChanges(); tx.Complete(); BankID = model.BankID; //CLTransferNo = model.CLTransferNo; vmMsg.Type = Enums.MessageType.Update; vmMsg.Msg = "Updated Successfully."; } } #endregion } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to Update."; } return(vmMsg); }