public async Task <IActionResult> Edit(int id, [Bind("SubjectId,Name")] tblSubject tblSubject) { if (id != tblSubject.SubjectId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblSubject); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tblSubjectExists(tblSubject.SubjectId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(tblSubject)); }
protected void btnSubjectEdit_Click(object sender, EventArgs e) { ///TODO: Make a function out of this int hashCode = sender.GetHashCode(); for (int i = 0; i < subjectListRepeater.Items.Count; i++) { LinkButton button = (LinkButton)subjectListRepeater.Items[i].FindControl("btnSubjectEdit"); if (button.GetHashCode() == hashCode) { RepeaterItem items = subjectListRepeater.Items[i]; // Fetches the items in the row TableCell tc = (TableCell)items.FindControl("tcSubjectCode"); // Finds the item corresponding with the ID int id = Convert.ToInt32(tc.Text); // Gets the content of the TableCell using (DatabaseDataContext db = new DatabaseDataContext()) { tblSubject subject = db.tblSubjects.Where(x => x.subjectCode == id).FirstOrDefault(); txtSubjectCode.Text = Server.HtmlEncode(subject.subjectCode.ToString()); ddlSubjectGroup.SelectedValue = Server.HtmlEncode(subject.subjectGroup); txtSubjectTitle.Text = Server.HtmlEncode(subject.subjectTitle); txtSubjectDescription.Text = Server.HtmlEncode(subject.subjectDescription); txtSubjectCode.Enabled = false; mvTeacherSubjects.ActiveViewIndex = 1; mvForm.ActiveViewIndex = 1; } break; } } }
protected void btnSubjectDelete_Click(object sender, EventArgs e) { int hashCode = sender.GetHashCode(); for (int i = 0; i < subjectListRepeater.Items.Count; i++) { LinkButton button = (LinkButton)subjectListRepeater.Items[i].FindControl("btnSubjectDelete"); if (button.GetHashCode() == hashCode) { RepeaterItem items = subjectListRepeater.Items[i]; // Fetches the items in the row TableCell tc = (TableCell)items.FindControl("tcSubjectCode"); // Finds the item corresponding with the ID int id = Convert.ToInt32(tc.Text); // Gets the content of the TableCell using (DatabaseDataContext db = new DatabaseDataContext()) { tblSubject subject = db.tblSubjects.Where(x => x.subjectCode == id).FirstOrDefault(); subject.isVisible = false; db.SubmitChanges(); List <tblSubject> subjects = db.tblSubjects.SortBy("subjectTitle").Where(x => x.isVisible).ToList(); pDelete.Visible = true; pEdit.Visible = false; ControlManager.populateControl(subjects, subjectListRepeater); } break; } } }
private void LoadGrid() { //Cbo Load Subjects var subject = db.tblSubjects.ToList(); tblSubject tbl = new tblSubject(); tbl.SubjectName = "Choose Subject"; subject.Insert(0, tbl); cboSubject.DataSource = subject; cboSubject.DisplayMember = "SubjectName"; cboSubject.ValueMember = "SubjectId"; cboSubject.SelectedIndex = 0; //Cbo Load Teacher var teacher = db.tblTeachers.ToList(); tblTeacher tb = new tblTeacher(); tb.TeacherName = "Choose Teacher Name"; teacher.Insert(0, tb); cboTeacher.DataSource = teacher; cboTeacher.DisplayMember = "TeacherName"; cboTeacher.ValueMember = "TeacherId"; cboTeacher.SelectedIndex = 0; dataGridView1.DataSource = db.tblTeacherSubjectMappings.Select(x => new { MappingId = x.TeacherSubjectMappingId, TeacherName = x.tblTeacher.TeacherName, SubjectName = x.tblSubject.SubjectName }).ToList(); }
public ActionResult Details(long code, string dates) { try { SchoolId = USession.School_Id; DropDownList("%"); HomeWorkModel TModel = new HomeWorkModel(); tblAssignmentHeader TCtable = Connection.tblAssignmentHeaders.SingleOrDefault(x => x.AssignmentNo == code); TModel.SubjectId = TCtable.SubjectId; TModel.GradeId = TCtable.GradeId; TModel.ClassId = TCtable.ClassId; tblClass TClass = Connection.tblClasses.SingleOrDefault(x => x.ClassId == TCtable.ClassId && x.GradeId == TCtable.GradeId && x.SchoolId == SchoolId); TModel.Class = TClass.ClassName; tblGrade TGrade = Connection.tblGrades.SingleOrDefault(x => x.GradeId == TCtable.GradeId); TModel.Grade = TGrade.GradeName; tblSubject TSubject = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == TCtable.SubjectId); TModel.Subject = TSubject.SubjectName; TModel.stringDueDate = dates; TModel.AssignmentDescription = TCtable.AssignmentDescription; TModel.BatchNo = TCtable.BatchNo; TModel.BatchDescription = TCtable.BatchDescription; TModel.FilePath = TCtable.FilePath; TModel.AssignmentNo = TCtable.AssignmentNo; return(PartialView("DetailView", TModel)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
public ActionResult Create(tblSubject Model) { UserId = USession.User_Id; try { Connection.GDsetSubject(Model.ShortName, Model.SubjectName, UserId, "Y"); Connection.SaveChanges(); //return View(); return(RedirectToAction("Index")); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }
/// <summary> /// Thêm môn mới /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnCreateNews_Click(object sender, EventArgs e) { if (txtSubjectCode.Text == "" || txtSubjectName.Text == "") { lblThongBao.Text = "Bạn chưa nhập đầy đủ thông tin"; lblThongBao.Visible = true; } else { if (TestCode(txtSubjectCode.Text) == false) { if (TestName(txtSubjectName.Text) == false) { TestOnlineDataContext db = new TestOnlineDataContext(); tblSubject tbl = new tblSubject(); tbl.SubjectID = txtSubjectCode.Text; tbl.SubjectName = txtSubjectName.Text; db.tblSubjects.InsertOnSubmit(tbl); db.SubmitChanges(); LoadGrid(); } else { lblThongBao.Text = "Tồn tại tên môn học"; lblThongBao.Visible = true; } } else { lblThongBao.Text = "Tồn tại mã môn học"; lblThongBao.Visible = true; } } }
private void dataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { subjectid = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value); tblSubject tb = db.tblSubjects.Where(a => a.SubjectId == subjectid).FirstOrDefault(); txtSubjectName.Text = tb.SubjectName; txtDescription.Text = tb.Description; }
public ActionResult DeleteConfirmed(int id) { tblSubject tblSubject = db.tblSubjects.Find(id); db.tblSubjects.Remove(tblSubject); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "sjId,sjBSN,sjGender,sjDateOfBirth,sjDateOfDeath,sjMaritalStatusId,sjIsInactive,sjAnonymisedOn,sjWoonplaatsSource,sjWoonplaatsId")] tblSubject tblSubject) { if (ModelState.IsValid) { db.Entry(tblSubject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblSubject)); }
public async Task <IActionResult> Create([Bind("SubjectId,Name")] tblSubject tblSubject) { if (ModelState.IsValid) { _context.Add(tblSubject); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tblSubject)); }
private void btnDelete_Click(object sender, EventArgs e) { tblSubject tb = db.tblSubjects.Where(a => a.SubjectId == subjectid).FirstOrDefault(); db.tblSubjects.Remove(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Subject Deleted"); LoadGrid(); } ; }
public List <tblSubject> LoadSubject() { List <tblSubject> drpList = new List <tblSubject>(); tblSubject item = new tblSubject(); item.SubjectId = 0; item.subjectCode = "Select"; drpList = dbcontext.tblSubjects.ToList(); drpList.Insert(0, item); return(drpList); }
private void btnUpdate_Click(object sender, EventArgs e) { tblSubject tb = db.tblSubjects.Where(a => a.SubjectId == subjectid).FirstOrDefault(); tb.SubjectName = txtSubjectName.Text; tb.Description = txtDescription.Text; if (db.SaveChanges() > 0) { LoadGrid(); MessageBox.Show("Subject Details Updated"); ClearData(); } }
/// <summary> /// Kiểm tra xem mã môn học có tồn tại không /// </summary> /// <param name="code"></param> /// <returns></returns> bool TestCodeSubject(string code) { TestOnlineDataContext db = new TestOnlineDataContext(); tblSubject tbl = db.tblSubjects.SingleOrDefault(c => c.SubjectID.Trim().ToLower() == code.Trim().ToLower()); if (tbl != null) { return(true); } else { return(false); } }
private void btnSave_Click(object sender, EventArgs e) { tblSubject tb = new tblSubject(); tb.SubjectName = txtSubjectName.Text; tb.Description = txtDescription.Text; db.tblSubjects.Add(tb); if (db.SaveChanges() > 0) { MessageBox.Show("Subject Added"); LoadGrid(); ClearData(); } }
/// <summary> /// Kiểm tra trùng tên /// </summary> bool TestName(string name) { TestOnlineDataContext db = new TestOnlineDataContext(); tblSubject tbl = db.tblSubjects.SingleOrDefault(c => c.SubjectName.ToLower().Trim() == txtSubjectName.Text.ToLower().Trim()); if (tbl != null) { return(true); } else { return(false); } }
// GET: tblSubjects/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblSubject tblSubject = db.tblSubjects.Find(id); if (tblSubject == null) { return(HttpNotFound()); } return(View(tblSubject)); }
private void LoadGrid() { var subject = db.tblSubjects.ToList(); tblSubject tbl = new tblSubject(); tbl.SubjectName = "Choose Subject"; subject.Insert(0, tbl); cboSubjectId.DataSource = subject; cboSubjectId.DisplayMember = "SubjectName"; cboSubjectId.ValueMember = "SubjectId"; cboSubjectId.SelectedIndex = 0; //show table data in datagridview while foreign key enabled dataGridView1.DataSource = db.tblAssignments.Select(x => new { AssignmentId = x.AssignmentId, SubjectId = x.tblSubject.SubjectName, ReleaseDate = x.ReleaseDate, SubmitionDate = x.SubmissionDate, Remarks = x.Remarks }).ToList(); }
private void LoadSubject() { List <tblSubject> drpList = new List <tblSubject>(); tblSubject item = new tblSubject(); item.SubjectId = 0; item.subjectName = "Select"; drpList = dbcontext.tblSubjects.ToList(); drpList.Insert(0, item); drpSubject.DataValueField = "SubjectId"; drpSubject.DataTextField = "subjectName"; drpSubject.DataSource = drpList; drpSubject.DataBind(); }
public ActionResult Edit(SubjectModel Model) { UserId = USession.User_Id; try { tblSubject TCtable = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == Model.SubjectId); Connection.GDModifySubject(Model.ShortName, Model.SubjectName, Model.SubjectId, UserId); Connection.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
protected void Button_Click_Add_Subject(object sender, EventArgs e) { tblSubject item = new tblSubject(); item.subjectCode = txtSubjectCode.Text; item.subjectName = txtSubjectName.Text; dbcontext.tblSubjects.AddObject(item); dbcontext.SaveChanges(); grdSubject.DataSource = dbcontext.tblSubjects; grdSubject.DataBind(); string script = "alert('Subject Saved');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); }
protected void grvSubject_RowCommand(object sender, GridViewCommandEventArgs e) { TestOnlineDataContext db = new TestOnlineDataContext(); //Xóa 1 hàng trong gridview if (e.CommandName == "Delete") { tblSubject doc = db.tblSubjects.SingleOrDefault(d => d.SubjectID.ToString().Trim() == e.CommandArgument.ToString().Trim()); if (doc != null) { db.tblSubjects.DeleteOnSubmit(doc); db.SubmitChanges(); LoadGrid(); lblThongBao.Visible = true; lblThongBao.Text = "Bạn đã xóa thành công"; } } }
public int AddSubjects(ISubject dataSubject) { tblSubject dataTblSubject = new tblSubject(); try { using (BytepadDBEntities db = new BytepadDBEntities()) { dataTblSubject.SubjectName = dataSubject.SubjectName; db.tblSubjects.Add(dataTblSubject); db.SaveChanges(); } } catch (Exception ex) { string error = ex.ToString(); } return(dataTblSubject.Id); }
public ActionResult Edit(int Code) { try{ SubjectModel TModel = new SubjectModel(); tblSubject TCtable = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == Code); TModel.IsActive = TCtable.IsActive; TModel.SubjectId = TCtable.SubjectId; TModel.ShortName = TCtable.ShortName; TModel.SubjectName = TCtable.SubjectName; return(PartialView("EditView", TModel)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
// PUT api/values/5 public HttpResponseMessage Put(int id, tblSubject subjectDetails) { try { var subject = unitOfWork.SubjectRepository.GetByID(id); subject.SubjectCode = subjectDetails.SubjectCode; subject.CurriculumID = subjectDetails.CurriculumID; subject.DescriptiveTitle = subjectDetails.DescriptiveTitle; subject.HrsWk = subjectDetails.HrsWk; subject.SchoolID = subjectDetails.SchoolID; subject.Units = subjectDetails.Units; subject.YearLevel = subjectDetails.YearLevel; unitOfWork.SubjectRepository.Update(subject); unitOfWork.Save(); return(Request.CreateResponse <tblSubject>(HttpStatusCode.OK, subject)); } catch { return(Request.CreateResponse <tblSubject>(HttpStatusCode.NotFound, null)); } }
public ActionResult Edit(string AcademicYear, string GradeId, string SubjectId, string SubjectCategoryId, string Optional) { Dropdownlistdata(AcademicYear, GradeId); int suid = Convert.ToInt32(SubjectId); Grade_SubjectModel TModel = new Grade_SubjectModel(); tblSubject TCtable = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == suid); TModel.AcademicYear = AcademicYear; TModel.GradeId = GradeId; TModel.SubjectName = TCtable.SubjectName; TModel.ShortName = TCtable.ShortName; TModel.SubjectId = Convert.ToInt32(SubjectId); TModel.SubjectCategoryId = Convert.ToInt32(SubjectCategoryId); TModel.Optional = Optional; tblGrade TGtable = Connection.tblGrades.SingleOrDefault(x => x.GradeId == GradeId); TModel.GradeName = TGtable.GradeName; return(PartialView("Edit", TModel)); }
public ActionResult Edit(long Code, string dates) { try { SchoolId = USession.School_Id; HomeWorkModel TModel = new HomeWorkModel(); tblAssignmentHeader TCtable = Connection.tblAssignmentHeaders.SingleOrDefault(x => x.AssignmentNo == Code); TModel.SubjectId = TCtable.SubjectId; TModel.GradeId = TCtable.GradeId; TModel.ClassId = TCtable.ClassId; tblClass TClass = Connection.tblClasses.SingleOrDefault(x => x.ClassId == TCtable.ClassId && x.GradeId == TCtable.GradeId && x.SchoolId == SchoolId); TModel.Class = TClass.ClassName; tblGrade TGrade = Connection.tblGrades.SingleOrDefault(x => x.GradeId == TCtable.GradeId); TModel.Grade = TGrade.GradeName; tblSubject TSubject = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == TCtable.SubjectId); TModel.Subject = TSubject.SubjectName; TModel.stringDueDate = dates; TModel.AssignmentDescription = TCtable.AssignmentDescription; TModel.BatchNo = TCtable.BatchNo; TModel.BatchDescription = TCtable.BatchDescription; TModel.FilePath = TCtable.FilePath; TModel.AssignmentNo = TCtable.AssignmentNo; DropDownList(TCtable.GradeId); var Subject = Connection.GDgetGradeActiveSubject(SchoolId, TCtable.GradeId, "Y");; List <GDgetGradeActiveSubject_Result> Subjectlist = Subject.ToList(); ViewBag.SubjectId = new SelectList(Subjectlist, "SubjectId", "SubjectName"); ViewBag.SubjectIdtxt = TCtable.SubjectId; return(PartialView("EditView", TModel)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
protected void btnNewSubjectAdd_Click(object sender, EventArgs e) { using (DatabaseDataContext db = new DatabaseDataContext()) { if (db.tblSubjects.Where(x => x.subjectCode == Convert.ToInt32(txtSubjectCode.Text)).FirstOrDefault() != null) { lblSubjectCode.Visible = true; return; } } tblSubject subject = new tblSubject { subjectCode = Convert.ToInt32(txtSubjectCode.Text), subjectTitle = txtSubjectTitle.Text, subjectGroup = ddlSubjectGroup.SelectedItem.Text, subjectDescription = txtSubjectDescription.Text, isVisible = true }; using (DatabaseDataContext db = new DatabaseDataContext()) { db.tblSubjects.InsertOnSubmit(subject); db.SubmitChanges(); List <tblSubject> subjects = db.tblSubjects.SortBy("subjectTitle").Where(x => x.isVisible).ToList(); ControlManager.populateControl(subjects, subjectListRepeater); } ControlManager.clearTextBoxes(vForm); lblSubjectCode.Visible = false; mvTeacherSubjects.ActiveViewIndex = 0; pAdd.Visible = true; }
public static void assignmentCreateNotification(int userID) { using (DatabaseDataContext db = new DatabaseDataContext()) { tblTeacher teacher = db.tblTeachers.Where(x => x.userID == SessionManager.UserID).FirstOrDefault(); tblSubject subject = db.tblSubjects.Where(x => x.subjectCode == teacher.subjectCode).FirstOrDefault(); tblNotification notification = new tblNotification { notificationMessage = "You have a new assignment for " + subject.subjectTitle + "(" + subject.subjectCode + ")", userID = userID, notificationDateTime = DateTime.UtcNow, notificationType = "A", notificationLink = "StudentAssignments.aspx", isSeen = false }; db.tblNotifications.InsertOnSubmit(notification); db.SubmitChanges(); } }