//for delete
public void BankBranchDelete(int BankBranchId)
{
BankBranches result = ent.BankBranches.Where(x => x.BankBranchId == BankBranchId).FirstOrDefault();
ent.DeleteObject(result);
ent.SaveChanges();
}
public async Task <int> UpdateBankBranch([FromBody] BankBranches bankBranches)
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(Params.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bankBranches.ID ?? DBNull.Value);
dyParam.Add(Params.PARAMETER_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)bankBranches.CODE ?? DBNull.Value, 100);
dyParam.Add(Params.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)bankBranches.NAME ?? DBNull.Value, 500);
dyParam.Add(Params.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)bankBranches.NAME2 ?? DBNull.Value, 500);
dyParam.Add(Params.PARAMETER_PHONE_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)bankBranches.PHONE_CODE ?? DBNull.Value, 50);
dyParam.Add(Params.PARAMETER_PHONE, OracleDbType.Varchar2, ParameterDirection.Input, (object)bankBranches.PHONE ?? DBNull.Value, 50);
dyParam.Add(Params.PARAMETER_BANK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bankBranches.ST_BNK_ID ?? DBNull.Value);
dyParam.Add(Params.PARAMETER_CITY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bankBranches.ST_CITY_ID ?? DBNull.Value);
dyParam.Add(Params.PARAMETER_COUNTRY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bankBranches.ST_CNT_ID ?? DBNull.Value);
int result = await _UpdateRepository.UpdateObjectAsync(SPName.SP_UPADTE_BANCK_BRANCH, dyParam);
if (result == -1)
{
return(Convert.ToInt32(HttpStatusCode.OK));
}
else
{
return(Convert.ToInt32(HttpStatusCode.NotModified));
}
}
public void DeleteBranch(int BankBranchId)
{
BankBranches model = ent.BankBranches.First(x => x.BankBranchId == BankBranchId);
ent.DeleteObject(model);
ent.SaveChanges();
}
public static BankBranches Clone(this BankBranches original)
{
BankBranches target = new BE.BankBranches();
target.BankNumber = original.BankNumber;
target.BankName = original.BankName;
target.BranchNumber = original.BranchNumber;
target.BranchAddress = original.BranchAddress;
target.BranchCity = original.BranchCity;
return(target);
}
public void BranchUpdate(BranchManagementsModel model)
{
BankBranches result = ent.BankBranches.Where(x => x.BankBranchId == model.BankBranchId).FirstOrDefault();
result.BranchAddress = model.BranchAddress;
result.BranchName = model.BranchName;
result.ContactPerson = model.BranchContactPerson;
result.PhoneNumber = model.BranchPhoneNumber;
result.ContactPersonPhoneNo = model.BranchContactPhoneNo;
result.ContactPersonEmail = model.BranchContactEmail;
result.CountryId = model.BranchCountryId;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
}
public BankManagementsModel BranchDetail(int?Id, out ActionResponse _ores)
{
if (Id != null)
{
BankBranches result = new BankBranches();
result = _ent.BankBranches.Where(x => x.BankBranchId == Id).FirstOrDefault();
if (result != null)
{
BankManagementsModel model = new BankManagementsModel
{
BranchName = result.BranchName,
BranchAddress = result.BranchAddress,
BranchContactPerson = result.ContactPerson,
BranchContactEmail = result.ContactPersonEmail,
BranchContactPhoneNo = result.ContactPersonPhoneNo,
BankName = result.Banks.BankName,
BranchPhoneNumber = result.PhoneNumber,
BranchCountryName = result.Countries.CountryName,
BranchCountryId = result.CountryId,
BankBranchId = result.BankBranchId,
BankId = result.BankId,
};
_ores = _res;
return(model);
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Branch");
_res.ErrNumber = 1005;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
_ores = _res;
return(_model);
}
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Branch");
_res.ErrNumber = 1005;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
_ores = _res;
return(_model);
}
}
public void CreateBranch(BranchManagementsModel model)
{
BankBranches obj = new BankBranches
{
BankId = model.BankId,
BranchName = model.BranchName,
BranchAddress = model.BranchAddress,
CountryId = model.BranchCountryId,
PhoneNumber = model.BranchPhoneNumber,
ContactPerson = model.BranchContactPerson,
ContactPersonPhoneNo = model.BranchContactPhoneNo,
ContactPersonEmail = model.BranchContactEmail,
};
ent.AddToBankBranches(obj);
ent.SaveChanges();
}
/// <summary>
/// converts bank to type of bank branches from xml
/// </summary>
/// <param name="element"></param>
/// <returns></returns>
BankBranches ConvertBank(XElement element)
{
try
{
BankBranches bank = new BankBranches();
bank.BankName = element.Element("שם_בנק").Value;
bank.BankNumber = int.Parse(element.Element("קוד_בנק").Value);
bank.BranchNumber = int.Parse(element.Element("קוד_סניף").Value);
bank.BranchAddress = element.Element("כתובת_ה-ATM").Value;
bank.BranchCity = element.Element("ישוב").Value;
return(bank);
}
catch (Exception e)
{
throw e;
}
}
public BankBranchModel BankBranchDetail(int BankBranchId)
{
BankBranches result = ent.BankBranches.Where(x => x.BankBranchId == BankBranchId).FirstOrDefault();
BankBranchModel model = new BankBranchModel();
model.BankBranchId = result.BankBranchId;
model.BankId = result.BankId;
model.BankName = result.Banks.BankName;
model.CountryId = result.CountryId;
model.Country = result.Countries.CountryName;
model.BranchName = result.BranchName;
model.BranchAddress = result.BranchAddress;
model.PhoneNo = result.PhoneNumber;
model.ContactPerson = result.ContactPerson;
model.ContactPersonPhoneNo = result.ContactPersonPhoneNo;
model.ContactPersonEmail = result.ContactPersonEmail;
return(model);
}
public BranchManagementsModel GetBranchDetails(int BankBranchId)
{
BankBranches result = new BankBranches();
result = ent.BankBranches.Where(x => x.BankBranchId == BankBranchId).FirstOrDefault();
BranchManagementsModel model = new BranchManagementsModel
{
BranchName = result.BranchName,
BranchAddress = result.BranchAddress,
BranchContactPerson = result.ContactPerson,
BranchContactEmail = result.ContactPersonEmail,
BranchContactPhoneNo = result.ContactPersonPhoneNo,
BranchPhoneNumber = result.PhoneNumber,
BranchCountryId = result.CountryId,
BankBranchId = result.BankBranchId,
BankId = result.BankId,
BankName = result.Banks.BankName
};
return(model);
}
public ActionResult GetName(string Bank_Code, string Bank_Branch_Code)
{
var user = UserManager.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
string SchemeName = PensionSetup.GetSchemeNameAsync(user.SponsorNumber);
if (String.IsNullOrEmpty(Bank_Branch_Code))
{
//Bank Code is not empty
Banks_Service service = new Banks_Service();
service.UseDefaultCredentials = false;
service.Credentials = new NetworkCredential(PensionSetup.SoapUsername, PensionSetup.SoapPassword);
service.Url = "http://" + PensionSetup.ServerName +
":" + PensionSetup.ServerPort +
"/" + PensionSetup.ServerInstance +
"/WS/" + SchemeName + "/Page/Banks";
Banks banks = service.Read(Bank_Code);
return(Json(banks.Name, JsonRequestBehavior.AllowGet));
}
else
{
//Bank Branch Code is not empty
BankBranches_Service serv = new BankBranches_Service();
serv.UseDefaultCredentials = false;
serv.Credentials = new NetworkCredential(PensionSetup.SoapUsername, PensionSetup.SoapPassword);
serv.Url = "http://" + PensionSetup.ServerName +
":" + PensionSetup.ServerPort +
"/" + PensionSetup.ServerInstance +
"/WS/" + SchemeName + "/Page/BankBranches";
BankBranches branches = serv.Read(Bank_Code, Bank_Branch_Code);
return(Json(branches.Branch_Name, JsonRequestBehavior.AllowGet));
}
}
