// delete boxSubject
public JsonResult DeleteBoxSubject(string boxSubjectId)
{
AjaxResultModel Result = new AjaxResultModel();
try
{
if (Subjects_Boxes_Service.Delete(Int32.Parse(boxSubjectId)))
{
Result.Code = 0;
Result.Result = "Thao tác thành công";
}
else
{
Result.Code = 1;
Result.Result = "Môn học đang được sử dụng. Vui lòng kiểm tra lại";
}
}
catch (Exception Ex)
{
Result.Code = 1;
Result.Result = "Môn học đang được sử dụng. Vui lòng kiểm tra lại";
IOHelper.WriteLog(StartUpPath, IpAddress, "InsertOrUpdateUser:", Ex.Message, Ex.ToString());
}
return(Json(new JsonResult()
{
Data = Result
}));
}
public JsonResult InsertOrUpdateSubjectBox(List <string> listSubjectId, int box_id = 0, string boxSubjectId = "", string price = "")
{
AjaxResultModel Result = new AjaxResultModel();
try
{
bool check = Subjects_Boxes_Service.InsertOrUpdate(box_id, listSubjectId, boxSubjectId, price);
if (check)
{
Result.Code = 0;
Result.Result = "Thành công";
}
else
{
Result.Code = 1;
Result.Result = "Thao tác không thành công";
}
}
catch (Exception Ex)
{
Result.Code = 1;
Result.Result = "Thao tác không thành công";
IOHelper.WriteLog(StartUpPath, IpAddress, "InsertOrUpdateUser:", Ex.Message, Ex.ToString());
}
return(Json(new JsonResult()
{
Data = Result
}));
}
public PartialViewResult _Detail()
{
List <TB_SUBJECTS> subjects = new List <TB_SUBJECTS>();
List <TB_BOXES> boxes = new List <TB_BOXES>();
List <TB_USERS> teachers = new List <TB_USERS>();
List <V_BOX_SUBJECT> boxSubject = new List <V_BOX_SUBJECT>();
List <TB_ROOM_CLASS> room = new List <TB_ROOM_CLASS>();
int count = 0;
try
{
room = RoomClass_Service.GetAll();
boxSubject = Subjects_Boxes_Service.GetAllBy("", 1, short.MaxValue, out count);
subjects = Subjects_Service.GetAll();
boxes = Boxes_Service.GetAll();
teachers = User_Service.GetAllTeacher();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
ViewBag.BoxSubject = boxSubject;
ViewBag.subjects = subjects;
ViewBag.boxes = boxes;
ViewBag.teachers = teachers;
ViewBag.Room = room;
return(PartialView());
}
public PartialViewResult _Index(string keyText = "", string boxId = "", string subjectId = "", string timeIn = "", string timeEnd = "", string status = "", int pageNumber = 1, int pageSize = 10)
{
ViewBag.pageNumber = pageNumber;
ViewBag.pageSize = pageSize;
ViewBag.maxNumber = 0;
List <V_CLASS_DETAILS> cl = new List <V_CLASS_DETAILS>();
var classes = new List <V_CLASS>();
List <V_NUMBER_STUDIES> listCount = new List <V_NUMBER_STUDIES>();
int count = 0;
try
{
cl = Classes_Service.GetInfoClass(keyText, boxId, subjectId, timeIn, timeEnd, status, pageNumber, pageSize, out count);
listCount = Schedules_Service.GetCountStudieInClass("");
//classes = Classes_Service.GetClassBy(keyText, boxId, subjectId, timeIn, timeEnd, status, pageNumber, pageSize, out count);
ViewBag.maxNumber = Math.Ceiling((double)count / pageSize);
ViewBag.users = User_Service.GetAll();
int count1 = 0;
ViewBag.boxSubjects = Subjects_Boxes_Service.GetAllBy("", 1, short.MaxValue, out count1);
}
catch (Exception ex)
{
CORE.Helpers.IOHelper.WriteLog(StartUpPath, "ClassController :", ex.Message, ex.ToString());
}
ViewBag.Count = listCount;
return(PartialView(cl));
}
public PartialViewResult _Index(string keyText = "", int pageNumber = 1, int pageSize = 10)
{
ViewBag.pageNumber = pageNumber;
ViewBag.pageSize = pageSize;
ViewBag.maxNumber = 0;
var subjects = new List <V_BOX_SUBJECT>();
try
{
int count = 0;
subjects = Subjects_Boxes_Service.GetAllBy(keyText, pageNumber, pageSize, out count);
ViewBag.maxNumber = Math.Ceiling((double)count / pageSize);
}
catch (Exception ex)
{
CORE.Helpers.IOHelper.WriteLog(StartUpPath, "SubjectController :", ex.Message, ex.ToString());
}
return(PartialView(subjects));
}
public PartialViewResult _ReportSalary(string userId = "", string scheduleId = "", string startDate = "", string endDate = "", int pageNumber = 1, int pageSize = 10)
{
int count = 0;
ViewBag.pageNumber = pageNumber;
ViewBag.pageSize = pageSize;
ViewBag.maxNumber = 0;
List <V_SALARY_TEACHER> list = new List <V_SALARY_TEACHER>();
List <TB_SCHEDULES> listSche = new List <TB_SCHEDULES>();
List <TB_SUBJECTS> listSuject = new List <TB_SUBJECTS>();
List <TB_BOX_SUBJECTS> listBoxSubject = new List <TB_BOX_SUBJECTS>();
List <TB_TRANSACTION> listTran = new List <TB_TRANSACTION>();
List <TB_USERS> listUser = new List <TB_USERS>();
int total = 0;
try
{
listUser = User_Service.GetAllTeacher();
listTran = Transaction_Service.GetAllBy(userId, startDate, endDate, "TEACHER");
listSuject = Subjects_Service.GetAll();
listBoxSubject = Subjects_Boxes_Service.GetAll();
listSche = Schedules_Service.GetAll();
list = User_Service.GetSalaryTeacher(userId, scheduleId, startDate, endDate, pageNumber, pageSize, out count);
total = count + listTran.Count;
}
catch (Exception e)
{
ViewBag.Error = e.ToString();
}
ViewBag.maxNumber = Math.Ceiling((double)total / pageSize);
ViewBag.Salary = list;
ViewBag.Subject = listSuject;
ViewBag.SubjectBox = listBoxSubject;
ViewBag.Schedule = listSche;
ViewBag.Transaction = listTran;
ViewBag.User = listUser;
return(PartialView());
}
