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);
}
