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