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>");
}
