public ConfigurationItem(Configuration config, AssessmentEntities context) { C__id = config.C__id; Id = config.Id; PartNo = config.PartNo; Description = config.Description; Revision = config.Revision; FilePath = config.FilePath; ConfigurationName = config.ConfigurationName; BomPartNumber = config.BomPartNumber; IsActive = config.IsActive; IsRoot = config.IsRoot; Preview = config.Preview; Quantity = 1; ChildConfigurations = new ObservableCollection <ConfigurationItem>(); var bomChildEntries = context.Boms.Where(x => x.ParentConfigIndex == config.Id); foreach (var entry in bomChildEntries) { ChildConfigurations.Add( new ConfigurationItem( context.Configurations.Where(x => x.Id == entry.ChildConfigIndex).First(), context ) { Quantity = entry.Qty }); } }
public ActionResult UserDashBoard([Bind(Include = "objTweet,objTweetList,objFollow")] TweetViewModel objTwt) { AssessmentEntities db = new AssessmentEntities(); tweet objTweet = new tweet(); following objFollow = new following(); TweetViewModel oTwt = new TweetViewModel(); if (ModelState.IsValid) { objTweet.user_id = Session["UserID"].ToString(); objTweet.created = DateTime.Now; objTweet.message = objTwt.objTweet.message; db.tweets.Add(objTweet); db.SaveChanges(); objFollow.user_id = Session["UserID"].ToString(); objFollow.following_id = objTwt.objFollow.following_id; db.followings.Add(objFollow); db.SaveChanges(); oTwt.objTweetList = GetTweetList(); oTwt.objTweet = new tweet(); oTwt.objTweet.message = string.Empty; oTwt.tweetCount = oTwt.objTweetList.Count.ToString(); string result = GetFollowingList(); oTwt.followingCount = result.Split(';')[0]; oTwt.followersCount = result.Split(';')[1]; return(View(oTwt)); } return(View(oTwt)); }
public RootConfiguration(Configuration config, AssessmentEntities context) { Id = config.Id; ConfigurationName = config.ConfigurationName; ChildConfigurations = new ObservableCollection <ConfigurationItem>(); ChildConfigurations.Add(new ConfigurationItem(config, context)); }
public ActionResult AllData(string param, int? page, string column, string sortOrder) { using (var context = new AssessmentEntities()) { try { IEnumerable<spASSESSMENT_RECORDS_Result> results = null; param = string.IsNullOrEmpty(param) ? "" : param; //sortOrder = string.IsNullOrEmpty(sortOrder) ? "" : sortOrder; ViewBag.Order = ""; if (String.IsNullOrEmpty(column) && String.IsNullOrWhiteSpace(sortOrder)) results = getAllRecords(context, param).ToList(); else results = SortTable(context, param, column, sortOrder).ToList(); var pageView = results.ToPagedList(page ?? 1, 5); return View("_AllData", "AllData", pageView); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "Unable to fetch the data due to bad url"; return View("Error"); } } }
public ActionResult Create(RUBRICS_DATA rubricData) { if (ModelState.IsValid) { using (var context = new AssessmentEntities()) { try { context.RUBRICS_DATA.Add(rubricData); context.SaveChanges(); ViewBag.InsertionResult = "Rubric Successfully inserted."; } catch (Exception ex) { Response.Write(ex.Message); ViewBag.ErrorMsg = "Performance Indicator already Exist. Please check the input again"; return View("Error"); } finally { DepartmentList departmentList = new DepartmentList(); ViewBag.Departments = departmentList.getDepartmentList(context); } } return PartialView("_InsertResult"); } else { ViewBag.ErrorMsg = "Invalid Input entered."; return View("Error"); } }
public ActionResult Create() { using (var context = new AssessmentEntities()) { DepartmentList departmentList = new DepartmentList(); ViewBag.Departments = departmentList.getDepartmentList(context); return View(); } }
public ActionResult Profiler() { if (Session["UserID"] != null) { AssessmentEntities db = new AssessmentEntities(); var objPerson = db.people.Find(Session["UserID"].ToString()); return(View("Profile", objPerson)); } return(RedirectToAction("Login")); }
//Reference: http://highoncoding.com/Articles/770_Implementing_Dynamic_DropDownList_in_ASP_NET_MVC_3_Framework.aspx public List<SelectListItem> getDepartmentList(AssessmentEntities context) { List<SelectListItem> departmentList = new List<SelectListItem>(); departmentList.Add(new SelectListItem() { Text = "Please select Department", Value = "default" }); var result = context.DEPARTMENTS.ToList(); foreach (var item in result) { departmentList.Add(new SelectListItem() { Text = item.DEPARTMENT_DESC, Value = item.DEPARTMENT_CD }); } return departmentList; }
public List<SelectListItem> getProfessorListList() { List<SelectListItem> departmentList = new List<SelectListItem>(); using (var context = new AssessmentEntities()) { //PerformanceIndicator pIndicators = new PerformanceIndicator(); var result = context.USER_INFO.ToList(); foreach (var item in result) { departmentList.Add(new SelectListItem() { Text = item.INSTRUCTOR_NAME, Value = item.INSTRUCTOR_EMAILID }); } return departmentList; } }
//Reference: http://highoncoding.com/Articles/770_Implementing_Dynamic_DropDownList_in_ASP_NET_MVC_3_Framework.aspx public List<SelectListItem> getPerformanceIndicatorList(string dept) { List<SelectListItem> performanceIndicators = new List<SelectListItem>(); using (var context = new AssessmentEntities()) { //var result = context.RUBRICS_DATA.Where(x => x.DEPARTMENT_CD.Equals(id)).Select(x => x.PERFORMANCE_INDICATOR).Distinct().ToList(); var result = context.spRUBRICGETPERFORMANCEINDICATORS(dept).OrderBy(order=>order.outcomes); foreach (var item in result) { performanceIndicators.Add(new SelectListItem() { Text = item.outcomes +"-" +item.performance_indicator, Value = item.outcomes }); } return performanceIndicators; } }
public ActionResult AllRubrics() { if (ModelState.IsValid) { using (var context = new AssessmentEntities()) { DepartmentList departmentList = new DepartmentList(); ViewBag.Departments = departmentList.getDepartmentList(context); } return View(); } ViewBag.ErrorMsg = "Invalid option selected. No such record exist"; return View("Error"); }
public ActionResult SignUp([Bind(Include = "user_id,passwod,fullname,email")] person person) { AssessmentEntities db = new AssessmentEntities(); if (ModelState.IsValid) { person.active = true; person.joined = DateTime.Now; db.people.Add(person); db.SaveChanges(); return(RedirectToAction("Login")); } return(View(person)); }
public ActionResult Edit_Save(USER_INFO userinfo) { using (var context = new AssessmentEntities()) { try { var i = context.spINSTRUCTOREDIT(userinfo.INSTRUCTOR_EMAILID, userinfo.INSTRUCTOR_NAME); return RedirectToAction("AllInstructors"); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "Unable to edit the record. Please retry again."; return View("Error"); } } }
public ActionResult Login(person objUser) { if (ModelState.IsValid) { using (AssessmentEntities db = new AssessmentEntities()) { var obj = db.people.Where(a => a.user_id.Equals(objUser.user_id) && a.passwod.Equals(objUser.passwod)).FirstOrDefault(); if (obj != null) { Session["UserID"] = obj.user_id.ToString(); Session["UserName"] = obj.fullname.ToString(); return(RedirectToAction("UserDashBoard")); } } } return(View(objUser)); }
public ActionResult AllInstructors() { using (var context = new AssessmentEntities()) { try { var result = (IEnumerable<spINSTRUCTORGETALLRECORDS_Result>)context.spINSTRUCTORGETALLRECORDS().ToList(); return View(result); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "Something went wrong while fetching. Please retry after some time."; return View("Error"); } } }
public ActionResult Edit(string email) { using (var context = new AssessmentEntities()) { try { var result = context.spINSTRUCTORGETDETAILS(email).SingleOrDefault(); return View(result); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "Unable to fetch the record. Please retry again."; return View("Error"); } } }
public ActionResult Delete(string email) { using (var context = new AssessmentEntities()) { try { var result = context.spINSTRUCTORDELETE(email); return RedirectToAction("AllInstructors"); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "The Record does not exist or has already been deleted."; return View("Error"); } } }
public List <tweet> GetTweetList() { List <tweet> res = new List <tweet>(); AssessmentEntities db = new AssessmentEntities(); var tweets = db.tweets.ToList(); if (tweets != null) { foreach (var item in tweets) { if (item.user_id == Session["UserID"].ToString()) { res.Add(item); } } } return(res); }
public IQueryable<spASSESSMENT_RECORDS_Result> SortTable(AssessmentEntities context, string param, string column, string sortOrder) { ViewBag.Order = String.IsNullOrEmpty(sortOrder) ? "desc" : ""; sortOrder = String.IsNullOrEmpty(sortOrder) ? "" : sortOrder; var results = context.spASSESSMENT_RECORDS(param).AsQueryable(); Func<IQueryable<spASSESSMENT_RECORDS_Result>, Expression<Func<spASSESSMENT_RECORDS_Result, string>>, IOrderedQueryable<spASSESSMENT_RECORDS_Result>> orderBy; if (!sortOrder.Equals("desc")) { orderBy = Queryable.OrderBy; } else { orderBy = Queryable.OrderByDescending; } results = orderBy(results, spASSESSMENT_RECORDS_Result.Order(column)) .ThenBy(searchResults => searchResults.OUTCOMES); return results; }
// GET: Product_Details/Delete/5 public ActionResult Delete(int?id) { AssessmentEntities db = new AssessmentEntities(); tweet oTwt = db.tweets.Find(id); db.tweets.Remove(oTwt); db.SaveChanges(); TweetViewModel oTwts = new TweetViewModel(); oTwts.objTweetList = GetTweetList(); oTwts.objTweet = new tweet(); oTwts.objTweet.message = string.Empty; oTwts.tweetCount = oTwts.objTweetList.Count.ToString(); string result = GetFollowingList(); oTwts.followingCount = result.Split(';')[0]; oTwts.followersCount = result.Split(';')[1]; return(View("UserDashBoard", oTwts)); }
public ActionResult ChangePassword(ChangePassword changePassword) { if (ModelState.IsValid) { using (var context = new AssessmentEntities()) { var AdminRecord = context.spLOGIN(changePassword.UserName, changePassword.ExistingPassword).SingleOrDefault(); if (AdminRecord != null) { AdminRecord.ADMIN_PASSWORD = changePassword.NewPassword; context.SaveChanges(); ModelState.AddModelError("", "Password Changed Successfully"); } else { ModelState.AddModelError("", "Please enter correct password"); } } } return View(changePassword); }
public ActionResult Index(LoginViewModel model) { if (ModelState.IsValid) { using (var context = new AssessmentEntities()) { var userExist = context.spLOGIN(model.UserName, model.Password).ToList(); if (userExist.Count == 1) { FormsAuthentication.SetAuthCookie(model.UserName, false); return RedirectToAction("Index", "admin"); } else { ModelState.AddModelError("", "Log in credentials invalid"); } } } // If we got this far, something failed, redisplay form return View(model); }
public ActionResult Reference() { ViewBag.total = 0; string linkid; using (var context = new AssessmentEntities()) { try { linkid = Request.QueryString["linkid"].ToString(); var VerifyLink = context.ASSESSMENT_LINK.Where(link => link.RANDOM_STRING == linkid).ToList(); if (VerifyLink.Count == 1) { var linkDetails = VerifyLink.First(); var result = context.spRUBRICGETSEARCHRESULTS(linkDetails.DEPARTMENT_CD, linkDetails.OUTCOMES).ToList(); var rubRowID = result.Select(rubrowID => rubrowID.RUBRIC_ROWID.ToString()).ToList(); Session["RubRowIDS"] = rubRowID; foreach (var item in rubRowID) { Session[item] = "0-0-0-0"; } result.First().Instructor_EmailID = linkDetails.INSTRUCTOR_EMAILID; return View(result); } else { ViewBag.ErrorMsg = "Invalid URL. Please check the Link again"; return View("Error"); } } catch (Exception ex) { ViewBag.ErrorMsg = "Unable to fetch data. Please contact the Assessment officer"; return View("Error"); } } }
public string GetFollowingList() { string res = string.Empty; int followingCount = 0; int followsCount = 0; AssessmentEntities db = new AssessmentEntities(); var follows = db.followings.ToList(); if (follows != null) { foreach (var item in follows) { if (item.user_id == Session["UserID"].ToString()) { followingCount++; } if (item.following_id == Session["UserID"].ToString()) { followsCount++; } } } return(followingCount + ";" + followsCount); }
public ActionResult Edit(int rubID) { using (var context = new AssessmentEntities()) { var results = context.RUBRICS_DATA.Where(rubid => rubid.RUBRIC_ROWID == rubID).SingleOrDefault(); return PartialView("_EditRubric", results); } }
public IQueryable<spASSESSMENT_RECORDS_Result> getAllRecords(AssessmentEntities context, string param) { return context.spASSESSMENT_RECORDS(param).AsQueryable(); }
public PartialViewResult getRubricDetails(spRUBRICSGETRECORD_RUBID_Result rubricRecord, AssessmentEntities context) { var results = context.spRUBRICGETSEARCHRESULTS(rubricRecord.DEPARTMENT_CD, rubricRecord.OUTCOMES).SingleOrDefault(); return PartialView("_Search", results); }
public ActionResult SaveRubric(RUBRICS_DATA rubricData) { using (var context = new AssessmentEntities()) { context.spUPDATERUBRICDATA(rubricData.RUBRIC_ROWID, rubricData.OUTCOMES, rubricData.PERFORMANCE_INDICATOR, rubricData.TOPIC, rubricData.POOR, rubricData.DEVELOPING, rubricData.DEVELOPED, rubricData.EXEMPLARY, rubricData.EXPECTATION_LEVEL); context.SaveChanges(); var rubricRecord = context.spRUBRICSGETRECORD_RUBID(rubricData.RUBRIC_ROWID).SingleOrDefault(); return EditCancel(rubricData.RUBRIC_ROWID); } }
private ConfigurationProvider() { _context = new AssessmentEntities(); }
public ActionResult Reference(ASSESSMENT_DATA assessedData) { bool status = false; using (var context = new AssessmentEntities()) { try { if (context.ASSESSMENT_DATA.Where(rdmstring => rdmstring.RANDOM_STRING == assessedData.RANDOM_STRING).ToList().Count != 0) { //link is already been used //delete old records context.spASSESSMENT_DELETE_OLD_RECORDS(assessedData.RANDOM_STRING); context.SaveChanges(); } foreach (var item in Session["RubRowIDS"] as List<String>) { string sessionData = Session[item].ToString(); String[] data = sessionData.Split('-'); assessedData.RUBRIC_ROWID = Int16.Parse(item); assessedData.POOR = Int16.Parse(data[0]); assessedData.DEVELOPING = Int16.Parse(data[1]); assessedData.DEVELOPED = Int16.Parse(data[2]); assessedData.EXEMPLARY = Int16.Parse(data[3]); if (assessedData.POOR + assessedData.DEVELOPING + assessedData.DEVELOPED + assessedData.EXEMPLARY != 0) { context.ASSESSMENT_DATA.Add(assessedData); context.SaveChanges(); context.spLINK_UPDATESTATUS(assessedData.RANDOM_STRING, false); context.SaveChanges(); } else { ViewBag.ErrorMsg = "Please input at least one record for assessment"; return View("Error"); } } return View("Success"); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "Please complete all form fields."; return View("Error"); } } }
public ActionResult Search(FormCollection f) { using (var context = new AssessmentEntities()) { try { string Outcomes = f["Outcomes"].ToString(); string deptSelected = f["DEPARTMENT"].ToString(); var result = context.spRUBRICGETSEARCHRESULTS(deptSelected, Outcomes).ToList(); //saving variables for emailing Session["Outcome"] = Outcomes; Session["DEPARTMENT"] = deptSelected; return PartialView("_Search", result); } catch (Exception ex) { Response.Write(ex.Message); ViewBag.ErrorMsg = "Bad selection. No such rubric exist."; return View("Error"); } } }
public ActionResult Send(FormCollection f) { using (var context = new AssessmentEntities()) { string department = Session["DEPARTMENT"].ToString(); string outcome = Session["Outcome"].ToString(); string instructorSelected = f["InstructorList"].ToString(); string urlParameters = "Dept=" + department + "&outcome=" + outcome + "&inst=" + instructorSelected; string rdm_string = RandomString(30); context.spLINK_INSERT(rdm_string, outcome, department, instructorSelected, true); context.SaveChanges(); string finalLink = link + rdm_string; SendMail sendmail = new SendMail(); if (sendmail.SendEmail(instructorSelected, "Assessment Form", sendmail.MailBody(finalLink))) { //mail sending currently commented out ViewBag.link = finalLink; return View("MailResult"); } else { ViewBag.ErrorMsg = "Unable to send the link to the Instructor. Please check the network connections or else try sending the link personally. Here it the link below \n" + "<h3>" + finalLink + "</h3>"; return View("Error"); } } }
public PartialViewResult EditCancel(int rowID) { using (var context = new AssessmentEntities()) { var rubricRecord = context.spRUBRICSGETRECORD_RUBID(rowID).SingleOrDefault(); spRUBRICGETSEARCHRESULTS_Result rubDetails = new spRUBRICGETSEARCHRESULTS_Result(); rubDetails.RUBRIC_ROWID = rubricRecord.RUBRIC_ROWID; rubDetails.PERFORMANCE_INDICATOR = rubricRecord.PERFORMANCE_INDICATOR; rubDetails.TOPIC = rubricRecord.TOPIC; rubDetails.OUTCOMES = rubricRecord.OUTCOMES; rubDetails.POOR = rubricRecord.POOR; rubDetails.DEVELOPING = rubricRecord.DEVELOPING; rubDetails.DEVELOPED = rubricRecord.DEVELOPED; rubDetails.EXEMPLARY = rubricRecord.EXEMPLARY; rubDetails.EXPECTATION_LEVEL = rubricRecord.EXPECTATION_LEVEL; return PartialView("_RubricRows", rubDetails); } }
public ActionResult Insert(USER_INFO userinfo) { using (var context = new AssessmentEntities()) { try { var result = context.spInstructorAddNew(userinfo.INSTRUCTOR_NAME, userinfo.INSTRUCTOR_EMAILID); return RedirectToAction("AllInstructors"); } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMsg = "Instructor Email ID already exist in the Database. Please use different one."; return View("Error"); } } }
public void DeleteRubricRecord(int rubID) { using (var context = new AssessmentEntities()) { context.spRUBRIC_DELETE_RUBRICROW(rubID); context.SaveChanges(); } }