public ActionResult CreateItem(ItemVM item) { using (LIVEEntities db = new LIVEEntities()) { FrdItem nw = new FrdItem(); nw.ItemNo = item.ItemNo; nw.ItemCode = item.ItemCode; nw.ItemName = item.ItemName; nw.ItemDescription = item.ItemDescription; nw.ItemType = item.ItemType; nw.ItemTypeCode = item.ItemTypeCode; nw.ItemUnitCode = item.ItemUnitCode; nw.PlantCode = item.PlantCode; nw.ItemMachineCode = item.ItemMachineCode; nw.UnitPrice = item.UnitPrice; nw.TaxFlag = item.TaxFlag; nw.ConvertValue = item.ConvertValue; nw.UseFor = item.UseFor; nw.Show = item.Show; nw.CreateBy = Session["Name"].ToString(); nw.CreateDate = DateTime.Now; db.FrdItems.Add(nw); db.SaveChanges(); return(RedirectToAction("Index")); } }
public JsonResult CreateItem(ItemVM item, ItemVMInfo iteminf) { bool status = false; string mes = ""; if (ModelState.IsValid) { using (LIVEEntities db = new LIVEEntities()) { FrdItem nw = new FrdItem(); nw.ItemNo = item.ItemNo; nw.ItemCode = item.ItemCode; nw.ItemName = item.ItemName; nw.ItemDescription = item.ItemDescription; nw.ItemType = item.ItemType; nw.ItemTypeCode = item.ItemTypeCode; nw.ItemUnitCode = item.ItemUnitCode; nw.PlantCode = item.PlantCode; nw.ItemMachineCode = item.ItemMachineCode; nw.UnitPrice = item.UnitPrice; nw.TaxFlag = "Y"; nw.ConvertValue = item.ConvertValue; nw.UseFor = "User recomended"; nw.Show = "N"; nw.CreateBy = Session["Name"].ToString(); nw.CreateDate = DateTime.Now; db.FrdItems.Add(nw); db.SaveChanges(); FrdItemInfo inf = new FrdItemInfo(); inf.PlantID = item.PlantCode; inf.ItemID = item.ItemNo; inf.ItemCode = item.ItemTypeCode.ToString(); inf.ItemType = item.ItemType; //inf.ItemUse = iteminf.ItemUse; inf.MachineID = item.ItemMachineCode; inf.AlmariCode = iteminf.AlmariCode; inf.AlmariDesc = "Emptynit"; inf.ItemSize = "size"; inf.RowID = iteminf.RowID; inf.RacID = iteminf.RacID; inf.BinID = iteminf.BinID; inf.Location = item.Location; db.FrdItemInfoes.Add(inf); db.SaveChanges(); status = true; } } else { status = false; } return(new JsonResult { Data = new { status = status, mes = mes } }); }
public ActionResult SaveData(RequestVM D) { bool status = false; string mes = ""; var w = (from y in databaseManager.sUsers where y.UserID.ToString() == User.Identity.Name select new { y.PlantNo }).FirstOrDefault(); var wn = databaseManager.sPlants.Where(x => x.PlantNo == w.PlantNo).FirstOrDefault(); string s1 = w.PlantNo.ToString(); string s2 = string.Concat(s1 + "1000000"); int reqno = Convert.ToInt32(s2); var maxreqno = (from n in databaseManager.FrdRequestMasters where n.PlantID == w.PlantNo select n.ReqID).DefaultIfEmpty(reqno).Max(); var maxrNo = maxreqno + 1; int v = maxrNo; using (LIVEEntities ddd = new LIVEEntities()) { FrdRequestMaster dbo = new FrdRequestMaster(); { dbo.ReqID = maxrNo; dbo.PlantID = D.PlantID; dbo.DeptID = D.DeptID; dbo.ReqDate = DateTime.Today; dbo.CustomerID = Convert.ToInt32(User.Identity.Name); dbo.RefNo = D.RefNo; dbo.Remarks = D.Remarks; dbo.Status = "I"; dbo.CreateDate = DateTime.Now; dbo.CreateBy = User.Identity.Name; }; ddd.FrdRequestMasters.Add(dbo); foreach (var i in D.reqdtl) { FrdRequestDetail obd = new FrdRequestDetail(); { obd.PlantID = D.PlantID; obd.ReqID = maxrNo; obd.ItemID = i.ItemID; obd.Quantity = i.Quantity; obd.UnitPrice = 0; obd.TotalAmt = 0; ddd.FrdRequestDetails.Add(obd); } } ddd.SaveChanges(); status = true; ddd.Dispose(); ModelState.Clear(); } return(new JsonResult { Data = new { status = status, mes = mes, v = v } }); }
public ActionResult UserRight() { LIVEEntities db = new LIVEEntities(); ViewBag.UserID = new SelectList(db.sUsers, "UserID", "UserName"); //ViewBag.PageType = new SelectList(db.sPageNames, "PageType", "PageType"); var tCode = new SelectList( new[] { new { ID = 2, Name = "Reports" }, new { ID = 1, Name = "Forms" }, }, "ID", "Name" ); ViewBag.PageType = tCode; return(View("UserRight")); }
public ActionResult Create(FrdSupplier frdSupplier) { LIVEEntities db = new LIVEEntities(); try { if (ModelState.IsValid) { FrdSupplier sp = new FrdSupplier(); sp.SupplierID = frdSupplier.SupplierID; sp.SupplierCode = frdSupplier.SupplierCode; sp.SupplierName = frdSupplier.SupplierName; sp.SupplierAddress = frdSupplier.SupplierAddress; sp.PhoneNumber = frdSupplier.PhoneNumber; sp.MobileNumber = frdSupplier.MobileNumber; sp.EmailAddress = frdSupplier.EmailAddress; sp.ZoneCode = frdSupplier.ZoneCode; sp.BranchCode = frdSupplier.BranchCode; sp.Remarks = frdSupplier.Remarks; sp.VATRegNo = "222"; sp.Status = "ACT"; db.FrdSuppliers.Add(sp); db.SaveChanges(); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(RedirectToAction("Index")); }
public JsonResult GetMenuList(int inType) { using (LIVEEntities db = new LIVEEntities()) { try { var MenuData = db.sPageNames.Where(x => x.PageType == inType).ToList(); //var xv = MenuData.Count(); return(new JsonResult { Data = MenuData, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(Json(new { status = "error", message = "Not Assign" })); throw ex; } } }
public JsonResult GetProductData(int itemno) { string IDesc; try { using (LIVEEntities data = new LIVEEntities()) { var ii = (from x in data.FrdItems where x.ItemNo == itemno select x).FirstOrDefault(); IDesc = ii.ItemDescription; } return(new JsonResult { Data = IDesc, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(Json(new { status = "error", message = "ItemNot Found" })); throw ex; } }
public ActionResult CreateUser(UserReqVM user) { using (LIVEEntities db = new LIVEEntities()) { sUser nw = new sUser(); nw.UserID = user.UserID; nw.UserName = user.UserName; nw.UserPass = user.UserPass; nw.UserPin = user.UserPin; nw.RoleId = user.RoleId; nw.MobileNo = user.MobileNo; nw.PlantNo = user.PlantNo; nw.Email = user.Email; nw.UserStatus = "ACT"; nw.LoginType = "A"; nw.ActiveSession = 0; nw.CreateBy = User.Identity.Name; nw.CreateDate = DateTime.Now; db.sUsers.Add(nw); db.SaveChanges(); return(RedirectToAction("Index")); } }
// GET: UserManage public ActionResult Index() { LIVEEntities db = new LIVEEntities(); List <sRole> role = db.sRoles.ToList(); ViewBag.RoleID = new SelectList(db.sRoles, "RoleID", "RoleName"); var data = db.sPlants.Select(s => new { Text = s.PlantNo + "---" + s.PlantCode + " --- " + s.PlantName, Value = s.PlantNo }).ToList(); ViewBag.PlantNo = new SelectList(data, "Value", "Text"); int value = db.sUsers.Max(a => a.UserID); int num = value; sUser usr = new sUser { UserID = (num + 1), }; return(View(usr)); }
public ActionResult Login(LoginVM model, string returnUrl) { try { if (ModelState.IsValid) { var loginInfo = this.databaseManager.spUserLoginToApplication(model.UserID, model.UserPass, 0.ToString()).ToList(); if (loginInfo != null && loginInfo.Count() > 0) { // Initialization. var logindetails = loginInfo.First(); // Login In. // var sid = logindetails.UserName; var sid = logindetails.userId; this.SignInUser(sid.ToString(), false); // Info. // return this.RedirectToLocal(returnUrl); // for menu bool isExist = false; using (LIVEEntities dc = new LIVEEntities()) { isExist = dc.sUsers.Where(x => x.UserID == model.UserID).Any(); if (isExist) { LoginData loginCredentials = dc.sUsers.Where(x => x.UserID == model.UserID).Select(x => new LoginData { UserName = x.UserName, RoleId = x.RoleId, UserID = x.UserID }).FirstOrDefault(); List <MenuData> menus = dc.sUserPages.Where(x => x.RoleID == loginCredentials.RoleId && x.UserID == loginCredentials.UserID && x.Status == "ACT").Select(x => new MenuData { MenuID = x.sMenu.MenuID, MenuName = x.sMenu.MenuName, PageCode = x.PageCode, PageDescription = x.PageDescription, ContName = x.ContName, PageName = x.PageName, RoleId = x.RoleID, UserID = x.UserID, RoleName = x.sRole.RoleName }).ToList(); FormsAuthentication.SetAuthCookie(loginCredentials.UserID.ToString(), false); Session["LoginCredentials"] = loginCredentials; Session["MenuMaster"] = menus; Session["Name"] = loginCredentials.UserID; return(this.RedirectToLocal(returnUrl)); } else { ViewBag.ErrorMsg = "Please enter the valid credentials!..."; return(View("Index")); } } } else { // Setting. ModelState.AddModelError(string.Empty, "Invalid UserName or Password..Please check"); } } } catch (Exception ex) { // Info Console.Write(ex); } return(this.View(model)); }