public void FamilyInfo() { int h = 0; h = int.Parse(Session["familyformID"].ToString()); try { using (LawyersEntities dc = new LawyersEntities()) { // Check If Existed Or Not : var u = dc.FamilyForum_Table.Single(i => i.FamilyForumID == h ); if (u != null) { ViewBag.ApplicantName = u.ApplicantName; ViewBag.CustodialName = u.CustodialName; } } } catch (Exception) { //اذا كان المستخدم اساسا مش موجود في جدول المستخدمين او كلمة المرور خطأ ModelState.AddModelError("", "خطأ في الدخول للنظام"); } }
// GET: Order public ActionResult Order(string projectid) { Session["Projectid"] = int.Parse(projectid.ToString()); int proid = int.Parse(Session["Projectid"].ToString()); int UserID = int.Parse(Session["UserID"].ToString()); if ((string)Session["UserType"] != "1") { try { using (LawyersEntities dc = new LawyersEntities()) { // Check If Existed Or Not : var u = dc.ProjectControl_Table.Single(i => i.UserID == UserID && i.ProjectID == proid && i.Status == true); if (u != null) { ViewBag.CurrentUser = true; } } } catch (Exception) { ViewBag.CurrentUser = false; } } PopulateIssuesType(); PopulateUsers(); PopulateTypeOfCase(); PopulateCourts(); PopulateGovernorate(); PopulateArea(); return(View()); }
private static IEnumerable <CoursesViewModel> GetOrders() { var entities = new LawyersEntities(); return(entities.Courses_Table .Select(db => new CoursesViewModel { CoursesID = db.CoursesID, CoursesName = db.CoursesName, CoursesStartDate = db.CoursesStartDate.HasValue ? db.CoursesStartDate.Value : default(DateTime), CoursesEndDate = db.CoursesEndDate.HasValue ? db.CoursesEndDate.Value : default(DateTime), TotalSessions = db.TotalSessions, TrainingHours = db.TrainingHours, TotalBeneficiaries = db.TotalBeneficiaries, Males = db.Males, Females = db.Females, UserID = db.UserID, Users = new UsersForeignkey() { UserID = db.Users_Table.UserID, FullName = db.Users_Table.FullName, }, TargetGroupID = db.TargetGroupID, TargetGroup = new TargetGroupFroingKey() { TargetGroupID = db.TargetGroup_Table.TargetGroupID, TargetGroupName = db.TargetGroup_Table.TargetGroupName, }, ProjectID = db.ProjectID, })); }
// GET: Advocacyactivities public ActionResult Advocacy(string projectid) { Session["Projectid"] = int.Parse(projectid.ToString()); int proid = int.Parse(Session["Projectid"].ToString()); int UserID = int.Parse(Session["UserID"].ToString()); #region (تأكيد اذا كان المستخدم تابع لمشروع) if ((string)Session["UserType"] != "1") { try { using (LawyersEntities dc = new LawyersEntities()) { // Check If Existed Or Not : var u = dc.ProjectControl_Table.Single(i => i.UserID == UserID && i.ProjectID == proid && i.Status == true); if (u != null) { ViewBag.CurrentUser = true; } } } catch (Exception) { ViewBag.CurrentUser = false; } } #endregion PopulateUsers(); return(View()); }
private static IEnumerable <BeneficiariesForeignkey> GetBeneficiaries() { var northwind = new LawyersEntities(); return(northwind.Beneficiaries_Table.Select(order => new BeneficiariesForeignkey { BeneficiariesIDNumber = order.BeneficiariesIDNumber, BeneficiariesName = order.BeneficiariesName, Beneficiaries_ID = order.Beneficiaries_ID })); }
public JsonResult GetGovernorate() { var northwind = new LawyersEntities(); var province = northwind.Governorate_Table.Select(db => new GovernorateForeignkey { Governorate_ID = db.Governorate_ID, Governorate_Name = db.Governorate_Name }); return(Json(province, JsonRequestBehavior.AllowGet)); }
private void PopulateIssuesType() { var dataContext = new LawyersEntities(); var IssuesType = dataContext.IssuesType_Table .Select(c => new IssuesTypeForeingKey { IssuesTypeID = c.IssuesTypeID, IssuesTypename = c.IssuesTypename }) .OrderBy(e => e.IssuesTypeID); ViewData["IssuesType"] = IssuesType; ViewData["defaultIssuesType"] = IssuesType.First(); }
public void PopulateProject() { var dataContext = new LawyersEntities(); var Project = dataContext.Project_Table .Select(c => new ProjectForeignkey { ProjectID = c.ProjectID, ProjectName = c.ProjectName }) .OrderBy(e => e.ProjectID); ViewData["Project"] = Project; ViewData["defaultProject"] = Project.First(); }
public void PopulateLawyer() { var dataContext = new LawyersEntities(); var Lawyer = dataContext.Lawyer_Table .Select(c => new LawyerForeignkey { LawyerID = c.LawyerID, LawyerName = c.LawyerName }) .OrderBy(e => e.LawyerID); ViewData["Lawyer"] = Lawyer; ViewData["defaultLawyer"] = Lawyer.First(); }
public JsonResult GetArea(int Governorate_ID) { var northwind = new LawyersEntities(); var province = northwind.Area_Table.Where(m => m.Governorate_ID == Governorate_ID).Select(db => new AreaForeignkey { Area_ID = db.Area_ID, Area_Name = db.Area_Name }); return(Json(province, JsonRequestBehavior.AllowGet)); }
public void PopulateUsers() { var dataContext = new LawyersEntities(); var users = dataContext.Users_Table .Select(c => new UsersForeignkey { UserID = c.UserID, FullName = c.FullName }) .OrderBy(e => e.UserID); ViewData["users"] = users; ViewData["defaultUser"] = users.First(); }
public void PopulateTargetGroup() { var dataContext = new LawyersEntities(); var TargetGroup = dataContext.TargetGroup_Table .Select(c => new TargetGroupFroingKey { TargetGroupID = c.TargetGroupID, TargetGroupName = c.TargetGroupName }) .OrderBy(e => e.TargetGroupID); ViewData["TargetGroup"] = TargetGroup; ViewData["defaultTargetGroup"] = TargetGroup.First(); }
public void PopulateGovernorate() { var dataContext = new LawyersEntities(); var Governorate = dataContext.Governorate_Table .Select(c => new GovernorateForeignkey { Governorate_ID = c.Governorate_ID, Governorate_Name = c.Governorate_Name }) .OrderBy(e => e.Governorate_ID); ViewData["Governorate"] = Governorate; ViewData["defaultGovernorate"] = Governorate.First(); }
public void PopulateTypeOfCase() { var dataContext = new LawyersEntities(); var typeOfcase = dataContext.TypeOfCase_Table .Select(c => new TypeOfCaseForeignkey { TypeOfCaseID = c.TypeOfCase_ID, TypeOfCase = c.TypeOfCaseName }) .OrderBy(e => e.TypeOfCaseID); ViewData["typeOfcase"] = typeOfcase; ViewData["defaultTypeOfCase"] = typeOfcase.First(); }
public void PopulateCourts() { var dataContext = new LawyersEntities(); var Courts = dataContext.Courts_Table .Select(c => new CourtsForeignkey { CourtsID = c.CourtsID, CourtsName = c.CourtsName }) .OrderBy(e => e.CourtsID); ViewData["Courts"] = Courts; ViewData["defaultCourts"] = Courts.First(); }
public void PopulateMediaType() { var dataContext = new LawyersEntities(); var MediaType = dataContext.MediaType_Table .Select(c => new MediaTypeForingKey { MediaTypeID = c.MediaTypeID, MediaTypeName = c.MediaTypeName }) .OrderBy(e => e.MediaTypeID); ViewData["MediaType"] = MediaType; ViewData["defaultMediaType"] = MediaType.First(); }
public void PopulateArea() { var dataContext = new LawyersEntities(); var Area = dataContext.Area_Table .Select(c => new AreaForeignkey { Area_ID = c.Area_ID, Area_Name = c.Area_Name }) .OrderBy(e => e.Area_ID); ViewData["Area"] = Area; ViewData["defaultArea"] = Area.First(); }
public void PopulateDiligenceType() { // وهنا كمان لازم يكون نشيط حتى يتم ادراجه في المشاريع var dataContext = new LawyersEntities(); var DiligenceType = dataContext.DiligenceType_Table .Select(c => new DiligenceTypeForeingKey { DiligenceTypeID = c.DiligenceTypeID, DiligenceTypeName = c.DiligenceTypeName }) .OrderBy(e => e.DiligenceTypeID); ViewData["DiligenceType"] = DiligenceType; ViewData["defaultDiligenceType"] = DiligenceType.First(); }
public void PopulateIssuesType() { // وهنا كمان لازم يكون نشيط حتى يتم ادراجه في المشاريع var dataContext = new LawyersEntities(); var IssuesType = dataContext.IssuesType_Table .Select(c => new IssuesTypeForeingKey { IssuesTypeID = c.IssuesTypeID, IssuesTypename = c.IssuesTypename }) .OrderBy(e => e.IssuesTypeID); ViewData["IssuesType"] = IssuesType; ViewData["defaultIssuesType"] = IssuesType.First(); }
public void PopulateGender() { // وهنا كمان لازم يكون نشيط حتى يتم ادراجه في المشاريع var dataContext = new LawyersEntities(); var Gender = dataContext.Gender_Table .Select(c => new GenderForeignkey { GenderID = c.GenderID, GenderName = c.GenderName }) .OrderBy(e => e.GenderID); ViewData["Gender"] = Gender; ViewData["defaultGender"] = Gender.First(); }
public void PopulateUsers() { // وهنا كمان لازم يكون نشيط حتى يتم ادراجه في المشاريع var dataContext = new LawyersEntities(); var users = dataContext.Users_Table .Select(c => new UsersForeignkey { UserID = c.UserID, FullName = c.FullName }) .OrderBy(e => e.UserID); ViewData["users"] = users; ViewData["defaultUser"] = users.First(); }
public void PopulateIssuesStatus() { // وهنا كمان لازم يكون نشيط حتى يتم ادراجه في المشاريع var dataContext = new LawyersEntities(); var IssuesStatus = dataContext.IssuesStatus_Table .Select(c => new IssuesStatusForeignkey { IssuesStatusID = c.IssuesStatusID, IssuesStatusName = c.IssuesStatusName }) .OrderBy(e => e.IssuesStatusID); ViewData["IssuesStatus"] = IssuesStatus; ViewData["defaultIssuesStatus"] = IssuesStatus.First(); }
public ActionResult ADDBenef(BeneficiariesViewModel db) { LawyersEntities entities = new LawyersEntities(); var entity = new Beneficiaries_Table(); entity.BeneficiariesIDNumber = db.BeneficiariesIDNumber; entity.BeneficiariesName = db.BeneficiariesName; entity.BeneficiariesPhone = db.BeneficiariesPhone; entity.GenderID = db.GenderID; entities.Beneficiaries_Table.Add(entity); entities.SaveChanges(); db.Beneficiaries_ID = entity.Beneficiaries_ID; return(View()); }
public ActionResult Login(Users_Table user) { if (ModelState.IsValid) { try { using (LawyersEntities dc = new LawyersEntities()) { // 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; if ((string)Session["UserType"] == "1" || (string)Session["UserType"] == "2" || (string)Session["UserType"] == "3") { return(RedirectToAction("Index", "Home")); } else if ((string)Session["UserType"] == "4") { return(RedirectToAction("FamilyForum", "FamilyForum")); } // User Informations : } } } catch (Exception) { //اذا كان المستخدم اساسا مش موجود في جدول المستخدمين او كلمة المرور خطأ ModelState.AddModelError("", "خطأ في الدخول للنظام"); } } return(View(user)); }
public ActionResult db_Create([DataSourceRequest] DataSourceRequest request, ProjectControlViewModel db) { try { LawyersEntities entities = new LawyersEntities(); var project = entities.ProjectControl_Table .Single(i => i.UserID == db.UserID && i.ProjectID == db.ProjectID); db.ProjectControlID = 0; ModelState.AddModelError("خطأ", "المستخدم موجود مسبقا في المشروع"); } catch (Exception) { if (db != null && ModelState.IsValid) { ProjectControlSerivce.Create(db); return(Json(new[] { db }.ToDataSourceResult(request, ModelState))); } } return(Json(new[] { db }.ToDataSourceResult(request, ModelState))); }
public UserService(LawyersEntities entities) { this.entities = entities; }
public CoursesService(LawyersEntities entities) { this.entities = entities; }
public ProjectService(LawyersEntities entities) { this.entities = entities; }
public LegalIssuesService(LawyersEntities entities) { this.entities = entities; }
public MediationService(LawyersEntities entities) { this.entities = entities; }