//-----------------------------Populate clients on the table---------------------------- public ActionResult Index() { LaunSysDBEntities db = new LaunSysDBEntities(); List <tb_Titles> TitleList = db.tb_Titles.ToList(); ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title"); List <tb_Gender> GenderList = db.tb_Gender.ToList(); ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername"); List <ClientsViewModel> ClientsList = db.tb_Customers.Where(x => x.IsNotActive == false).Select(x => new ClientsViewModel { Title = x.tb_Titles.Title, SurName = x.SurName, OtherNames = x.OtherNames, Gendername = x.tb_Gender.Gendername, Cust_Address = x.Cust_Address, Phone = x.Phone, Email = x.Email, CreatedDate = x.CreatedDate, CustID = x.CustID }).ToList(); ViewBag.ListOfClients = ClientsList; return(View()); }
//-----------------------------to view client details individually---------------------------- public ActionResult ViewClient(int CustID) { LaunSysDBEntities db = new LaunSysDBEntities(); List <ClientsViewModel> ClientDetail = db.tb_Customers.Where (x => x.IsNotActive == false && x.CustID == CustID) .Select(x => new ClientsViewModel { Title = x.tb_Titles.Title, SurName = x.SurName, OtherNames = x.OtherNames, Gendername = x.tb_Gender.Gendername, Cust_Address = x.Cust_Address, Phone = x.Phone, Email = x.Email, CreatedDate = x.CreatedDate, CustID = x.CustID }).ToList(); ViewBag.SingleClientDetail = ClientDetail; return(PartialView("SingleClientView")); }
//-----------------------------Add Edit---------------------------- public ActionResult AddEdit(int CustID) { LaunSysDBEntities db = new LaunSysDBEntities(); List <tb_Titles> TitleList = db.tb_Titles.ToList(); ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title"); List <tb_Gender> GenderList = db.tb_Gender.ToList(); ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername"); ClientsViewModel Model = new ClientsViewModel(); if (CustID > 0) { tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.CustID == CustID && x.IsNotActive == false); Model.CustID = Cust.CustID; Model.TitleID = Cust.TitleID; Model.SurName = Cust.SurName; Model.OtherNames = Cust.OtherNames; Model.GenderID = Cust.GenderID; Model.Cust_Address = Cust.Cust_Address; Model.Phone = Cust.Phone; Model.Email = Cust.Email; Model.CreatedDate = Cust.CreatedDate; } return(PartialView("AddEditViewPartialView", Model)); }
//-----------------------------Add Edit---------------------------- public ActionResult AddEdit(int Id) { LaunSysDBEntities db = new LaunSysDBEntities(); List <tb_Branch> BranchList = db.tb_Branch.ToList(); ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname"); List <tb_Status> StatusList = db.tb_Status.ToList(); ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status"); //initialize the View model responsible for the Editing //To get the record that is to be edited IncomesViewModel Model = new IncomesViewModel(); if (Id > 0) { tb_Income Income = db.tb_Income.SingleOrDefault(x => x.Id == Id && x.tb_Status.Status == true); Model.Id = Income.Id; Model.Date = Income.Date; Model.Inc_SN = Income.Inc_SN; Model.Description = Income.Description; Model.Inv_No = Income.Inv_No; Model.Amount = Income.Amount; Model.BranchId = Income.BranchId; Model.StatusId = Income.StatusId; } return(PartialView("AddEditViewPartialView", Model)); }
// to activate Authorization = [AuthorizeRoles(admin,accountant)] // to add default route = [Route("x/x/{parameter 1}/{parameter 2}")] // to pass parameter by exception = public ActionResult Index( string Id, ClientsViewModel Model) public ActionResult Index(ClientsViewModel Model) { try { //if (ModelState.IsValid == true) //{ LaunSysDBEntities db = new LaunSysDBEntities(); //------------------------To populate the drop down lists--------------------------- List <tb_Titles> TitleList = db.tb_Titles.ToList(); ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title"); List <tb_Gender> GenderList = db.tb_Gender.ToList(); ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername"); //---------------------------------------------------------------------------------- if (Model.CustID > 0) { //UPDATE EXISTING RECORD tb_Customers Clients = db.tb_Customers.SingleOrDefault(x => x.CustID == Model.CustID && x.IsNotActive == false); Clients.TitleID = Model.TitleID; Clients.SurName = Model.SurName; Clients.OtherNames = Model.OtherNames; Clients.GenderID = Model.GenderID; Clients.Cust_Address = Model.Cust_Address; Clients.Phone = Model.Phone; Clients.Email = Model.Email; Clients.CreatedDate = Model.CreatedDate; db.SaveChanges(); } else { //INSERT NEW RECORD tb_Customers Clients = new tb_Customers(); Clients.TitleID = Model.TitleID; Clients.SurName = Model.SurName; Clients.OtherNames = Model.OtherNames; Clients.GenderID = Model.GenderID; Clients.Cust_Address = Model.Cust_Address; Clients.Phone = Model.Phone; Clients.Email = Model.Email; Clients.CreatedDate = Model.CreatedDate; Clients.IsNotActive = false; db.tb_Customers.Add(Clients); db.SaveChanges(); } return(View(Model)); //} } catch (Exception ex) { throw ex; } }
public ActionResult GetData() { using (LaunSysDBEntities db = new LaunSysDBEntities()) { List <tb_Incoming_Fabrics> incFab = db.tb_Incoming_Fabrics.ToList <tb_Incoming_Fabrics>(); return(Json(new { data = incFab }, JsonRequestBehavior.AllowGet)); } }
//-----------------------------to view User details individually---------------------------- public ActionResult ViewUser(int UserId) { LaunSysDBEntities db = new LaunSysDBEntities(); List <UsersViewModel> UserDetail = db.tb_Users.Where(x => x.tb_Status.Status == true && x.UserId == UserId).Select(x => new UsersViewModel { Email = x.Email, Password = x.Password, Rolename = x.tb_Role.Rolename, Divisionname = x.tb_Division.Divisionname, Status = x.tb_Status.Status, Branchname = x.tb_Branch.Branchname, Deptname = x.tb_Department.Deptname, UserId = x.UserId }).ToList(); ViewBag.SingleUserDetail = UserDetail; return(PartialView("SingleUserView")); }
//-----------------------------Delete client---------------------------- public JsonResult DeleteClient(int CustID) { LaunSysDBEntities db = new LaunSysDBEntities(); bool result = false; tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.IsNotActive == false && x.CustID == CustID); if (Cust != null) { //set the customer id to true, there fore hide it from the table\ Cust.IsNotActive = true; db.SaveChanges(); result = true; } //FlashMessage.Info("Invalid Login Details"); return(Json(result, JsonRequestBehavior.AllowGet)); }
//-----------------------------Delete User---------------------------- public JsonResult DeleteUser(int UserId) { LaunSysDBEntities db = new LaunSysDBEntities(); bool result = false; tb_Users User = db.tb_Users.SingleOrDefault(x => x.StatusId == 1 && x.UserId == UserId); /// tb_Users User = db.tb_Users.SingleOrDefault(x => x.tb_Status.Status == true && x.UserId == UserId); if (User != null) { //set the customer id to true, there fore hide it from the table\ //User.tb_Status.Status = false; User.StatusId = 2; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
//-----------------------------Delete Income---------------------------- public JsonResult DeleteIncome(int Id) { LaunSysDBEntities db = new LaunSysDBEntities(); bool result = false; //tb_Income Income = db.tb_Income.SingleOrDefault(x => x.StatusId == 1 && x.Id == Id); tb_Income Income = db.tb_Income.SingleOrDefault (x => x.tb_Status.Status == true && x.Id == Id); if (Income != null) { //set the customer id to true, there fore hide it from the table\ // Income.tb_Status.Status = false; Income.StatusId = 2; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
//-----------------------------Add/Edit---------------------------- public ActionResult AddEdit(int UserId) { LaunSysDBEntities db = new LaunSysDBEntities(); List <tb_Role> RoleList = db.tb_Role.ToList(); ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename"); List <tb_Division> DivisionList = db.tb_Division.ToList(); ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname"); List <tb_Branch> BranchList = db.tb_Branch.ToList(); ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname"); List <tb_Department> DeptList = db.tb_Department.ToList(); ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname"); List <tb_Status> StatusList = db.tb_Status.ToList(); ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status"); UsersViewModel Model = new UsersViewModel(); if (UserId > 0) { tb_Users Users = db.tb_Users.SingleOrDefault(x => x.UserId == UserId && x.tb_Status.Status == true); Model.UserId = Users.UserId; Model.Email = Users.Email; Model.Password = Users.Password; Model.RoleId = Users.RoleId; Model.DivisionId = Users.DivisionId; Model.BranchId = Users.BranchId; Model.DeptId = Users.DeptId; Model.StatusId = Users.StatusId; } return(PartialView("AddEditViewPartialView", Model)); }
//-----------------------------Populate clients on the table---------------------------- // GET: Users public ActionResult Index() { LaunSysDBEntities db = new LaunSysDBEntities(); List <tb_Role> RoleList = db.tb_Role.ToList(); ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename"); List <tb_Division> DivisionList = db.tb_Division.ToList(); ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname"); List <tb_Branch> BranchList = db.tb_Branch.ToList(); ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname"); List <tb_Department> DeptList = db.tb_Department.ToList(); ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname"); List <tb_Status> StatusList = db.tb_Status.ToList(); ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status"); List <UsersViewModel> UsersList = db.tb_Users.Where(x => x.tb_Status.Status == true).Select( x => new UsersViewModel { Email = x.Email, Password = x.Password, Rolename = x.tb_Role.Rolename, Divisionname = x.tb_Division.Divisionname, Status = x.tb_Status.Status, Branchname = x.tb_Branch.Branchname, Deptname = x.tb_Department.Deptname, UserId = x.UserId }).ToList(); ViewBag.ListOfUsers = UsersList; return(View()); }
//-----------------------------to view Income details individually---------------------------- public ActionResult ViewIncome(int Id) { LaunSysDBEntities db = new LaunSysDBEntities(); List <IncomesViewModel> IncomeDetail = db.tb_Income.Where(x => x.tb_Status.Status == true && x.Id == Id).Select( x => new IncomesViewModel { Date = x.Date, Inc_SN = x.Inc_SN, Description = x.Description, Inv_No = x.Inv_No, Amount = x.Amount, Branchname = x.tb_Branch.Branchname, Id = x.Id, Status = x.tb_Status.Status }).ToList(); ViewBag.SingleIncomeDetail = IncomeDetail; return(PartialView("SingleIncomeView")); }
public ActionResult LoginUser(UsersViewModel Model) { if (ModelState.IsValid) { string result = "fail"; if (Model.Email == "*****@*****.**" && Model.Password == "admin") { Session["Email"] = "*****@*****.**"; Session["Password"] = "******"; Session["UserDepartment"] = "Default"; Session["UserRole"] = "Admin"; result = "Admin"; return(RedirectToAction("Index", "Clients")); } else { LaunSysDBEntities db = new LaunSysDBEntities(); var pass = System.Text.Encoding.UTF8.GetBytes(Model.Password); var encpass = Convert.ToBase64String(pass); tb_Users User = db.tb_Users.SingleOrDefault(x => x.Email == Model.Email && x.Password == encpass); //tb_Users User = db.tb_Users.SingleOrDefault(x => x.Email == Model.Email && x.Password == Model.Password); if (User != null) { Session["Email"] = User.Email; Session["Password"] = User.Password; if (User.tb_Department.Deptname != null) { Session["UserDepartment"] = User.tb_Department.Deptname; } Session["UserRole"] = User.tb_Role.Rolename; if (User.RoleId == 1) { result = "Admin"; return(RedirectToAction("Index", "Clients")); } else if (User.RoleId == 2) { result = "Manager"; return(RedirectToAction("Index", "Home")); } } else { //FlashMessage.Info("Your informational message"); //FlashMessage.Confirmation("Your confirmation message"); //FlashMessage.Warning("Your warning message"); //FlashMessage.Danger("Your danger alert"); //FlashMessage.Danger("Message title", "Your danger alert"); FlashMessage.Confirmation("Invalid Login Details"); return(RedirectToAction("Login", "Access")); // return RedirectToAction("Index", "Users"); } if (result == "fail") { FlashMessage.Confirmation("Invalid Login failed"); return(RedirectToAction("Login", "Access")); ///return RedirectToAction("Index", "Users"); } //if (result == "Admin") //{ // return RedirectToAction("Index", "Clients"); //} //if (result == "Manager") //{ //} //return Json(result, JsonRequestBehavior.AllowGet); } } return(View()); }
public JsonResult SaveIncomingfabric(IncomingFabricsViewModel IncfabricData) { bool status = false; //if (ModelState.IsValid) //{ //------------------alternatively-------------- //tb_Incoming_Fabrics incFab = new tb_Incoming_Fabrics(); //incFab.BranchId = IncfabricData.BranchId; //incFab.Branch_Name = IncfabricData.Branchname; //incFab.CustomerId = IncfabricData.CustomerId; //incFab.Customer_Name = IncfabricData.Customer_Name; //incFab.Date_Recorded = DateTime.Now; //incFab.Receipt_No = IncfabricData.Receipt_No; //incFab.Total_Amt = IncfabricData.Total_Amt; //incFab.Recorded_By = Session["Email"].ToString(); //db.tb_Incoming_Fabrics.Add(incFab); //foreach (var IndFab in IncfabricData.Incoming_Fabric_Desc) //{ // IndFab.IncFabId = incFab.IncFabId; // incFab.tb_Incoming_Fabric_Desc.Add(IndFab); //} //db.tb_Incoming_Fabrics.Add(incFab); //db.SaveChanges(); //status = true; //------------------end of alternatively-------------- using (LaunSysDBEntities IncFabDetail = new LaunSysDBEntities()) { tb_Incoming_Fabrics FabInfo = new tb_Incoming_Fabrics { BranchId = IncfabricData.BranchId, //Branch_Name = IncfabricData.Branch_Name, CustomerId = IncfabricData.CustomerId, //Customer_Name = IncfabricData.Customer_Name, Date_Recorded = DateTime.Now, Receipt_No = IncfabricData.Receipt_No, Total_Amt = IncfabricData.Total_Amt, Recorded_By = Session["Email"].ToString(), }; //tb_Incoming_Fabrics FabInfo = new tb_Incoming_Fabrics //{ // CustomerId = 990 //}; IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo); IncFabDetail.SaveChanges(); foreach (var IndfabDetail in IncfabricData.Incoming_Fabric_Desc) { //FabInfo.tb_Incoming_Fabric_Desc.Add(IndfabDetail); IndfabDetail.IncFabId = FabInfo.IncFabId; IncFabDetail.tb_Incoming_Fabric_Desc.Add(IndfabDetail); } //IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo); //tb_Incoming_Fabric_Desc FabDescription = new tb_Incoming_Fabric_Desc() //{ // Description = IncfabricData.Incoming_Fabric_Desc. //}; //IncFabDetail.tb_Incoming_Fabric_Desc.Add() //IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo); IncFabDetail.SaveChanges(); status = true; } //---------------------------------------------------------- //using (LaunSysDBEntities IncFabDetail = new LaunSysDBEntities()) // { // tb_Incoming_Fabrics FabInfo = new tb_Incoming_Fabrics // { // BranchId = IncfabricData.BranchId, // Branch_Name = IncfabricData.Branch_Name, // CustomerId = IncfabricData.CustomerId, // Customer_Name = IncfabricData.Customer_Name, // Date_Recorded = DateTime.Now, // Receipt_No = IncfabricData.Receipt_No, // Total_Amt = IncfabricData.Total_Amt, // Recorded_By = Session["Email"].ToString(), // }; // IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo); // IncFabDetail.SaveChanges(); // int X = FabInfo.IncFabId; // foreach(var IndfabDetail in IncfabricData.Incoming_Fabric_Desc) // { // IndfabDetail.IncFabId = X; // FabInfo.tb_Incoming_Fabric_Desc.Add(IndfabDetail); // IncFabDetail.SaveChanges(); // }; // status = true; // } //-----------------------------------------------another--------------------- //} //else //{ // status = false; //} return(new JsonResult { Data = new { status = status } }); }
public ActionResult Index(UsersViewModel Model) { try { //if (ModelState.IsValid == true) //{ LaunSysDBEntities db = new LaunSysDBEntities(); //------------------------To populate the drop down lists--------------------------- List <tb_Role> RoleList = db.tb_Role.ToList(); ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename"); List <tb_Division> DivisionList = db.tb_Division.ToList(); ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname"); List <tb_Branch> BranchList = db.tb_Branch.ToList(); ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname"); List <tb_Department> DeptList = db.tb_Department.ToList(); ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname"); List <tb_Status> StatusList = db.tb_Status.ToList(); ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status"); //---------------------------------------------------------------------------------- if (Model.UserId > 0) { //UPDATE EXISTING RECORD tb_Users Users = db.tb_Users.SingleOrDefault(x => x.UserId == Model.UserId && x.tb_Status.Status == true); Users.UserId = Model.UserId; Users.Email = Model.Email; Users.Password = Model.Password; Users.RoleId = Model.RoleId; Users.DivisionId = Model.DivisionId; Users.BranchId = Model.BranchId; Users.DeptId = Model.DeptId; Users.StatusId = Model.StatusId; db.SaveChanges(); } else { //INSERT NEW RECORD tb_Users Users = new tb_Users(); Users.UserId = Model.UserId; Users.Email = Model.Email; var pass = System.Text.Encoding.UTF8.GetBytes(Model.Password); Users.Password = Convert.ToBase64String(pass); // Users.Password = Model.Password; Users.RoleId = Model.RoleId; Users.DivisionId = Model.DivisionId; Users.BranchId = Model.BranchId; Users.DeptId = Model.DeptId; Users.StatusId = Model.StatusId; db.tb_Users.Add(Users); db.SaveChanges(); } return(View(Model)); //} } catch (Exception ex) { throw ex; } }