public ActionResult AddColor() { if (Request.Form["dummyColor.Name"].Length > 0) { using (AppDBEntities context = new AppDBEntities()) { string color = Request.Form["dummyColor.Name"]; if ((from c in context.Colors where c.Name == color select c).Any()) throw new ApplicationException("Color already exists"); else { float price; if (!float.TryParse(Request.Form["dummyColor.Price"], out price)) price = 0f; context.Colors.Add(new Color() { Name = color, Price = price }); context.SaveChanges(); } } } return Content("OK"); }
public ActionResult SetPreference(int key, string strCityName) { cityDetail cityDetail = new cityDetail(); AppDBEntities ctx = new AppDBEntities(); var itemToRemove = ctx.cityDetails.SingleOrDefault(x => x.Citykey == key); //returns a single item. if (itemToRemove != null) { ctx.cityDetails.Remove(itemToRemove); ctx.SaveChanges(); } cityDetail.CityNAME = strCityName; cityDetail.Citykey = key; ctx.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); ctx.cityDetails.Add(cityDetail); ctx.SaveChanges(); return(RedirectToAction("Index")); }
// this will get a new user object created from the page public void AddAccount(AppUser newUser) { AppDBEntities db = new AppDBEntities(); db.AppUsers.Add(newUser); db.SaveChanges(); }
public ActionResult Details(int id) { using (var context = new AppDBEntities()) return View(OrderModel.CreateFromEntity(context.Orders .Where(order => order.Id.Equals(id)) .FirstOrDefault())); }
public ActionResult Edit(int id) { Customer customer; using (AppDBEntities db = new AppDBEntities()) { customer = db.Customers.Find(id); } return View(customer); }
// GET: /Test/ListAllCustomer public ActionResult ListAllCustomer() { var tenantDb = new TenantRegistryEntities(); var appDb = new AppDBEntities(UserProfileHelper.ResolveUserDBConnectionString()); var customers = appDb.Customers.ToList(); return(View(customers)); }
public void DeleteAccount(int userID) { AppDBEntities db = new AppDBEntities(); AppUser account = db.AppUsers.Where(a => a.userID == userID).FirstOrDefault(); db.AppUsers.Remove(account); db.SaveChanges(); }
public static IEnumerable<SelectListItem> GetStatuses() { using (var context = new AppDBEntities()) foreach (var status in context.States) yield return new SelectListItem { Text = status.Name, Value = status.Id.ToString() }; }
public static IEnumerable<SelectListItem> GetCustomers() { using (var context = new AppDBEntities()) foreach (var customer in context.Customers) yield return new SelectListItem { Value = customer.Id.ToString(), Text = string.Format("{0} {1} [{2}, {3}]", customer.Surname, customer.Name, customer.City, customer.Address) }; }
public static IEnumerable<SelectListItem> GetColors() { using (var context = new AppDBEntities()) foreach (var color in context.Colors) yield return new SelectListItem { Text = color.Name, Value = color.Id.ToString() }; }
public ActionResult Add(Customer newCustomer) { using (AppDBEntities db = new AppDBEntities()) { db.Customers.Add(newCustomer); db.SaveChanges(); } return RedirectToAction("Index", "Customers"); }
public void Index() { customers = new List<Customer>(); using (AppDBEntities db = new AppDBEntities()) { foreach (Customer c in db.Customers) { customers.Add(c); } } }
public ActionResult AddSeller() { MembershipCreateStatus mcs = MembershipCreateStatus.InvalidUserName; if (Request.Form["Username"].Length > 2 && Request.Form["Password"].Length > 7 && Request.Form["Name"].Length > 0 && Request.Form["Surname"].Length > 0) Membership.CreateUser(Request.Form["Username"], Request.Form["Password"], Request.Form["Username"]+"@empty", "Empty question", "Empty answer", true, out mcs); if (mcs != MembershipCreateStatus.Success) throw new ApplicationException("Error"); else { // Seller RoleId : 818a7a14-269d-4115-9f26-ac09a92f0b50 Guid guid = new Guid(Request.Form["role"]); using (MembershipDBEntities context = new MembershipDBEntities()) { string username = Request.Form["Username"]; var user = (from u in context.aspnet_Users where u.UserName == username select u).First(); var role = (from r in context.aspnet_Roles where r.RoleId == guid select r).First(); user.aspnet_Roles.Add(role); guid = user.UserId; context.SaveChanges(); } using (AppDBEntities context = new AppDBEntities()) { Seller seller = new Seller(); seller.Id_user = guid; seller.Name = Request.Form["Name"]; seller.Surname = Request.Form["Surname"]; seller.Id_branch = int.Parse(Request.Form["branch"]); context.Sellers.Add(seller); context.SaveChanges(); } } return Content("OK"); }
public ActionResult Edit(Customer customer) { using (AppDBEntities db = new AppDBEntities()) { Customer c = db.Customers.Find(customer.Id); c.Name = customer.Name; c.Surname = customer.Surname; c.Address = customer.Address; c.City = customer.City; db.SaveChanges(); } return RedirectToAction("Index", "Customers"); }
public JsonResult PutUser(string order) { bool isOrderOk; semaphore.Wait(); using (AppDBEntities AppDB = new AppDBEntities()) { var userModel = JsonConvert.DeserializeObject <User>(order); isOrderOk = AppDB.Simplevalidations(userModel); Users = AppDB.UpdateAndGetUsers(userModel, isOrderOk); } semaphore.Release(); return(Json(isOrderOk.ToString())); }
// GET: /Test/ListCustomer public ActionResult ListCustomer() { var tenantDb = new TenantRegistryEntities(); var appDb = new AppDBEntities(UserProfileHelper.ResolveUserDBConnectionString()); // Register Username and TenantId to memory UserProfileHelper.RegisterUserTenant(); // get tenant id from memory variable var tid = UserProfileHelper.UserTenantLookup[User.Identity.Name].ToString(); var customers = appDb.Customers.Where(c => c.TenantId == tid); return(View(customers)); }
public ActionResult ADDorEdit(Userlog usermodel) { using (AppDBEntities apmodel = new AppDBEntities()){ if (apmodel.Userlogs.Any(x => x.Username == usermodel.Username)) { ViewBag.DuplicateMessage = "Already exist"; return(View("ADDorEdit", usermodel)); } apmodel.Userlogs.Add(usermodel); apmodel.SaveChanges(); } ModelState.Clear(); ViewBag.sucessMessage = "Registration Completed"; return(View("ADDorEdit", new Userlog())); }
public ActionResult AddOrEdit(User userModel) { using (AppDBEntities dbModel = new AppDBEntities()) { if (dbModel.Users.Any(x => x.UserName == userModel.UserName)) { ViewBag.DuplicateMessage = "UserName alredy exit!"; return(View("AddOrEdit", userModel)); } dbModel.Users.Add(userModel); dbModel.SaveChanges(); } ModelState.Clear(); ViewBag.SuccessMessage = "Registration Successful."; return(View("AddOrEdit", new User())); }
public ActionResult Preference() { int key; string strCityName; AppDBEntities ctx = new AppDBEntities(); string sqlString = "SELECT VALUE ct FROM AppDBEntities.cityDetails " + "AS ct"; var objctx = (ctx as IObjectContextAdapter).ObjectContext; ObjectQuery <cityDetail> city = objctx.CreateQuery <cityDetail>(sqlString); cityDetail citypre = city.First <cityDetail>(); key = citypre.Citykey; strCityName = citypre.CityNAME; return(RedirectToAction("CitySelected", new { @key = key, @strCityName = strCityName })); }
public ActionResult Delete(int id) { using (AppDBEntities db = new AppDBEntities()) { var orders = from a in db.Orders where a.Id_customer == id select a; Customer customer = db.Customers.Find(id); foreach (var item in orders) { db.Orders.Remove(item); } db.Customers.Remove(customer); db.SaveChanges(); } return RedirectToAction("Index", "Customers"); }
public AppUser UpdateAccount(int userID, AppUser updatedAccount) { AppDBEntities db = new AppDBEntities(); AppUser account = db.AppUsers.Where(a => a.userID == userID).FirstOrDefault(); account.userName = updatedAccount.userName; account.passWord = updatedAccount.passWord; account.firstName = updatedAccount.firstName; account.lastName = updatedAccount.lastName; account.phoneNumber = updatedAccount.phoneNumber; account.birthDate = updatedAccount.birthDate; account.emailAddress = updatedAccount.emailAddress; account.paymentMethod = updatedAccount.paymentMethod; db.SaveChanges(); return(account); }
public ActionResult AddMake() { if (Request.Form["dummyMake.Name"].Length > 0) { using (AppDBEntities context = new AppDBEntities()) { string make = Request.Form["dummyMake.Name"]; if ((from m in context.Makes where m.Name == make select m).Any()) throw new ApplicationException("Make already exists"); else { context.Makes.Add(new Make() { Name = make }); context.SaveChanges(); } } } return Content("OK"); }
public ActionResult AddEquipment() { if (Request.Form["dummyEquipment.Name"].Length > 0) { using (AppDBEntities context = new AppDBEntities()) { string equipment = Request.Form["dummyEquipment.Name"]; if ((from e in context.Equipments where e.Name == equipment select e).Any()) throw new ApplicationException("Equipment already exists"); else { context.Equipments.Add(new Equipment() { Name = equipment }); context.SaveChanges(); } } } return Content("OK"); }
public JsonResult CountOrderPrice(int modelId, int equipmentPriceId) { float price = default(float); if (modelId > 0) { using (var context = new AppDBEntities()) { var basicModel = context.Models.Where(model => model.Id.Equals(modelId)).FirstOrDefault(); if (basicModel != null) price = basicModel.Price; if (equipmentPriceId > 0) price += context.EquipmentPrices .Where(equipmentPrice => equipmentPrice.Id.Equals(equipmentPriceId)) .Select(equipmentPrice => equipmentPrice.Price) .FirstOrDefault(); } } return Json(price); }
public JsonResult GetEquipmentsByModelId(int modelId) { if (modelId <= 0) return Json(null); using (var context = new AppDBEntities()) return Json(context.EquipmentPrices .Where(equipmentPrice => equipmentPrice.Id_model.Equals(modelId)) .Select(equipmentPrice => new { Id = equipmentPrice.Id, Value = equipmentPrice.Equipment.Name }) .ToList()); }
// // GET: /Offer/DeleteModel public ActionResult DeleteModel() { int param; if (int.TryParse(Request.QueryString["model"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Model model = (from m in context.Models where m.Id == param select m).First(); context.Models.Remove(model); context.SaveChanges(); } } return Content("OK"); }
public ActionResult AddModelEquipment() { int param; int param2; if (int.TryParse(Request.Form["model-id"], out param) && int.TryParse(Request.Form["equipment"], out param2)) { using (AppDBEntities context = new AppDBEntities()) { if ((from ep in context.EquipmentPrices where ep.Id_model == param && ep.Id_equipment == param2 select ep).Any()) throw new ApplicationException("Configuration already exists"); else { context.EquipmentPrices.Add(new EquipmentPrice() { Id_model = param, Id_equipment = param2, Price = 0f }); context.SaveChanges(); } } } return Content("OK"); }
public ActionResult SaveColor() { int param; if (int.TryParse(Request.Form["color-id"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Color color = (from c in context.Colors where c.Id == param select c).First(); color.Name = Request.Form["Name"]; color.Price = float.Parse(Request.Form["Price"]); context.SaveChanges(); } } return Content("OK"); }
// // GET: /Offer/DeleteColor public ActionResult DeleteColor() { int param; if (int.TryParse(Request.QueryString["color"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Color color = (from c in context.Colors where c.Id == param select c).First(); context.Colors.Remove(color); context.SaveChanges(); } } return Content("OK"); }
// // GET: /Sellers/DeleteSeller public ActionResult DeleteSeller() { Guid guid = new Guid(Request.QueryString["seller"]); using (MembershipDBEntities context = new MembershipDBEntities()) { var user = (from u in context.aspnet_Users where u.UserId == guid select u).First(); Membership.DeleteUser(user.UserName); } using (AppDBEntities context = new AppDBEntities()) { Seller seller = (from s in context.Sellers where s.Id_user == guid select s).First(); context.Sellers.Remove(seller); context.SaveChanges(); } return Content("OK"); }
// // GET: /Sellers/GetSellerDetails public ActionResult GetSellerDetails() { if (Request.QueryString["seller"] != "0") { Guid guid = new Guid(Request.QueryString["seller"]); using (AppDBEntities context = new AppDBEntities()) { Seller seller = (from s in context.Sellers where s.Id_user == guid select s).FirstOrDefault(); SellerModel model = new SellerModel(); model.UserId = (Guid)seller.Id_user; model.Name = seller.Name; model.Surname = seller.Surname; using (MembershipDBEntities context2 = new MembershipDBEntities()) { var user = (from s in context2.aspnet_Users where s.UserId == guid select s).FirstOrDefault(); model.Username = user.UserName; } if (seller != null) return PartialView("_SellerDetails", model); } } return Content("<h3>Edycja</h3><div class=\"row-clean\">Brak rekordu o wskazanym identyfikatorze</div>"); }
public ActionResult SaveSeller() { Guid guid = new Guid(Request.Form["seller-id"]); using (MembershipDBEntities context = new MembershipDBEntities()) { string username = Request.Form["username"]; string oldUsername = (from u in context.aspnet_Users where u.UserId == guid select u.UserName).First(); if (username != oldUsername && (from u in context.aspnet_Users where u.UserName == username select u).Any()) throw new ApplicationException("User already exists"); else { var user = (from u in context.aspnet_Users where u.UserId == guid select u).First(); user.UserName = username; user.LoweredUserName = username.ToLower(); Guid roleGuid = new Guid(Request.Form["role"]); var role = (from r in context.aspnet_Roles where r.RoleId == roleGuid select r).First(); user.aspnet_Roles.Clear(); user.aspnet_Roles.Add(role); context.SaveChanges(); } } using (AppDBEntities context = new AppDBEntities()) { Seller seller = (from s in context.Sellers where s.Id_user == guid select s).First(); seller.Name = Request.Form["Name"]; seller.Surname = Request.Form["Surname"]; seller.Id_branch = int.Parse(Request.Form["branch"]); context.SaveChanges(); } return Content("OK"); }
// // GET: /Offer/GetMakeDetails //[ChildActionOnly] - the method is used with AJAX, it can't be ChildAction public ActionResult GetMakeDetails() { int param; if (int.TryParse(Request.QueryString["make"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Make make = (from m in context.Makes where m.Id == param select m).FirstOrDefault(); if (make != null) return PartialView("_MakeDetails", make); } } return Content("<h3>Edycja</h3><div class=\"row-clean\">Brak rekordu o wskazanym identyfikatorze</div>"); }
// // GET: /Offer/DeleteEquipmentModel public ActionResult DeleteEquipmentModel() { int param; if (int.TryParse(Request.QueryString["equipment"], out param)) { using (AppDBEntities context = new AppDBEntities()) { EquipmentPrice equipmentPrice = (from ep in context.EquipmentPrices where ep.Id == param select ep).First(); context.EquipmentPrices.Remove(equipmentPrice); context.SaveChanges(); } } return Content("OK"); }
public IEnumerable <AppUser> GetAll() { AppDBEntities db = new AppDBEntities(); return(db.AppUsers); }
// // GET: /Offer/GetColorDetails public ActionResult GetColorDetails() { int param; if (int.TryParse(Request.QueryString["color"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Color color = (from c in context.Colors where c.Id == param select c).FirstOrDefault(); if (color != null) return PartialView("_ColorDetails", color); } } return Content("<h3>Edycja</h3><div class=\"row-clean\">Brak rekordu o wskazanym identyfikatorze</div>"); }
public ActionResult SaveMake() { int param; if (int.TryParse(Request.Form["make-id"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Make make = (from m in context.Makes where m.Id == param select m).First(); make.Name = Request.Form["Name"]; context.SaveChanges(); } } return Content("OK"); }
public ActionResult AddModel() { if (Request.Form["dummyModel.Name"].Length > 0) { using (AppDBEntities context = new AppDBEntities()) { string model = Request.Form["dummyModel.Name"]; int idMake = int.Parse(Request.Form["make"]); if ((from m in context.Models where (m.Name == model && m.Id_make == idMake) select m).Any()) throw new ApplicationException("Model already exists"); else { float price; if (!float.TryParse(Request.Form["dummyModel.Price"], out price)) price = 0f; context.Models.Add(new Model() { Id_make = idMake, Name = model, Price = price }); context.SaveChanges(); } } } return Content("OK"); }
public ActionResult SaveModel() { int param; if (int.TryParse(Request.Form["model-id"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Model model = (from m in context.Models where m.Id == param select m).First(); model.Name = Request.Form["CurrentModel.Name"]; model.Price = float.Parse(Request.Form["CurrentModel.Price"]); var equipmentPrices = (from ep in context.EquipmentPrices where ep.Id_model == param select ep); int epI; foreach (EquipmentPrice ep in equipmentPrices) { epI = int.Parse(Request.Form[string.Format("epid{0}", ep.Id)]); ep.Price = int.Parse(Request.Form[string.Format("EquipmentPricesList[{0}].Price", epI)]); } context.SaveChanges(); } } return Content("OK"); }
public ActionResult SaveEquipment() { int param; if (int.TryParse(Request.Form["equipment-id"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Equipment equipment = (from e in context.Equipments where e.Id == param select e).First(); equipment.Name = Request.Form["Name"]; context.SaveChanges(); } } return Content("OK"); }
// // GET: /Offer/GetEquipmentDetails public ActionResult GetEquipmentDetails() { int param; if (int.TryParse(Request.QueryString["equipment"], out param)) { using (AppDBEntities context = new AppDBEntities()) { Equipment equipment = (from e in context.Equipments where e.Id == param select e).FirstOrDefault(); if (equipment != null) return PartialView("_EquipmentDetails", equipment); } } return Content("<h3>Edycja</h3><div class=\"row-clean\">Brak rekordu o wskazanym identyfikatorze</div>"); }