// POST: api/Subject
public Response Post([FromBody] T_Subject subj)
{
try
{
if (subj != null) // afterwards check valid subject or not so if/else loop ...
{
dalobj.T_Subject.Add(subj);
dalobj.SaveChanges();
response.Data = null;
response.Status = "success";
response.Err = null;
logger.Log("Subject added in db");
return(response);
}
else
{
response.Data = null;
response.Status = "Invalid Subject";
response.Err = null;
logger.Log("Subject insertion failed");
return(response);
}
}
catch (Exception cause)
{
response.Data = cause.Message;
response.Status = "Failed";
response.Err = cause;
logger.Log("Exception occured returned Error msg");
return(response);
}
}
// DELETE: api/Subject/5
public Response Delete(int id)
{
try
{
T_Subject subjToBedeleted = dalobj.T_Subject.Find(id);
if (subjToBedeleted != null)
{
dalobj.T_Subject.Remove(subjToBedeleted);
dalobj.SaveChanges();
response.Data = null;
response.Status = "success";
response.Err = null;
logger.Log("Specific Subject deleted using Id");
return(response);
}
else
{
response.Data = null;
response.Status = "failed";
response.Err = null;
logger.Log("Something wentr wrong!");
return(response);
}
}
catch (Exception cause)
{
response.Data = cause.Message;
response.Status = "Failed";
response.Err = cause;
logger.Log("Exception occured returned Error msg");
return(response);
}
}
// GET: api/Subject/5
public Response Get(int id)
{
try
{
T_Subject subjToBeFind = dalobj.T_Subject.Find(id);
if (subjToBeFind != null)
{
response.Data = subjToBeFind;
response.Status = "success";
response.Err = null;
logger.Log("Specific Subject displayed using Id");
return(response);
}
else
{
response.Data = null;
response.Status = "Failed";
response.Err = null;
logger.Log("Specific Subject not found using Id");
return(response);
}
}
catch (Exception cause)
{
response.Data = cause.Message;
response.Status = "Failed";
response.Err = cause;
logger.Log("Exception occured returned Error msg");
return(response);
}
}
public bool Compare(T_Subject value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Subjects.Where(x => x.Code.ToLower() == value.Code.ToLower() && x.Description.ToLower() == value.Description.ToLower() && x.Unit == value.Unit && x.Active == value.Active).FirstOrDefault() == null ? true : false);
}
}
// PUT: api/Subject/5
public Response Put(int id, [FromBody] T_Subject subj)
{
try
{
T_Subject subjToBeFind = dalobj.T_Subject.Find(id);
if (subjToBeFind != null)
{
subjToBeFind.SubName = subj.SubName;
dalobj.SaveChanges();
response.Data = subjToBeFind;
response.Status = "success";
response.Err = null;
logger.Log("Specific Subject updated using Id");
return(response);
}
else
{
response.Data = null;
response.Status = "failed";
response.Err = null;
logger.Log("Something wentr wrong!");
return(response);
}
}
catch (Exception cause)
{
response.Data = cause.Message;
response.Status = "Failed";
response.Err = cause;
logger.Log("Exception occured returned Error msg");
return(response);
}
}
public void Save(T_Subject value, ref string msg)
{
T_Subject valueupdate = new T_Subject();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_Subjects.InsertOnSubmit(value);
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Saved, value.Unit, value.Code, value.Description);
}
else
{
valueupdate = dc.T_Subjects.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.Code = value.Code;
valueupdate.Unit = value.Unit;
valueupdate.Description = value.Description;
valueupdate.Active = value.Active;
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Updated, valueupdate.Unit, valueupdate.Code, valueupdate.Description);
}
dc.SubmitChanges();
}
else
{
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Exist, value.Unit, value.Code, value.Description);
}
}
}
public T_Subject SetSubject()
{
T_Subject valueRet = new T_Subject();
valueRet.ID = isAdd?0:Convert.ToInt64(dgSubject.SelectedRows[0].Cells[0].Value.ToString());
valueRet.Active = cbActive.Checked;
valueRet.Code = txtCode.Text;
valueRet.Unit = Convert.ToInt32(txtUnit.Value.ToString());
valueRet.Description = txtDescription.Text;
return(valueRet);
}
public void Delete(T_Subject value, ref string msg)
{
T_Subject valuedelete = new T_Subject();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_Subjects.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_Subjects.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Deleted, valuedelete.Unit, valuedelete.Code, valuedelete.Description);
}
}
public JsonResult GetTeacherName(string ID_Subject)
{
db.Configuration.ProxyCreationEnabled = false;
T_Subject TeacherSubject = db.T_Subject.FirstOrDefault(sub => sub.ID_Subject == ID_Subject);
string TeacherName = null;
if (TeacherSubject != null)
{
TeacherName = db.Teachers.FirstOrDefault(teacher => teacher.ID == TeacherSubject.ID_Teacher).FullName;
}
return(Json(TeacherName, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateExist([Bind(Include = "ID,ID_Subject,SubjectName,Contents,Description,ID_Teacher,DateBegin,isActive,IDSubjectType")] Subject subject)
{
if (subject.ID_Subject != null)
{
Subject findsubject = db.Subjects.FirstOrDefault(s => s.ID_Subject == subject.ID_Subject);
SubjectDetail Detail = new SubjectDetail();
Student CurrentStudent = db.Students.FirstOrDefault(s => s.ID_Account == CurrentUser.ID);
T_Subject TSubject = db.T_Subject.FirstOrDefault(s => s.ID_Subject == subject.ID_Subject);
if (SubjectAvaiable(findsubject)) /* Tạo mới subject nếu nó đã bị xóa */
{
subject.SubjectName = TSubject.T_SubjectName;
subject.DateBegin = month + "/" + day + "/" + year;
subject.ID_Teacher = int.Parse(TSubject.ID_Teacher.ToString());
subject.IDSubjectType = 1;
subject.isActive = true;
TSubject.isActive = false;
if (ModelState.IsValid)
{
db.Subjects.Add(subject);
db.SaveChanges();
CurrentStudent.ID_Subject = subject.ID;
db.SaveChanges();
}
Detail.ID_Student = CurrentStudent.ID;
Detail.ID_Subject = subject.ID;
Detail.PrecentComplete = 0;
if (ModelState.IsValid)
{
db.SubjectDetails.Add(Detail);
db.SaveChanges();
}
}
else if (findsubject.isSubmit != true) /* Nếu đề tài đã được người khác đăng ký nhưng chưa submit thì có thể đăng ký chung nhóm */
{
Detail.ID_Subject = findsubject.ID;
Detail.ID_Student = CurrentStudent.ID;
Detail.PrecentComplete = 0;
CurrentStudent.ID_Subject = subject.ID;
if (ModelState.IsValid)
{
db.SubjectDetails.Add(Detail);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("CreateExist"));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("PageNotFound", "Error"));
}
T_Subject t_Subject = db.T_Subject.Find(id);
if (t_Subject == null)
{
return(HttpNotFound());
}
return(View(t_Subject));
}
public ActionResult Edit([Bind(Include = "ID,ID_Subject,T_SubjectName,Contents,Description,ID_Teacher,isActive,isDelete")] T_Subject t_Subject)
{
try
{
db.Entry(t_Subject).State = EntityState.Modified;
db.SaveChanges();
TempData["SuccessMessage"] = " Chỉnh Sửa Thành Công";
return(RedirectToAction("Index"));
}
catch (Exception)
{
TempData["ErrorMessage"] = "Không thể chỉnh sửa";
}
ViewBag.ID_Teacher = new SelectList(db.Teachers, "ID", "FullName", t_Subject.ID_Teacher);
return(View(t_Subject));
}
public ActionResult Delete(int?id)
{
if (id != null)
{
T_Subject t_Subject = db.T_Subject.Find(id);
if (t_Subject != null)
{
if (DeleteOrNot(t_Subject.ID_Subject))
{
db.T_Subject.Remove(t_Subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
TempData["WarningMessage"] = "Đề tài đã được đăng ký, không thể xóa!";
return(RedirectToAction("Index"));
}
TempData["WarningMessage"] = "Đề tài không tồn tại hoặc đã bị xóa!";
return(RedirectToAction("Index"));
}
return(RedirectToAction("PageNotFound", "Error"));
}
public ActionResult Create([Bind(Include = "ID,ID_Subject,T_SubjectName,Contents,Description,ID_Teacher,isActive,isDelete")] T_Subject t_Subject)
{
bool SubjectNameIsExist = db.T_Subject.FirstOrDefault(s => s.T_SubjectName == t_Subject.T_SubjectName) != null;
if (t_Subject.ID_Subject != null)
{
if (!SubjectNameIsExist)
{
t_Subject.ID_Teacher = db.Teachers.FirstOrDefault(s => s.ID_Account == CurrentUser.ID).ID;
db.T_Subject.Add(t_Subject);
db.SaveChanges();
t_Subject.ID_Subject += string.Format("{0:0000}", t_Subject.ID);
db.SaveChanges();
TempData["SuccessMessage"] = " Thêm đề tài mới thành công!";
return(RedirectToAction("Index"));
}
TempData["WarningMessage"] = "Tên đề tài đã tồn tại, vui lòng chọn tên khác!";
return(RedirectToAction("Create"));
}
TempData["WarningMessage"] = "Vui lòng chọn loại đề tài!";
return(RedirectToAction("Create"));
}
