public AdministrationController() { addressBO = new AddressBO(SESSIONOBJ); companyBO = new CompanyBO(SESSIONOBJ); branchBO = new BranchBO(SESSIONOBJ); contributionBO = new ContributionBO(SESSIONOBJ); }
public ActionResult BranchProfile(string companyCode, string branchCode) { var branchprofile = new Branch(); if (branchCode != "NEW") { branchprofile = new BranchBO().GetBranch(new Branch { BranchCode = branchCode }); } if (branchprofile == null || branchCode == "NEW") { branchprofile = new Branch(); branchprofile.BranchID = -1; branchprofile.CompanyCode = companyCode; } branchprofile.CountryList = new CountryBO().GetList().Select(c => new SelectListItem { Value = c.CountryCode, Text = c.CountryName }); return(View("BranchProfile", branchprofile)); }
/// <summary> /// To update branch details to database /// </summary> /// <param name="objBranchBO"></param> /// <returns></returns> public string UpdateBranch(BranchBO objBranchBO) { cnn = new OracleConnection(con); string returnResult = string.Empty; proc = "USP_MST_UPD_BANKBRANCHES"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("bankBranchID_", objBranchBO.BankBranchId); cmd.Parameters.Add("bankID_", objBranchBO.BankID); cmd.Parameters.Add("branchName_", objBranchBO.BranchName); cmd.Parameters.Add("city_", objBranchBO.City); cmd.Parameters.Add("swiftCode_", objBranchBO.SwiftCode); cmd.Parameters.Add("BANKCODE_", objBranchBO.BANKCODE); cmd.Parameters.Add("updatedby_", objBranchBO.UpdatedBy); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { returnResult = cmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } cmd.Connection.Close(); return(returnResult); }
public JsonResult GetCurrency(Int16 Id) { var country = new BranchBO().GetList().Where(x => x.IsActive == true && x.BranchID == Id).FirstOrDefault(); var currencyCode = new LookupBO().GetList().Where(x => x.LookupCategory == "Currency" && x.MappingCode == country.BranchCode).FirstOrDefault(); return(Json(currencyCode == null ? "" : currencyCode.LookupCode, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { LoginViewModel model = new LoginViewModel(); //var compist = new CompanyBO().GetList(); //for(var i = 0;i < compist.Count;i++) //{ // compist[i].CompanyCode = UrlEncryptionHelper.Encrypt(compist[i].CompanyCode); //} //model.CompaniesList = new SelectList(compist, "CompanyCode", "CompanyName"); var companyCode = "EZY"; var branchList = new BranchBO().GetList().Where(x => x.CompanyCode == companyCode).ToList(); model.BranchList = new SelectList(branchList, "BranchID", "BranchName").ToList(); var compist = new CompanyBO().GetList(); for (var i = 0; i < compist.Count; i++) { compist[i].CompanyCode = UrlEncryptionHelper.Encrypt(compist[i].CompanyCode); } model.CompanyCode = "EZY"; model.CompaniesList = new SelectList(compist, "CompanyCode", "CompanyName"); return(View(model)); }
public ActionResult DeleteBranch(short BranchID) { var result = new BranchBO().DeleteBranch(new Branch { BranchID = BranchID }); return(RedirectToAction("CompanyProfile")); }
/// <summary> /// To get branch by ID /// </summary> /// <param name="BankBranchId"></param> /// <returns></returns> public BranchBO GetBranchByID(int BankBranchId) { proc = "USP_MST_GET_BRANCHESBYID"; cnn = new OracleConnection(con); BranchBO objBranchBO = null; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("BankBranchId_", BankBranchId); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objBranchBO = new BranchBO(); if (!dr.IsDBNull(dr.GetOrdinal("BRANCHID"))) { objBranchBO.BankBranchId = dr.GetInt32(dr.GetOrdinal("BRANCHID")); } if (!dr.IsDBNull(dr.GetOrdinal("BANKID"))) { objBranchBO.BankID = dr.GetInt32(dr.GetOrdinal("BANKID")); } if (!dr.IsDBNull(dr.GetOrdinal("CITY"))) { objBranchBO.City = dr.GetString(dr.GetOrdinal("CITY")); } if (!dr.IsDBNull(dr.GetOrdinal("BRANCHNAME"))) { objBranchBO.BranchName = dr.GetString(dr.GetOrdinal("BRANCHNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("SWIFTCODE"))) { objBranchBO.SwiftCode = dr.GetString(dr.GetOrdinal("SWIFTCODE")); } if (!dr.IsDBNull(dr.GetOrdinal("BANKCODE"))) { objBranchBO.BANKCODE = dr.GetString(dr.GetOrdinal("BANKCODE")); } } dr.Close(); } catch (Exception ex) { throw ex; } return(objBranchBO); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid() { BranchBO objBranchBO = new BranchBO(); BranchBLL objBranchBLL = new BranchBLL(); int bankID = Convert.ToInt32(ViewState["BANK_ID"]); grdBankBranchs.DataSource = objBranchBLL.GetAllBranches(bankID); grdBankBranchs.DataBind(); }
public void AddBranch(int organisationId, BranchBO branch) { _unitOfWork.BranchTable.AddSingle(new BrancheDetail { Code = branch.Code, Name = branch.Name, OrganisationDetailsId = organisationId }); _unitOfWork.Commit(); }
public void UpdateBranch(BranchBO branch) { var branchDetails = new BrancheDetail { Name = branch.Name, Code = branch.Code }; _unitOfWork.BranchTable.UpdateSingle(branch.Id, branchDetails); _unitOfWork.Commit(); }
public ActionResult SaveBranchProfile(Branch branch) { branch.CreatedBy = USER_ID; branch.ModifiedBy = USER_ID; branch.IsActive = true; if (branch.BranchAddress.AddressId == 0) { branch.BranchAddress.AddressType = "Branch"; branch.BranchAddress.SeqNo = 1; branch.BranchAddress.IsActive = true; branch.BranchAddress.AddressLinkID = branch.BranchCode; } var result = new BranchBO().SaveBranch(branch); var encryptedStr = UrlEncryptionHelper.Encrypt(string.Format("companyCode={0}?branchCode={1}", branch.CompanyCode, branch.BranchCode)); return(RedirectToAction("BranchProfile", "Company", new { q = encryptedStr })); }
public PartialViewResult Course(int?Id) { ViewData["ProductData"] = new EduProductBO().GetList(); ViewData["CountryData"] = new BranchBO().GetList(); if (!Id.HasValue) { ViewBag.Title = "New Course"; return(PartialView(new Course { Id = -1, IsActive = true })); } else { ViewBag.Title = "Update Course"; return(PartialView(new CourseBO().GetCourse(new Course { Id = Id.Value }))); } }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { BranchBO objBranchBO = new BranchBO(); objBranchBO.BankBranchId = Convert.ToInt32(ViewState["BankBranchId"]); objBranchBO.BankID = Convert.ToInt32(ViewState["BANK_ID"]); objBranchBO.BranchName = txtBranchName0.Text.Trim(); objBranchBO.City = txtCity0.Text.Trim(); objBranchBO.SwiftCode = txtSwiftCode.Text.Trim(); objBranchBO.BANKCODE = txtBankCode.Text.Trim(); BranchBLL objBranchBLL = new BranchBLL(); string AlertMessage = string.Empty; string message = string.Empty; if (objBranchBO.BankBranchId == 0) { objBranchBO.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = objBranchBLL.AddBranch(objBranchBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearDetails(); } } else { objBranchBO.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); message = objBranchBLL.UpdateBranch(objBranchBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearDetails(); } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); BindGrid(); }
/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdBankBranchs_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["BankBranchId"] = e.CommandArgument; BranchBO objBranchBO = new BranchBO(); BranchBLL objBranchBLL = new BranchBLL(); objBranchBO = objBranchBLL.GetBranchById(Convert.ToInt32(ViewState["BankBranchId"])); if (objBranchBO != null) { ViewState["BankBranchId"] = objBranchBO.BankBranchId; txtBranchName0.Text = objBranchBO.BranchName; txtCity0.Text = objBranchBO.City; txtSwiftCode.Text = objBranchBO.SwiftCode; txtBankCode.Text = objBranchBO.BANKCODE; } SetUpdateMode(true); } else if (e.CommandName == "DeleteRow") { string message = string.Empty; int Branch = Convert.ToInt32(e.CommandArgument); BranchBLL objBranchBLL = new BranchBLL(); message = objBranchBLL.DeleteBranch(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { ClearDetails(); } message = "Data deleted successfully"; if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(); } }
// GET: api/Branch public List <BranchBO> Get() { using (HREntities db = new HREntities()) { var allBranches = new List <Branches>(); allBranches = db.Branches.ToList(); var branchList = new List <BranchBO>(); foreach (var branch in allBranches) { var br = new BranchBO(); br.branchId = branch.BranchID; br.branch = branch.BranchName; br.address = branch.Address; br.city = branch.City; br.postal = branch.PostalCode; br.telephone = branch.Telephone; branchList.Add(br); } return(branchList); } }
private List <Revenue> GetList(short country, int year) { List <Revenue> RevenueList = dbContext.Revenues.Where(x => x.IsActive == true && x.Country == country && x.Year == year).ToList(); var productList = new EduProductBO().GetList().Where(x => x.IsActive == true).ToList(); ViewData["CountryData"] = new BranchBO().GetList().Where(x => x.IsActive == true).ToList(); ViewData["CurrencyList"] = new LookupBO().GetList().Where(x => x.LookupCategory == "Currency").ToList(); var countryrow = ((List <Branch>)ViewData["CountryData"]).Where(x => x.IsActive == true && x.BranchID == country).FirstOrDefault(); var currencyCode = ((List <Lookup>)ViewData["CurrencyList"]).Where(x => x.LookupCategory == "Currency" && x.MappingCode == countryrow.BranchCode).FirstOrDefault(); foreach (EduProduct ep in productList) { if (RevenueList.Where(x => x.Product == ep.Id).Count() == 0) { RevenueList.Add(new Revenue() { Product = ep.Id, ProductName = ep.ProductName, RevenueId = -1, CurrencyCode = currencyCode == null ? "" : currencyCode.LookupCode }); } } return(RevenueList); }
/// <summary> /// To Get Active Branches from database /// </summary> /// <param name="bankID"></param> /// <returns></returns> public BankBranchList GetActiveBranches(int bankID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_BRANCHES"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("bankID_", Convert.ToInt32(bankID)); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); BranchBO objBranchBO = null; BankBranchList objBranchList = new BankBranchList(); while (dr.Read()) { objBranchBO = new BranchBO(); if (!dr.IsDBNull(dr.GetOrdinal("BRANCHID"))) { objBranchBO.BankBranchId = dr.GetInt32(dr.GetOrdinal("BRANCHID")); } if (!dr.IsDBNull(dr.GetOrdinal("BRANCHNAME"))) { objBranchBO.BranchName = dr.GetString(dr.GetOrdinal("BRANCHNAME")); } objBranchList.Add(objBranchBO); } dr.Close(); return(objBranchList); }
// GET: api/Branch/5 public object Get(int id) { using (HREntities db = new HREntities()) { var allBranches = new List <Branches>(); allBranches = db.Branches.ToList(); Branches branch = allBranches.Where(x => x.BranchID == id).FirstOrDefault(); if (branch == null) { return(NotFound()); } var br = new BranchBO(); br.branchId = branch.BranchID; br.branch = branch.BranchName; br.address = branch.Address; br.city = branch.City; br.postal = branch.PostalCode; br.telephone = branch.Telephone; return(br); } }
/// <summary> /// To get all branches from database /// </summary> /// <param name="bankID"></param> /// <returns></returns> public BankBranchList GetAllBranches(int bankID) { proc = "USP_MST_GET_ALLBRANCHES"; BranchBO objBranchBO = null; BankBranchList objBranchList = new BankBranchList(); using (cnn = new OracleConnection(con)) { using (cmd = new OracleCommand(proc, cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("bankID_", bankID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objBranchBO = new BranchBO(); if (!dr.IsDBNull(dr.GetOrdinal("BANKID"))) { objBranchBO.BankID = dr.GetInt32(dr.GetOrdinal("bankID")); } if (!dr.IsDBNull(dr.GetOrdinal("CITY"))) { objBranchBO.City = dr.GetString(dr.GetOrdinal("City")); } if (!dr.IsDBNull(dr.GetOrdinal("BRANCHNAME"))) { objBranchBO.BranchName = dr.GetString(dr.GetOrdinal("branchName")); } if (!dr.IsDBNull(dr.GetOrdinal("SWIFTCODE"))) { objBranchBO.SwiftCode = dr.GetString(dr.GetOrdinal("swiftCode")); } if (!dr.IsDBNull(dr.GetOrdinal("BANKCODE"))) { objBranchBO.BANKCODE = dr.GetString(dr.GetOrdinal("BANKCODE")); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { objBranchBO.IsDeleted = dr.GetString(dr.GetOrdinal("isDeleted")); } if (!dr.IsDBNull(dr.GetOrdinal("BranchID"))) { objBranchBO.BankBranchId = dr.GetInt32(dr.GetOrdinal("BranchID")); } objBranchList.Add(objBranchBO); } dr.Close(); } catch (Exception ex) { throw ex; } } } return(objBranchList); }
/// <summary> /// To update branch to database /// </summary> /// <param name="objBranchBO"></param> /// <returns></returns> public string UpdateBranch(BranchBO objBranchBO) { return((new BranchDAL()).UpdateBranch(objBranchBO)); }
/// <summary> /// To add branch to database /// </summary> /// <param name="objBranchBO"></param> /// <returns></returns> public string AddBranch(BranchBO objBranchBO) { return((new BranchDAL()).AddBranch(objBranchBO)); }
public ActionResult Login(LoginViewModel model, string returnUrl) { model.CompanyCode = "EZY"; var BranchDetails = new BranchBO().GetList().Where(x => x.BranchID == model.BranchID).ToList(); string BranchName = BranchDetails.Select(x => x.BranchName).FirstOrDefault(); //if (!string.IsNullOrEmpty(Request.QueryString["companyCode"])) //{ // var companyCode = UrlEncryptionHelper.Decrypt(Request.QueryString["companyCode"]); // var branchList = new BranchBO().GetList().Where(x => x.CompanyCode == companyCode).ToList(); // model.BranchList = new SelectList(branchList, "BranchID", "BranchName"); // var compist = new CompanyBO().GetList(); // for (var i = 0; i < compist.Count; i++) // { // compist[i].CompanyCode = UrlEncryptionHelper.Encrypt(compist[i].CompanyCode); // } // model.CompaniesList = new SelectList(compist, "CompanyCode", "CompanyName"); // return View("Index", model); //} if (!ModelState.IsValid) { return(RedirectToAction("Index")); } var lstUsers = new UsersBO().GetList(); var currentUser = lstUsers.Where( ur => ur.UserID.ToLower() == model.UserID.ToLower() && ur.Password.ToLower() == model.Password.ToLower()).FirstOrDefault(); var userBranch = new UserBranchBO().GetList(model.UserID) .Where(x => x.BranchID == model.BranchID) .FirstOrDefault(); if (currentUser != null && userBranch != null) { FormsAuthentication.SetAuthCookie(currentUser.UserID, false); var _CompanyId = model.CompanyCode; var SsnObj = new SessionObject { UserID = currentUser.UserID, UserName = currentUser.UserName, Email = currentUser.Email, RoleCode = currentUser.RoleCode, BranchId = model.BranchID, BranchName = BranchName, CompanyId = _CompanyId, CompanyName = new CompanyBO().GetList().Where(x => x.CompanyCode == _CompanyId).FirstOrDefault().CompanyName }; USER_OBJECT = SsnObj; USER_SECURABLES = new RoleRightsBO().GetSecurableItemsListByRoleCode(SsnObj.RoleCode); Session["UserID"] = currentUser.UserID; Session["UserName"] = currentUser.UserName; Session["BranchId"] = model.BranchID; if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Education", "Home")); } } else { //ModelState.AddModelError("", "The user name or password provided is incorrect."); ViewBag.ErrMsg = "The user name or password provided is incorrect."; LoginViewModel modelObj = new LoginViewModel(); var compist = new CompanyBO().GetList(); for (var i = 0; i < compist.Count; i++) { compist[i].CompanyCode = UrlEncryptionHelper.Encrypt(compist[i].CompanyCode); } modelObj.CompaniesList = new SelectList(compist, "CompanyCode", "CompanyName"); var companyCode = "EZY"; var branchList = new BranchBO().GetList().Where(x => x.CompanyCode == companyCode).ToList(); modelObj.BranchList = new SelectList(branchList, "BranchID", "BranchName").ToList(); return(View("Index", modelObj)); } }