public ActionResult Create(string name, string locationLongitude, string locationLatitude)
{
PickUpPoint pickUpPoint = new PickUpPoint(name, double.Parse(locationLongitude), double.Parse(locationLatitude));
db.PickUpPoints.Add(pickUpPoint);
db.SaveChanges();
return(Json(new { Success = true }));
}
public ActionResult Delete(string id)
{
PickUpPoint pickUpPoint = db.PickUpPoints.Find(int.Parse(id));
pickUpPoint.IsDeleted = true;
db.SaveChanges();
return(Json(new { Success = true }));
}
public async static Task <PickUpPoint> GetPickupPointByDepartment(int departmentId)
{
using (var ctx = new UniDBContext())
{
PickUpPoint point = ctx.Departments.Include("PickupPoint").Where(d => d.DepartmentId == departmentId).Select(d => d.PickupPoint).SingleOrDefault();
return(point);
}
}
public ActionResult Update(string id, string name, string locationLongitude, string locationLatitude)
{
PickUpPoint pickUpPoint = db.PickUpPoints.Find(int.Parse(id));
pickUpPoint.Name = name;
pickUpPoint.LocationLongitude = double.Parse(locationLongitude);
pickUpPoint.LocationLatitude = double.Parse(locationLatitude);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void PopulatePoints(UniDBContext ctx)
{
PickUpPoint p1 = new PickUpPoint()
{
Location = "Stationery Store - Administration Building",
PickUpTime = "9:30 AM"
};
PickUpPoint p2 = new PickUpPoint()
{
Location = "Management school",
PickUpTime = "11:00 AM"
};
PickUpPoint p3 = new PickUpPoint()
{
Location = "Medical School",
PickUpTime = "9:30 AM"
};
PickUpPoint p4 = new PickUpPoint()
{
Location = "Engineering School",
PickUpTime = "11:00 AM"
};
PickUpPoint p5 = new PickUpPoint()
{
Location = "Science School",
PickUpTime = "9:30 AM"
};
PickUpPoint p6 = new PickUpPoint()
{
Location = "University Hostpital",
PickUpTime = "11:00 AM"
};
ctx.PickUpPoints.Add(p1);
ctx.PickUpPoints.Add(p2);
ctx.PickUpPoints.Add(p3);
ctx.PickUpPoints.Add(p4);
ctx.PickUpPoints.Add(p5);
ctx.PickUpPoints.Add(p6);
ctx.SaveChanges();
}
public async Task <ActionResult> Delegate()
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
Task <User> representativeTask = UserDao.GetRepresentative(departmentId);
Task <List <User> > allEmployeesTask = UserDao.GetAllEmployeesFromDepartment(departmentId);
Task <User> temporaryHeadTask = UserDao.GetTemporaryHeadByDepartment(departmentId);
Task <List <PickUpPoint> > pickUpPointsTask = PickUpPointDao.GetAllPickupPoints();
Task <PickUpPoint> getCurrentPickupTask = PickUpPointDao.GetPickupPointByDepartment(departmentId);
User user = await representativeTask;
List <User> users = await allEmployeesTask;
User temporaryHead = await temporaryHeadTask;
List <PickUpPoint> points = await pickUpPointsTask;
PickUpPoint point = await getCurrentPickupTask;
ViewData["Employees"] = users;
ViewData["CurrentRepresentative"] = user;
ViewData["TemporaryHead"] = temporaryHead;
ViewData["PickUpPoints"] = points;
ViewData["CurrentPickUpPoint"] = point;
return(View("Index"));
}
public async Task <ActionResult> PickUpPointMobile()
{
List <object> result = new List <object>();
int rank = Convert.ToInt32(RouteData.Values["rank"]);
if (rank == 0 || rank == 5)
{
int departmentId = Convert.ToInt32(RouteData.Values["departmentId"]);
Task <List <PickUpPoint> > pickUpPointsTask = PickUpPointDao.GetAllPickupPoints();
Task <PickUpPoint> getCurrentPickupTask = PickUpPointDao.GetPickupPointByDepartment(departmentId);
List <PickUpPoint> points = await pickUpPointsTask;
PickUpPoint point = await getCurrentPickupTask;
points.Add(point);
return(Json(points, JsonRequestBehavior.AllowGet));
}
else
{
var failAuth = new { result = 0 };
result.Add(failAuth);
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
protected override void Seed(UniDBContext context)
{
Populate p = new Populate();
context.Items.AddRange(p.getClips());
context.Items.AddRange(p.getEnvelopes());
context.Items.AddRange(p.getErasers());
context.Items.AddRange(p.getExercises());
context.Items.AddRange(p.getFiles());
context.Items.AddRange(p.getPens());
context.Items.AddRange(p.getPunchers());
context.Items.AddRange(p.getPads());
context.Items.AddRange(p.getPapers());
context.Items.AddRange(p.getRulersAndScissor());
context.Items.AddRange(p.getTapesAndSharpener());
context.Items.AddRange(p.getShorthands());
context.Items.AddRange(p.getStaplers());
context.Items.AddRange(p.getTackAndTrays());
context.Items.AddRange(p.getTparency());
context.SaveChanges();
List <Item> items = context.Items.ToList();
foreach (var i in items)
{
i.Quantity = 100;
}
context.SaveChanges();
PopulateUser u = new PopulateUser();
u.populateUsers(context);
PopulateSupplier sup = new PopulateSupplier();
sup.populateSuppliers(context);
PopulatePickUpPoint.PopulatePoints(context);
User storeclerk1 = context.Users.Where(us => us.Username == "storeclerk1").SingleOrDefault();
List <PickUpPoint> pts1 = context.PickUpPoints.Where(pi => pi.PickUpPointId == 1 || pi.PickUpPointId == 2).ToList();
storeclerk1.PickUpPoints = pts1;
User storeclerk2 = context.Users.Where(us => us.Username == "storeclerk2").SingleOrDefault();
List <PickUpPoint> pts2 = context.PickUpPoints.Where(pi => pi.PickUpPointId == 3 || pi.PickUpPointId == 4).ToList();
storeclerk2.PickUpPoints = pts2;
User storeclerk3 = context.Users.Where(us => us.Username == "storeclerk3").SingleOrDefault();
List <PickUpPoint> pts3 = context.PickUpPoints.Where(pi => pi.PickUpPointId == 5 || pi.PickUpPointId == 6).ToList();
storeclerk3.PickUpPoints = pts3;
List <Department> allDepartments = context.Departments.ToList();
PickUpPoint pick = context.PickUpPoints.Where(pi => pi.PickUpPointId == 1).SingleOrDefault();
foreach (var d in allDepartments)
{
d.PickupPoint = pick;
}
User csE1 = context.Users.Include("Department").Where(us => us.Username == "cse1").SingleOrDefault();
Department csDep = csE1.Department;
csDep.Representative = csE1;
context.SaveChanges();
base.Seed(context);
}
