public ActionResult Create(vendorModel user) { using (var context = new promoLacDbEntities()) { { vendor info = new vendor() { firstName = user.firstName, lastName = user.lastName, vendorEmail = user.vendorEmail, vendorPassword = user.vendorPassword, registerTimestamp = DateTime.Now, phoneNumber = user.phoneNumber, vendorUserName = user.vendorUserName, headId = vendorId(User.Identity.Name), isHead = "N", vendorStatus = "A", vendorAddress = vendorAddress(vendorId(User.Identity.Name)), vendorCompanyName = vendorCompanyName(vendorId(User.Identity.Name)) }; context.vendors.Add(info); context.SaveChanges(); var result = context.userPackages.Where(x => x.vendorId == info.headId).FirstOrDefault(); userPackage u = new userPackage(); u.vendorId = vendorId(user.vendorUserName); u.packageStartTime = result.packageStartTime; u.packageEndTime = result.packageEndTime; u.packageId = result.packageId; u.dividedShareOfMessages = user.messagesAllowed; u.packageStatus = "active"; u.notificationSent = 0; u.remainingFencingHours = user.fencingHours; context.userPackages.Add(u); context.SaveChanges(); foreach (var x in user.areas) { areaAssigned ar = new areaAssigned() { vendorId = vendorId(user.vendorUserName), areaId = Convert.ToInt32(x) }; context.areaAssigneds.Add(ar); context.SaveChanges(); } var result1 = context.userPackages.Where(x => x.vendorId == info.headId).FirstOrDefault(); result1.dividedShareOfMessages = result1.dividedShareOfMessages - user.messagesAllowed; result1.remainingFencingHours = result1.remainingFencingHours - user.fencingHours; context.SaveChanges(); } return(RedirectToAction("../ControlPanel/ControlPanel")); } }
public ActionResult Addarea(areaAssignedModel u) { using (var context = new promoLacDbEntities()) { areaAssigned a = new areaAssigned() { vendorId = u.vendorId, areaId = 1 }; context.areaAssigneds.Add(a); context.SaveChanges(); } return(RedirectToAction("../controlPanel/controlPanel")); }
public ActionResult AddCompleteVendorInfo(vendorViewModel v) { vendorViewModel v1 = TempData["vendorObject"] as vendorViewModel; v1.vendorPackageTaken = v.vendorPackageTaken; using (var context = new promoLacDbEntities()) { vendor ven = new vendor() { firstName = v1.firstName, lastName = v1.lastName, phoneNumber = v1.phoneNumber, vendorEmail = v1.vendorEmail, vendorAddress = v1.vendorAddress, registerTimestamp = DateTime.Now, vendorUserName = v1.vendorUserName, vendorPassword = v1.vendorPassword, vendorBirthDate = DateTime.Now, vendorStatus = "A", vendorAdminId = getAdminId(User.Identity.Name), vendorPackageTaken = v1.vendorPackageTaken, isAdmin = v1.isAdmin, vendorCompanyName = v1.vendorCompanyName }; context.vendors.Add(ven); context.SaveChanges(); int id = getVendorId(v1.vendorUserName); foreach (var item in v1.area_vendor) { areaAssigned ar = new areaAssigned() { vendorId = id, areaId = Convert.ToInt32(item) }; context.areaAssigneds.Add(ar); context.SaveChanges(); } return(RedirectToAction("viewAllVendors")); } }