public string getUserName(int id) { var context = new promoLacDbEntities(); var result = context.vendors.Where(x => x.vendorId == id).FirstOrDefault(); return(result.vendorUserName); }
public string vendorCompanyName(int id) { var context = new promoLacDbEntities(); var r = context.vendors.Where(x => x.vendorId == id).FirstOrDefault(); return(r.vendorCompanyName); }
public int getvendorId(string name) { var context = new promoLacDbEntities(); var y = context.vendors.Where(x => x.vendorUserName == name).FirstOrDefault(); return(y.vendorId); }
// GET: package public ActionResult packageDetails() { using (var context = new promoLacDbEntities()) { int id = vendorId(User.Identity.Name); packageModel details = new packageModel(); var subresult = context.userPackages.Where(x => x.vendorId == id).Select(y => new packageModel() { packagesId = y.packageId }).FirstOrDefault(); //details.detail = Getarea(1); var result = context.packages.Where(x => x.packagesId == subresult.packagesId).Select(x => new packageModel() { packageName = x.packageName, packageDurationDays = x.packageDurationDays, subUsersAllowed = x.subUsersAllowed, messagesAllowed = x.messagesAllowed, packageDescription = x.packageDescription, fencingHours = x.fencingHours, }).FirstOrDefault(); var r = context.userPackages.Where(x => x.vendorId == id).FirstOrDefault(); result.endtime = r.packageEndTime; return(View(result)); } }
/*========GET MEMBERS UNDER VENDOR==========*/ public ActionResult memberdetails() { using (var context = new promoLacDbEntities()) { int id = vendorId(User.Identity.Name); // subUserModel details = new subUserModel(); var myresult = context.vendors.Where(x => x.headId == id).Select(x => new userPackageModel() { vendorId = x.vendorId, userName = x.vendorUserName }).ToList(); foreach (userPackageModel x in myresult) { var t = context.userPackages.Where(z => z.vendorId == x.vendorId).FirstOrDefault(); x.packageId = t.packageId; x.dividedShareOfMessages = t.dividedShareOfMessages; x.notificationSent = t.notificationSent; x.dealsCreated = t.dealsCreated; x.fenceCreated = t.fenceCreated; x.detail = Getarea(x.vendorId); } return(View(myresult)); } }
public ActionResult editPackage(packageModel pck) { using (var context = new promoLacDbEntities()) { var myresult = context.packages.Where(x => x.packagesId == pck.packagesId).First(); myresult.packageName = pck.packageName; myresult.packageDescription = pck.packageDescription; myresult.messagesAllowed = pck.messagesAllowed; myresult.packageDurationDays = pck.packageDurationDays; context.SaveChanges(); List <packageModel> package_List = new List <packageModel>(); package_List = context.packages.Select(x => new packageModel { packageName = x.packageName, packagesId = x.packagesId, packageDescription = x.packageDescription, packageDurationDays = x.packageDurationDays, messagesAllowed = x.messagesAllowed, subUsersAllowed = x.subUsersAllowed }).ToList(); return(View("viewAllPackage", package_List)); } }
public ActionResult createPackage(packageModel pckg) { using (var context = new promoLacDbEntities()) { package p = new package(); p.packageName = pckg.packageName; p.packageDescription = pckg.packageDescription; p.packageDurationDays = pckg.packageDurationDays; p.subUsersAllowed = pckg.subUsersAllowed; context.packages.Add(p); context.SaveChanges(); List <packageModel> package_List = new List <packageModel>(); package_List = context.packages.Select(x => new packageModel { packageName = x.packageName, packagesId = x.packagesId, packageDescription = x.packageDescription, packageDurationDays = x.packageDurationDays, messagesAllowed = x.messagesAllowed, subUsersAllowed = x.subUsersAllowed }).ToList(); return(View("viewAllPackage", package_List)); } }
public ActionResult addArea(vendorViewModel vendor) { using (var context = new promoLacDbEntities()) { return(View()); } }
public int getDealCategoryId(string name) { var context = new promoLacDbEntities(); var y = context.dealCategories.Where(x => x.categoryName == name).FirstOrDefault(); return(y.categoryId); }
public ActionResult addArea(int vendor_id) { using (var context = new promoLacDbEntities()) { vendorViewModel vendorObject = new vendorViewModel(); var areasList = context.areas.Select(x => new areaModel { areaId = x.areaId, areaName = x.areaName, areaHashCode = x.areaHashCode }).ToList(); List <areaModel> area_ids = getvendorAreas(vendor_id); foreach (areaModel x in areasList.ToList()) { foreach (var z in area_ids) { if (x.areaName.Equals(z.areaName)) { areasList.Remove(x); } } } vendorObject.detail = areasList; vendorObject.vendorUserName = getVendorUserName(vendor_id); return(View(vendorObject)); } }
public ActionResult viewAllVendors() { using (var context = new promoLacDbEntities()) { var v = context.vendors.Select(x => new vendorViewModel() { vendorId = x.vendorId, firstName = x.firstName, lastName = x.lastName, phoneNumber = x.phoneNumber, vendorEmail = x.vendorEmail, vendorAddress = x.vendorAddress, registerTimestamp = x.registerTimestamp, vendorUserName = x.vendorUserName, vendorPackageTaken = x.vendorPackageTaken, vendorCompanyName = x.vendorCompanyName }).ToList(); foreach (vendorViewModel x in v) { x.vendorAreaDetail = getAreas(x.vendorId); } TempData["VendorDetails"] = v; return(View(v)); } }
public ActionResult EditVendor(int id) { if (id.Equals(null)) { viewAllVendors(); return(View()); } else { var context = new promoLacDbEntities(); // List<vendorViewModel> V = TempData["VendorDetails"] as List<vendorViewModel>; //TempData["VendorDetails"] = V; vendorViewModel z = new vendorViewModel(); z = context.vendors.Where(x => x.vendorId == id).Select(y => new vendorViewModel { vendorId = y.vendorId, vendorEmail = y.vendorEmail, vendorPackageTaken = y.vendorPackageTaken, vendorUserName = y.vendorUserName, vendorAddress = y.vendorAddress, phoneNumber = y.phoneNumber }).FirstOrDefault(); z.vendorAreaDetail = getAreas(z.vendorId); return(View(z)); } }
public ActionResult login(vendorModel model) { using (var context = new promoLacDbEntities()) { bool isvalidVendor = context.vendors.Any(x => x.vendorUserName == model.vendorUserName && x.vendorPassword == model.vendorPassword); if (isvalidVendor) { FormsAuthentication.SetAuthCookie(model.vendorUserName, false); int id = vendorId(model.vendorUserName); var result = context.userPackages.Where(x => x.vendorId == id).FirstOrDefault(); int comp = DateTime.Compare(result.packageEndTime, DateTime.Now); if (comp < 0) { result.packageStatus = "NotActive"; context.SaveChanges(); ModelState.AddModelError("", "Package Expired"); } else { return(RedirectToAction("controlPanel", "controlPanel")); } } else { ModelState.AddModelError("", "Invalid User Name and Password"); } } return(View()); }
public int getAreaId(string name) { var context = new promoLacDbEntities(); var x = context.areas.Where(z => z.areaName == name).FirstOrDefault(); return(x.areaId); }
public string getAreaHashcode(int id) { using (var context = new promoLacDbEntities()) { var x = context.areas.Where(y => y.areaId == id).FirstOrDefault(); return(x.areaHashCode); } }
public List <notification> getNotificationList(int id) { var context = new promoLacDbEntities(); var r = context.notifications.Where(x => x.vendorId == id).ToList(); return(r); }
public List <deal> getDealList(int id) { var context = new promoLacDbEntities(); var r = context.deals.Where(x => x.vendorId == id).ToList(); return(r); }
public List <fence> getFenceList(int id) { var context = new promoLacDbEntities(); var r = context.fences.Where(x => x.vendorId == id).ToList(); return(r); }
/* ===================================================== * * Getter Setter functions * * ======================================================*/ public int getAdminId(string name) { using (var context = new promoLacDbEntities()) { var v = context.mainAdmins.Where(x => x.username == name).FirstOrDefault(); return(v.id); } }
public void updateFencingHours(int id, int hr) { var context = new promoLacDbEntities(); var result = context.userPackages.Where(x => x.vendorId == id).FirstOrDefault(); result.remainingFencingHours = result.remainingFencingHours - hr; result.fenceCreated = result.fenceCreated + 1; context.SaveChanges(); }
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 int getVendorId(string name) { using (var context = new promoLacDbEntities()) { var v = context.vendors.Where(x => x.vendorUserName == name).FirstOrDefault(); int id = v.vendorId; return(id); } }
public string getVendorUserName(int id) { using (var context = new promoLacDbEntities()) { var v = context.vendors.Where(x => x.vendorId == id).FirstOrDefault(); string name = v.vendorUserName; return(name); } }
public int getAreaId(string name) { using (var context = new promoLacDbEntities()) { var v = context.areas.Where(x => x.areaName == name).FirstOrDefault(); int id = v.areaId; return(id); } }
public void removeArea(int area_id, int vendor_id) { using (var context = new promoLacDbEntities()) { var myresult = context.areaAssigneds.Where(x => (x.areaId == area_id) && (x.vendorId == vendor_id)).First(); context.areaAssigneds.Remove(myresult); context.SaveChanges(); } EditVendor(vendor_id); }
public ActionResult updateVendorPackage(vendorViewModel v) { using (var context = new promoLacDbEntities()) { var result = context.vendors.Where(x => x.vendorId == v.vendorId).FirstOrDefault(); result.vendorPackageTaken = v.vendorPackageTaken; context.SaveChanges(); return(View("viewAllVendors")); } }
public ActionResult addVendor(vendorViewModel v) { using (var context = new promoLacDbEntities()) { var packagesdetails = context.packages.ToList(); v.package_details = packagesdetails; TempData["vendorObject"] = v; return(View("AddCompleteVendorInfo", v)); } }
// GET: deals public ActionResult createDeal() { var context = new promoLacDbEntities(); var y = context.dealCategories.ToList(); dealsModel x = new dealsModel(); x.dealCategoryLists = y; return(View(x)); }
public int messagesAllowed(int z) { using (var context = new promoLacDbEntities()) { var result = context.packages.Where(x => x.packagesId == z).Select(x => new packageModel() { messagesAllowed = x.messagesAllowed }).FirstOrDefault(); return(result.messagesAllowed); } }
public int vendorId(string name) { using (var context = new promoLacDbEntities()) { var result = context.vendors.Where(x => x.vendorUserName == name).Select(x => new vendorModel() { vendorId = x.vendorId }).FirstOrDefault(); return(result.vendorId); } }