public JsonResult SaveData(SiteUser model) { model.IsValid = false; db.SiteUsers.Add(model); db.SaveChanges(); BuildEmailTemplate(model.ID); return(Json("Registration Successfull", JsonRequestBehavior.AllowGet)); }
// Save data in the product database public JsonResult CreateStore(StoreViewModel storeViewModel) { Store store = new Store(); store.Name = storeViewModel.Name; store.Address = storeViewModel.Address; db.Stores.Add(store); db.SaveChanges(); return(Json(storeViewModel, JsonRequestBehavior.AllowGet)); }
// Save data in the product database public JsonResult CreateProduct(ProductViewModel productViewModel) { Product product = new Product(); product.Name = productViewModel.Name; product.Price = productViewModel.Price; db.Products.Add(product); db.SaveChanges(); return(Json(productViewModel, JsonRequestBehavior.AllowGet)); }
// Save data in the Customer database public JsonResult CreateCustomer(CustomerViewModel customerViewModel) { Customer customer = new Customer(); customer.Name = customerViewModel.Name; customer.Address = customerViewModel.Address; db.Customers.Add(customer); db.SaveChanges(); return(Json(customerViewModel, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "ID,Name,Gender,Email,Salary")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "OrderId,CommodityID,CommodityAmount")] SellOrder sellOrder) { if (ModelState.IsValid) { db.SellOrders.Add(sellOrder); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sellOrder)); }
public ActionResult Create([Bind(Include = "CommodityId,CommodityName,CommodityPrice,CommodityAmount,CommodityImage,CommodityType")] Commodity commodity) { if (ModelState.IsValid) { db.Commodities.Add(commodity); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(commodity)); }
public ActionResult Create([Bind(Include = "Email,Name,Password,Status,Rank")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Create([Bind(Include = "id,Name,City,Age")] Dbfirstapproach dbfirstapproach) { if (ModelState.IsValid) { db.Dbfirstapproach.Add(dbfirstapproach); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dbfirstapproach)); }
// POST: ProductSolds/Create public JsonResult CreateSales(SalesViewModel salesViewModel) { ProductSold sales = new ProductSold(); sales.CustomerID = salesViewModel.CustomerID; sales.ProductID = salesViewModel.ProductID; sales.StoreID = salesViewModel.StoreID; sales.DateSold = salesViewModel.DateSold; db.ProductSolds.Add(sales); db.SaveChanges(); return(Json(salesViewModel, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(MemberModel model) { string FileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName); string FileExtension = Path.GetExtension(model.ImageFile.FileName); FileName = DateTime.Now.ToString("yyyyMMdd") + "-" + FileName.Trim() + FileExtension; string UploadPath = ConfigurationManager.AppSettings["UserUploadPath"].ToString(); model.ImagePath = UploadPath + FileName; model.ImageFile.SaveAs(model.ImagePath); tblMember member = new tblMember(); member.ImagePath = model.ImagePath; member.MemberName = model.Name; member.PhoneNumber = model.PhoneNumber; using (MVCEntities entities = new MVCEntities()) { entities.tblMembers.Add(member); entities.SaveChanges(); } return(View()); }
public ActionResult AddProducts(Product product) { if (ModelState.IsValid) { Product newProduct = new Product { Name = product.Name, Price = product.Price }; db.Products.Add(newProduct); db.SaveChanges(); } var allProducts = db.Products.Select(x => new { x.Id, x.Name, x.Price }).ToList(); return(Json(new { allProducts, success = "true" }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddCustomers(Customer customer) { if (ModelState.IsValid) { Customer newCustomer = new Customer { Name = customer.Name, Address = customer.Address }; db.Customers.Add(newCustomer); db.SaveChanges(); } var allCustomers = db.Customers.Select(x => new { x.Id, x.Name, x.Address }).ToList(); return(Json(new { allCustomers, success = "true" }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddStores(Store store) { if (ModelState.IsValid) { Store newStore = new Store { Name = store.Name, Address = store.Address }; db.Stores.Add(newStore); db.SaveChanges(); } var allStores = db.Stores.Select(x => new { x.Id, x.Name, x.Address }).ToList(); return(Json(new { allStores, success = "true" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int id) { MVCEntities db = new MVCEntities(); var data = db.employees.Where(x => x.id == id).First(); db.employees.Remove(data); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddSales(Sale sale) { if (ModelState.IsValid) { Sale newSale = new Sale { CustomerId = sale.CustomerId, ProductId = sale.ProductId, StoreId = sale.StoreId, DateSold = sale.DateSold }; db.Sales.Add(newSale); db.SaveChanges(); } //var allSales = db.Sales.Select(x => new { x.CustomerId, x.ProductId, x.StoreId, x.DateSold }).ToList(); return(Json(new { /*allSales,*/ success = "true" }, JsonRequestBehavior.AllowGet)); }
public ActionResult SignUp(string Email, string Name, string Password) { User user = db.Users.Find(Email); if (user != null) { ViewBag.ErrorMessage = "User already exist!"; return(View("SignUp")); } user = new User(); user.Email = Email; user.Name = Name; user.Password = Password; user.Rank = 1; user.Status = 1; db.Users.Add(user); db.SaveChanges(); return(View("Index")); }
public ActionResult Create([Bind(Include = "PurchaseOrderId,CommodityId,CommodityAmount")] PurchaseOrder purchaseOrder) { if (ModelState.IsValid) { db.PurchaseOrders.Add(purchaseOrder); db.SaveChanges(); } ViewBag.PurchaseOrderId = purchaseOrder.PurchaseOrderId; ViewBag.ID = GetCommodityID(); ViewBag.Commodity = GetCommodityFromOrder(purchaseOrder.PurchaseOrderId); Commodity cc = db.Commodities.Find(purchaseOrder.CommodityId); cc.CommodityAmount += purchaseOrder.CommodityAmount; db.SaveChanges(); //foreach (var item in commdity.ToList()) //{ // System.Diagnostics.Debug.WriteLine(item.CommodityName); //} return(View(purchaseOrder)); }
public ActionResult Register(Register register) { db.Registers.Add(register); int i = db.SaveChanges(); if (i > 0) { return(RedirectToAction("Login")); } else { return(View(register)); } }
public ActionResult Edit(employee model) { MVCEntities db = new MVCEntities(); if (ModelState.IsValid) { var data = db.employees.Where(x => x.id == model.id).First(); data.Name = model.Name; data.Gender = model.Gender; data.Email = model.Email; data.Age = model.Age; db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public ActionResult Insertdetails(Mysite ms) { using (var dbctx = new MVCEntities()) { dbctx.tbl_site.Add(new tbl_site { username = ms.username, city = ms.city, state = ms.state, country = ms.country }); dbctx.SaveChanges(); } return(RedirectToAction("DisplayAll")); }
public ActionResult InsertEmployee(EmployeeModel model) { try { MVCEntities db = new MVCEntities(); employee employ = new employee(); employ.Name = model.Name; employ.Gender = model.Gender; employ.Email = model.Email; employ.Age = model.Age; db.employees.Add(employ); db.SaveChanges(); } catch (Exception ex) { throw ex; } return(RedirectToAction("Index")); }
public ActionResult Registration(UserDb u) { if (ModelState.IsValid) { #region//Email is already Exist var isExist = IsEmailExist(u.EmailID); if (isExist) { ViewBag.emailexist = "email already exist"; return(View(u)); } #endregion } #region //save to database using (MVCEntities dc = new MVCEntities()) { dc.UserDbs.Add(u); dc.SaveChanges(); } #endregion ViewBag.success = "registered successful"; return(View(u)); }
public void Save() { _context.SaveChanges(); }