public ValidationMsg Save(SysBranch model, int userid)
{
var vmMsg = new ValidationMsg();
try
{
Sys_Branch tblSysBranch = SetToModelObject(model, userid);
_context.Sys_Branch.Add(tblSysBranch);
_context.SaveChanges();
BranchID = tblSysBranch.BranchID;
vmMsg.Type = Enums.MessageType.Success;
vmMsg.Msg = "Saved Successfully.";
}
catch (Exception ex)
{
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Banch Code Already Exit..";
}
else
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Save.";
}
}
return(vmMsg);
}
public Sys_Branch BranchModelConversion(SysBranch model, int bankId)
{
var entity = new Sys_Branch();
entity.BranchID = model.BranchID;
entity.BankID = bankId;
entity.BankID = model.BankID;// bankId;
entity.BanchCode = model.BanchCode;
entity.BranchName = model.BranchName;
entity.Address1 = model.Address1;
entity.Address2 = model.Address2;
entity.Address3 = model.Address3;
entity.LCLimit = model.LCLimit;
entity.LCOpened = model.LCOpened;
entity.LCBalance = model.LCBalance;
entity.LCMargin = model.LCMargin;
entity.LCMarginUsed = model.LCMarginUsed;
entity.LCMarginBalance = model.LCMarginBalance;
entity.BranchSwiftCode = model.BranchSwiftCode;
entity.LIMLimit = model.LIMLimit;
entity.LIMTaken = model.LIMTaken;
entity.LIMBalance = model.LIMBalance;
entity.IsActive = model.IsActive == "Active";
return(entity);
}
public Sys_Branch SetToModelObject(SysBranch model, int userid)
{
Sys_Branch entity = new Sys_Branch();
entity.BranchID = model.BranchID;
entity.BanchCode = model.BanchCode;
entity.BranchName = model.BranchName;
entity.BankID = model.BankID;
entity.LCLimit = model.LCLimit;
entity.LCOpened = model.LCOpened;
entity.LCBalance = model.LCBalance;
entity.LCMargin = model.LCMargin;
entity.LCMarginUsed = model.LCMarginUsed;
entity.LCMarginBalance = model.LCMarginBalance;
entity.BranchSwiftCode = model.BranchSwiftCode;
entity.LIMLimit = model.LIMLimit;
entity.LIMTaken = model.LIMTaken;
entity.LIMBalance = model.LIMBalance;
entity.Address1 = model.Address1;
entity.Address2 = model.Address2;
entity.Address3 = model.Address3;
entity.IsActive = model.IsActive == "Active";
entity.SetOn = DateTime.Now;
entity.SetBy = userid;
entity.IPAddress = string.Empty;
return(entity);
}
public ActionResult Branch(SysBranch model)
{
if (model != null && model.BranchID != 0)
{
_vmMsg = _dalSysBranch.Update(model, Convert.ToInt32(Session["UserID"]));
}
else
{
_vmMsg = _dalSysBranch.Save(model, Convert.ToInt32(Session["UserID"]));
}
return(Json(new { BranchID = _dalSysBranch.GetBranchID(), msg = _vmMsg }));
}
public ValidationMsg Update(SysBranch model, int userid)
{
var vmMsg = new ValidationMsg();
try
{
var sysBranch = _context.Sys_Branch.FirstOrDefault(s => s.BranchID == model.BranchID);
if (sysBranch != null)
{
sysBranch.BanchCode = model.BanchCode;
sysBranch.BranchName = model.BranchName;
sysBranch.BankID = model.BankID;
sysBranch.LCLimit = model.LCLimit;
sysBranch.LCOpened = model.LCOpened;
sysBranch.LCBalance = model.LCBalance;
sysBranch.LCMargin = model.LCMargin;
sysBranch.LCMarginUsed = model.LCMarginUsed;
sysBranch.LCMarginBalance = model.LCMarginBalance;
sysBranch.BranchSwiftCode = model.BranchSwiftCode;
sysBranch.LIMLimit = model.LIMLimit;
sysBranch.LIMTaken = model.LIMTaken;
sysBranch.LIMBalance = model.LIMBalance;
sysBranch.Address1 = model.Address1;
sysBranch.Address2 = model.Address2;
sysBranch.Address3 = model.Address3;
sysBranch.IsActive = model.IsActive == "Active";
sysBranch.ModifiedOn = DateTime.Now;
sysBranch.ModifiedBy = userid;
}
_context.SaveChanges();
vmMsg.Type = Enums.MessageType.Update;
vmMsg.Msg = "Updated Successfully.";
}
catch (Exception ex)
{
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Banch Code Already Exit.";
}
else
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Update.";
}
}
return(vmMsg);
}
public Sys_Branch SetToBranchModelObject(SysBranch model, int _userid)
{
Sys_Branch entity = new Sys_Branch();
entity.BranchID = model.BranchID;
entity.BankID = model.BankID;
entity.BanchCode = model.BanchCode;
entity.BranchName = model.BranchName;
entity.Address1 = model.Address1;
entity.Address2 = model.Address2;
entity.Address3 = model.Address3;
entity.LCBalance = model.LCBalance;
entity.IsActive = model.IsActive == "Active";
return(entity);
}
public ActionResult GetAllBranches()
{
var branches = _unit.BranchRepository.Get().Where(ob => ob.IsActive == true).ToList();
var result = new List <SysBranch>();
foreach (var branch in branches)
{
var x = new SysBranch();
x.BranchID = branch.BranchID;
x.BanchCode = branch.BanchCode;
x.BranchName = branch.BranchName;
x.Address1 = branch.Address1;
x.Address2 = branch.Address2;
x.Address3 = branch.Address3;
result.Add(x);
}
return(Json(result.OrderBy(ob => ob.BranchName), JsonRequestBehavior.AllowGet));
}
