// 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 Index(IncomesViewModel Model) { try { //LaunSysDBEntities db = new LaunSysDBEntities(); //if (ModelState.IsValid == true) //{ //------------------------To populate the drop down lists--------------------------- //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"); AllDropDown(); ////---------------------------------------------------------------------------------- if (Model.Id > 0) { //UPDATE EXISTING RECORD tb_Income IncomeData = db.tb_Income.SingleOrDefault(x => x.Id == Model.Id && x.tb_Status.Status == true); IncomeData.Id = Model.Id; IncomeData.Date = Model.Date; IncomeData.Inc_SN = Model.Inc_SN; IncomeData.Description = Model.Description; IncomeData.Inv_No = Model.Inv_No; IncomeData.Amount = Model.Amount; IncomeData.BranchId = Model.BranchId; IncomeData.StatusId = Model.StatusId; db.SaveChanges(); } else { //INSERT NEW RECORD tb_Income IncomeData = new tb_Income(); IncomeData.Id = Model.Id; IncomeData.Date = Model.Date; IncomeData.Inc_SN = Model.Inc_SN; IncomeData.Description = Model.Description; IncomeData.Inv_No = Model.Inv_No; IncomeData.Amount = Model.Amount; IncomeData.BranchId = Model.BranchId; IncomeData.StatusId = Model.StatusId; db.tb_Income.Add(IncomeData); db.SaveChanges(); } return(View(Model)); //} } catch (Exception ex) { throw ex; } }
public JsonResult InsertCustomers(CustomersViewModel model) { var result = false; try { if (model.CustID > 0) { tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.IsNotActive == false && x.CustID == model.CustID); Cust.TitleID = model.TitleID; Cust.SurName = model.SurName; Cust.OtherNames = model.OtherNames; Cust.GenderID = model.GenderID; Cust.Cust_Address = model.Cust_Address; Cust.Phone = model.Phone; Cust.Email = model.Email; Cust.CreatedDate = model.CreatedDate; //Cust.IsNotActive = false; //3077145452 db.SaveChanges(); result = true; } else { tb_Customers Cust = new tb_Customers(); Cust.TitleID = model.TitleID; Cust.SurName = model.SurName; Cust.OtherNames = model.OtherNames; Cust.GenderID = model.GenderID; Cust.Cust_Address = model.Cust_Address; Cust.Phone = model.Phone; Cust.Email = model.Email; Cust.CreatedDate = model.CreatedDate; Cust.IsNotActive = false; db.tb_Customers.Add(Cust); db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public ActionResult Index(ExpensesViewModel Model) { try { AllDropDowns(); //TO UPDATE EXISITING RECORD if (Model.Id > 0) { tb_Expenses ExpensesData = db.tb_Expenses.SingleOrDefault(x => x.Id == Model.Id && x.tb_Status.Status == true); ExpensesData.Id = Model.Id; ExpensesData.Date = Model.Date; ExpensesData.Exp_SN = Model.Exp_SN; ExpensesData.Description = Model.Description; ExpensesData.Inv_No = Model.Inv_No; ExpensesData.Amount = Model.Amount; ExpensesData.BranchId = Model.BranchId; ExpensesData.StatusId = Model.StatusId; db.SaveChanges(); } else { //TO INSERT NEW EXPENSES DATA tb_Expenses ExpensesData = new tb_Expenses(); ExpensesData.Id = Model.Id; ExpensesData.Date = Model.Date; ExpensesData.Exp_SN = Model.Exp_SN; ExpensesData.Description = Model.Description; ExpensesData.Inv_No = Model.Inv_No; ExpensesData.Amount = Model.Amount; ExpensesData.BranchId = Model.BranchId; ExpensesData.StatusId = Model.StatusId; db.tb_Expenses.Add(ExpensesData); db.SaveChanges(); } return(View(Model)); } catch (Exception ex) { throw ex; } }
//-----------------------------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)); }
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; } }