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