private void PopulateArea()
{
var dataContext = new IndividualCounselingEntities();
var Area = dataContext.Area_Table
.Select(c => new AreaViewModel
{
AreaID = c.AreaID,
AreaName = c.AreaArName
})
.OrderBy(e => e.AreaID);
ViewData["Area"] = Area;
ViewData["defaultArea"] = Area.First();
}
private void PopulateGovernorate()
{
var dataContext = new IndividualCounselingEntities();
var Governorate = dataContext.Governorate_Table
.Select(c => new GovernorateViewModel
{
GovernorateID = c.GovernorateID,
GovernorateName = c.GovernorateArName
})
.OrderBy(e => e.GovernorateID);
ViewData["Governorate"] = Governorate;
ViewData["defaultGovernorate"] = Governorate.First();
}
public void PopulateProject()
{
var dataContext = new IndividualCounselingEntities();
var projects = dataContext.ProjectTable
.Select(c => new ProjectforeignKeyViewModel
{
ProjectID = c.ProjectID,
ProjectName = c.ProjectName
})
.OrderBy(e => e.ProjectID);
ViewData["projects"] = projects;
ViewData["defaultProject"] = projects.First();
}
public string ProjectName()
{
int H = 0;
H = int.Parse(Session["ProId"].ToString());
using (IndividualCounselingEntities entities = new IndividualCounselingEntities())
{
ProjectTable xx = entities.ProjectTable.Where(c => c.ProjectID == H)
.Select(i => i).Single();
ViewBag.ProjectName = xx.ProjectName.ToString();
}
return(ViewBag.ProjectName);
}
public void PopulateUsers()
{
// وهنا كمان لازم يكون نشيط حتى يتم ادراجه في المشاريع
var dataContext = new IndividualCounselingEntities();
var users = dataContext.Users_Table
.Select(c => new userforeignKeyViewModel
{
UserID = c.UserID,
FullName = c.FullName
})
.OrderBy(e => e.UserID);
ViewData["users"] = users;
ViewData["defaultUser"] = users.First();
}
public ActionResult Login(Users_Table user)
{
if (ModelState.IsValid)
{
try
{
using (IndividualCounselingEntities dc = new IndividualCounselingEntities())
{
// Check If Existed Or Not :
var u = dc.Users_Table.Single(i => i.UserName == user.UserName &&
i.Password == user.Password && i.Status == true);
if (u != null)
{
Session["UserID"] = u.UserID;
Session["UserName"] = u.FullName;
Session["Password"] = u.Password;
Session["UserType"] = u.UserType;
return(RedirectToAction("Index", "Home"));
// User Informations :
}
}
}
catch (Exception)
{
//اذا كان المستخدم اساسا مش موجود في جدول المستخدمين او كلمة المرور خطأ
ModelState.AddModelError("", "خطأ في الدخول للنظام");
}
}
return(View(user));
}
public SessionService(IndividualCounselingEntities entities)
{
this.entities = entities;
}
public ProjectControlService(IndividualCounselingEntities entities)
{
this.entities = entities;
}
public ProjectServices(IndividualCounselingEntities entities)
{
this.entities = entities;
}
public UserService(IndividualCounselingEntities entities)
{
this.entities = entities;
}
