public ActionResult UpdateMerchantInfo(string id) { if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Portal", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 1)) { return(RedirectToAction("Denied", "Portal", null)); } if (id == null) { return(new HttpStatusCodeResult(statusCode: 400)); } //Business Category for dropdown List <t_BusinessCategory> category_list = new List <t_BusinessCategory>(); using (Models.MerchantService db = new Models.MerchantService()) { category_list = db.t_BusinessCategory.ToList(); } ViewBag.Category = category_list; //Get Merchant Info mMerchant merchantinfo = new mMerchant(); try { using (Models.MerchantService db = new Models.MerchantService()) { t_Merchant_Info merch_info = db.t_Merchant_Info.Where(x => x.MPU_Merchant_ID == id).FirstOrDefault(); merchantinfo.MPU_Merchant_ID = merch_info.MPU_Merchant_ID; merchantinfo.Merchant_Name = merch_info.Merchant_Name; merchantinfo.Merchant_Address = merch_info.Merchant_Address; merchantinfo.Merchant_Email = merch_info.Merchant_Email; merchantinfo.Merchant_Phone = merch_info.Merchant_Phone; merchantinfo.OMPURate = merch_info.OMPURate; merchantinfo.OJCBRate = merch_info.OJCBRate; merchantinfo.OUPIRate = merch_info.OUPIRate; merchantinfo.MPURate = merch_info.MPURate; merchantinfo.JCBRate = merch_info.JCBRate; merchantinfo.UPIRate = merch_info.UPIRate; merchantinfo.Settlement_Acc = merch_info.Settlement_Acc; merchantinfo.SettAccountName = merch_info.SettAccountName; merchantinfo.BusinessCategoryID = merch_info.BusinessCategoryID; } return(View(merchantinfo)); } catch (Exception ex) { TempData["Message"] = ex.Message; TempData.Keep(); return(View()); } }
public ActionResult Reset(string uid) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } mUser User = new mUser(); try { using (Models.MerchantService db = new Models.MerchantService()) { t_Users u = new t_Users(); u = db.t_Users.Where(x => x.UserID == uid).SingleOrDefault(); User.UserID = u.UserID; //User.Passwd = u.Passwd; } } catch (Exception ex) { TempData["StatusMessage"] = ex.Message; TempData.Keep(); } return(View(User)); }
public ActionResult Create(mUser User) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } try { using (Models.MerchantService db = new Models.MerchantService()) { t_Users user = new t_Users(); user.StaffID = User.StaffID; user.UserID = User.UserID; user.Passwd = mUser.EncryptPassword(User.Passwd); user.UserLevel = User.UserLevel; user.AdminLogin = User.AdminLogin; db.t_Users.Add(user); db.SaveChanges(); TempData["StatusMessage"] = "Success"; TempData.Keep(); } } catch (Exception ex) { TempData["StatusMessage"] = ex.Message; TempData.Keep(); } return(View("Create")); }
public ActionResult ViewDetails(string staffid) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } if (staffid == null) { return(new HttpStatusCodeResult(400)); } mStaff s = new mStaff(); try { int id = int.Parse(staffid); using (Models.MerchantService db = new Models.MerchantService()) { v_Staff staff = db.v_Staff.Where(x => x.StaffID == id).SingleOrDefault(); s.StaffID = staff.StaffID; s.StaffName = staff.StaffName; s.Department = staff.Department; s.Office = staff.Office; } } catch (Exception ex) { TempData["StatusMessage"] = ex.Message; } return(View(s)); }
internal JsonResult RetrieveMerchantInfo(string mid) { v_Merchant m = new v_Merchant(); using (MerchantService.Models.MerchantService db = new Models.MerchantService()) { m = db.v_Merchant.Where(x => x.MPU_Merchant_ID == mid && x.MStatusID == 100).SingleOrDefault(); } return(Json(new { success = true, merchant = m }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddMerchant(mMerchant model) { if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Portal", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 1)) { return(RedirectToAction("Denied", "Portal", null)); } try { using (Models.MerchantService db = new Models.MerchantService()) { t_Merchant_Info merchant = new t_Merchant_Info(); merchant.MPU_Merchant_ID = model.MPU_Merchant_ID; merchant.Merchant_Name = model.Merchant_Name; merchant.Merchant_Phone = model.Merchant_Phone; merchant.Merchant_Email = model.Merchant_Email; merchant.Merchant_Address = model.Merchant_Address; merchant.OMPURate = model.OMPURate; merchant.OJCBRate = model.OJCBRate; merchant.OUPIRate = model.OUPIRate; merchant.MPURate = model.MPURate; merchant.JCBRate = model.JCBRate; merchant.UPIRate = model.UPIRate; merchant.Settlement_Acc = model.Settlement_Acc; merchant.SettAccountName = model.SettAccountName; merchant.BusinessCategoryID = model.BusinessCategoryID; merchant.MStatusID = 100; merchant.CreationDate = DateTime.Now.Date; db.t_Merchant_Info.Add(merchant); db.SaveChanges(); TempData["Message"] = "Saved"; TempData.Keep(); } } catch (Exception ex) { TempData["Message"] = ex.InnerException.InnerException.Message; TempData.Keep(); } return(RedirectToAction("CreateMerchant")); }
public ActionResult ViewDetails(string merchantid) { if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Portal", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 1)) { return(RedirectToAction("Denied", "Portal", null)); } mMerchant merchant = new mMerchant(); if (merchantid != null) { try { using (Models.MerchantService db = new Models.MerchantService()) { v_Merchant merchant_info = new v_Merchant(); merchant_info = db.v_Merchant.Where(x => x.MPU_Merchant_ID == merchantid).SingleOrDefault(); merchant.MPU_Merchant_ID = merchant_info.MPU_Merchant_ID; merchant.Merchant_Name = merchant_info.Merchant_Name; merchant.Merchant_Address = merchant_info.Merchant_Address; merchant.Merchant_Email = merchant_info.Merchant_Email; merchant.Merchant_Phone = merchant_info.Merchant_Phone; merchant.OMPURate = merchant_info.OMPURate; merchant.OJCBRate = merchant_info.OJCBRate; merchant.OUPIRate = merchant_info.OUPIRate; merchant.MPURate = merchant_info.MPURate; merchant.JCBRate = merchant_info.JCBRate; merchant.UPIRate = merchant_info.UPIRate; merchant.Settlement_Acc = merchant_info.Settlement_Acc; merchant.SettAccountName = merchant_info.SettAccountName; merchant.BusinessCategoryID = merchant_info.BusinessCategoryID; merchant.BusinessCategory = merchant_info.BusinessCategory; } } catch (Exception ex) { TempData["Message"] = ex.Message; TempData.Keep(); } } return(View(merchant)); }
public ActionResult Update(string staffid) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } mStaff Mstaff = new mStaff(); if (staffid == null) { return(new HttpStatusCodeResult(statusCode: 400)); } int staff_id = int.Parse(staffid); try { using (Models.MerchantService db = new Models.MerchantService()) { //Load data for dropdown list List <t_Department> departments = new List <t_Department>(); departments = db.t_Department.ToList(); List <t_Office> Offices = new List <t_Office>(); Offices = db.t_Office.ToList(); ViewBag.DepartmentList = departments; ViewBag.OfficeList = Offices; t_Staff staff = db.t_Staff.Where(x => x.StaffID == staff_id).SingleOrDefault(); Mstaff.StaffID = staff.StaffID; Mstaff.StaffName = staff.StaffName; Mstaff.DepartmentID = staff.DepartmentID; Mstaff.OfficeID = staff.OfficeID; } } catch (Exception ex) { TempData["ErrorMessage"] = ex.Message; TempData.Keep(); } return(View(Mstaff)); }
// GET: User public ActionResult Index(string keywordsearch) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } List <mUser> users = new List <mUser>(); using (Models.MerchantService db = new Models.MerchantService()) { List <v_UserInfo> userinfos = db.v_UserInfo.Where(x => x.StaffName.Contains(keywordsearch) || keywordsearch == null).ToList(); users = userinfos.Select(x => new mUser { StaffID = x.StaffID, StaffName = x.StaffName, DepartmentID = x.DepartmentID, Department = x.Department, OfficeID = x.OfficeID, Office = x.Office, UserID = x.UserID, UserLevel = x.UserLevel, AdminLogin = x.AdminLogin }).ToList(); } return(View(users)); }
public ActionResult UpdateMerchant(mMerchant model) { if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Portal", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 1)) { return(RedirectToAction("Denied", "Portal", null)); } try { using (Models.MerchantService db = new Models.MerchantService()) { //Call Update Method mMerchant merchant = new mMerchant(); merchant.UpdateMerchant(model); TempData["Message"] = "Success"; TempData.Keep(); } } catch (Exception ex) { TempData["Message"] = ex.Message; TempData.Keep(); } //Business Category for dropdown List <t_BusinessCategory> category_list = new List <t_BusinessCategory>(); using (Models.MerchantService db = new Models.MerchantService()) { category_list = db.t_BusinessCategory.ToList(); } ViewBag.Category = category_list; return(RedirectToAction("UpdateMerchantInfo", new { id = model.MPU_Merchant_ID })); }
public ActionResult ChooseStaff() { if (HttpContext.Session["AID"] == null) { return(new HttpStatusCodeResult(400)); } List <mStaff> s = new List <mStaff>(); using (Models.MerchantService db = new Models.MerchantService()) { List <v_Staff> staffs = new List <v_Staff>(); staffs = db.v_Staff.ToList(); s = staffs.Select(x => new mStaff { StaffID = x.StaffID, StaffName = x.StaffName, Department = x.Department, Office = x.Office }).ToList(); } return(View(s)); }
public ActionResult Update(mStaff Staff) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } mStaff Mstaff = new mStaff(); try { using (Models.MerchantService db = new Models.MerchantService()) { //Load data for dropdown list List <t_Department> departments = new List <t_Department>(); departments = db.t_Department.ToList(); List <t_Office> Offices = new List <t_Office>(); Offices = db.t_Office.ToList(); ViewBag.DepartmentList = departments; ViewBag.OfficeList = Offices; //update info call procedure bool is_success = Staff.UpdateStaffInfo(); if (is_success) { TempData["StatusMessage"] = "Success"; } else { TempData["StatusMessage"] = "Error"; } } } catch (Exception ex) { TempData["ErrorMessage"] = ex.Message; TempData.Keep(); } return(View()); }
// GET: Staff public ActionResult Index(string keywordsearch) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } List <mStaff> StaffList = new List <mStaff>(); using (MerchantService.Models.MerchantService db = new Models.MerchantService()) { List <v_Staff> Staffs = db.v_Staff.Where(x => x.StaffName.Contains(keywordsearch) || keywordsearch == null).ToList(); StaffList = Staffs.Select(x => new mStaff { StaffID = x.StaffID, StaffName = x.StaffName, DepartmentID = x.DepartmentID, Department = x.Department, OfficeID = x.OfficeID, Office = x.Office }).ToList(); } return(View(StaffList)); }
public ActionResult AddStaff() { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } using (MerchantService.Models.MerchantService db = new Models.MerchantService()) { List <t_Department> departments = new List <t_Department>(); departments = db.t_Department.ToList(); List <t_Office> Offices = new List <t_Office>(); Offices = db.t_Office.ToList(); ViewBag.DepartmentList = departments; ViewBag.OfficeList = Offices; } return(View()); }
public bool Check(string staffid, string uid) { bool isPass = false; using (Models.MerchantService db = new Models.MerchantService()) { t_Users u = new t_Users(); u = db.t_Users.Where(x => x.UserID == uid).SingleOrDefault(); if (u != null) { isPass = false; } else { isPass = true; } } return(isPass); }
public PartialViewResult ActiveMerchantResult(DateTime startdate, DateTime enddate) { if (HttpContext.Session["UID"] == null) { TempData["ErrorMessage"] = "Session Error"; TempData.Keep(); return(PartialView()); } using (Models.MerchantService db = new Models.MerchantService()) { List <mMerchant> merchantList = getActiveMerchant(startdate, enddate); ViewBag.MerchantVB = merchantList; ViewData["startdate"] = startdate.Date; ViewData["enddate"] = enddate.Date; } return(PartialView()); }
public PartialViewResult TRX_PartialView(string trxdate, string TrxType) { List <mTransaction> trx_list = new List <mTransaction>(); ViewBag.TrxType = TrxType; ViewBag.TrxDate = trxdate; if (HttpContext.Session["UID"] == null) { TempData["ErrorMessage"] = "Session Error"; TempData.Keep(); return(PartialView(trx_list)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 2)) { TempData["ErrorMessage"] = "Access Denied"; TempData.Keep(); return(PartialView(trx_list)); } try { DateTime trxDate = Convert.ToDateTime(trxdate); using (Models.MerchantService db = new Models.MerchantService()) { List <t_Transactions> ts = new List <t_Transactions>(); ts = db.t_Transactions.Where(x => x.TrxDate == trxDate && x.RecordType == TrxType).ToList(); trx_list = ts.Select(x => new mTransaction { TrxID = x.TrxID, TrxDate = x.TrxDate, MPU_Merchant_ID = x.MPU_Merchant_ID, CardNo = x.CardNo, CardType = x.CardType, TRXMDRRate = x.TRXMDRRate, TrxAmount = x.TrxAmount, SettAmount = x.SettAmount, ProcessingCode = x.ProcessingCode, TerminalID = x.TerminalID, RecordType = x.RecordType }).ToList(); } } catch (Exception ex) { TempData["ErrorMessage"] = ex.Message; TempData.Keep(); } return(PartialView(trx_list)); }
public ActionResult Edit(string uid) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } mUser user = new mUser(); using (Models.MerchantService db = new Models.MerchantService()) { t_Users u = new t_Users(); u = db.t_Users.Where(x => x.UserID == uid).SingleOrDefault(); user.UserID = u.UserID; user.AdminLogin = u.AdminLogin; user.UserLevel = u.UserLevel; } return(View(user)); }
public ActionResult AddStaff(mStaff Staff) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } using (MerchantService.Models.MerchantService db = new Models.MerchantService()) { //Insert To Table try { t_Staff Tstaff = new t_Staff(); Tstaff.StaffName = Staff.StaffName; Tstaff.DepartmentID = Staff.DepartmentID; Tstaff.OfficeID = Staff.OfficeID; db.t_Staff.Add(Tstaff); db.SaveChanges(); TempData["StatusMessage"] = "Success"; TempData.Keep(); } catch (Exception ex) { TempData["StatusMessage"] = ex.Message; TempData.Keep(); } //Load data for dropdown list List <t_Department> departments = new List <t_Department>(); departments = db.t_Department.ToList(); List <t_Office> Offices = new List <t_Office>(); Offices = db.t_Office.ToList(); ViewBag.DepartmentList = departments; ViewBag.OfficeList = Offices; } return(View()); }
// GET: Merchant public ActionResult Index(string keyworksearch) { if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Portal", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 1)) { return(RedirectToAction("Denied", "Portal", null)); } List <v_Merchant> merchant_list = new List <v_Merchant>(); using (MerchantService.Models.MerchantService db = new Models.MerchantService()) { merchant_list = db.v_Merchant.Where(x => x.Merchant_Name.Contains(keyworksearch) || keyworksearch == null).ToList(); } return(View(merchant_list)); }
public ActionResult CreateMerchant() { if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Merchant", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 1)) { return(RedirectToAction("Denied", "Portal", null)); } //Business Category for dropdown List <t_BusinessCategory> category_list = new List <t_BusinessCategory>(); using (Models.MerchantService db = new Models.MerchantService()) { category_list = db.t_BusinessCategory.ToList(); } ViewBag.Category = category_list; return(View()); }
internal FileResult ExportExcel() { if (HttpContext.Session["UID"] != null) { List <v_Merchant> merchant_list = new List <v_Merchant>(); using (MerchantService.Models.MerchantService db = new Models.MerchantService()) { merchant_list = db.v_Merchant.ToList(); } ExcelPackage.LicenseContext = LicenseContext.NonCommercial; ExcelPackage Ep = new ExcelPackage(); ExcelWorksheet Sheet = Ep.Workbook.Worksheets.Add("Report"); Sheet.Cells["A1"].Value = "MID"; Sheet.Cells["B1"].Value = "Merchant"; Sheet.Cells["C1"].Value = "Phone"; Sheet.Cells["D1"].Value = "Email"; Sheet.Cells["E1"].Value = "Address"; Sheet.Cells["F1"].Value = "MPU Rate"; Sheet.Cells["G1"].Value = "UPI Rate"; Sheet.Cells["H1"].Value = "JCB Rate"; Sheet.Cells["I1"].Value = "MPU(on us) Rate"; Sheet.Cells["J1"].Value = "UPI(on us) Rate"; Sheet.Cells["K1"].Value = "JCB(on us) Rate"; Sheet.Cells["L1"].Value = "Settlement Account"; Sheet.Cells["M1"].Value = "Account Name"; int row = 2; foreach (var item in merchant_list) { Sheet.Cells[string.Format("A{0}", row)].Value = item.MPU_Merchant_ID; Sheet.Cells[string.Format("B{0}", row)].Value = item.Merchant_Name; Sheet.Cells[string.Format("C{0}", row)].Value = item.Merchant_Phone; Sheet.Cells[string.Format("D{0}", row)].Value = item.Merchant_Email; Sheet.Cells[string.Format("E{0}", row)].Value = item.Merchant_Address; Sheet.Cells[string.Format("F{0}", row)].Value = item.MPURate; Sheet.Cells[string.Format("G{0}", row)].Value = item.UPIRate; Sheet.Cells[string.Format("H{0}", row)].Value = item.JCBRate; Sheet.Cells[string.Format("I{0}", row)].Value = item.OMPURate; Sheet.Cells[string.Format("J{0}", row)].Value = item.OUPIRate; Sheet.Cells[string.Format("K{0}", row)].Value = item.OJCBRate; Sheet.Cells[string.Format("L{0}", row)].Value = item.Settlement_Acc; Sheet.Cells[string.Format("M{0}", row)].Value = item.SettAccountName; row++; } Sheet.Cells["A:AZ"].AutoFitColumns(); //Response.Clear(); //Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; //Response.AddHeader("content-disposition", "attachment: filename=" + "MerchantList.xlsx"); //Response.BinaryWrite(Ep.GetAsByteArray()); //Response.End(); var FileByteArray = Ep.GetAsByteArray(); return(File(FileByteArray, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "MerchantList.xlsx")); } else { return(File(new Byte[0], "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "MerchantList.xlsx")); } }