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