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