public JsonResult Create(tblCourseHD CourseHD)
{
try
{
var errors = ModelState
.Where(x => x.Value.Errors.Count > 0)
.Select(x => new { x.Key, x.Value.Errors })
.ToArray();
if (ModelState.IsValid)
{
// If sales main has SalesID then we can understand we have existing sales Information
// So we need to Perform Update Operation
string TempID = Guid.NewGuid().ToString();
CourseHD.CourseHDID = TempID;
CourseHD.IsClose = false;
if (CourseHD.TimeStart_txt.Contains(":"))
{
string[] TempTimeStart = CourseHD.TimeStart_txt.Split(':');
CourseHD.TimeStart = (Convert.ToInt32(TempTimeStart[0]) * 60) + Convert.ToInt32(TempTimeStart[0]);
}
else
{
CourseHD.TimeStart = 0;
}
if (CourseHD.TimeEnd_txt.Contains(":"))
{
string[] TempTimeEnd = CourseHD.TimeEnd_txt.Split(':');
CourseHD.TimeEnd = (Convert.ToInt32(TempTimeEnd[0]) * 60) + Convert.ToInt32(TempTimeEnd[0]);
}
else
{
CourseHD.TimeEnd = 0;
}
foreach (tblCourseDT DT in CourseHD.tblCourseDTs)
{
DT.CourseHDID = TempID;
DT.CourseDTID = Guid.NewGuid().ToString();
}
db.tblCourseHDs.Add(CourseHD);
db.SaveChanges();
// If Sucess== 1 then Save/Update Successfull else there it has Exception
return(Json(new { Success = 1 }));
}
}
catch (Exception ex)
{
// If Sucess== 0 then Unable to perform Save/Update Operation and send Exception to View as JSON
return(Json(new { Success = 0 }));
}
return(Json(new { Success = 0 }));
}
// GET: tblCourseHDs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblCourseHD tblCourseHD = db.tblCourseHDs.Find(id);
if (tblCourseHD == null)
{
return(HttpNotFound());
}
return(View(tblCourseHD));
}
public ActionResult QRCode(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblCourseHD tblCourseHD = db.tblCourseHDs.Find(id);
if (tblCourseHD == null)
{
return(HttpNotFound());
}
ViewBag.SujectID = new SelectList(db.tblSujects, "SujectID", "SujectName", tblCourseHD.SujectID);
ViewBag.teachID = new SelectList(db.tblTeachers, "teachID", "Fullname", tblCourseHD.teachID);
return(View(tblCourseHD));
}
public JsonResult EditHD(string CourseHDID,
string CourseCode,
string SujectID,
string CourseYear,
string Semester,
string teachID,
string TimeStart_txt,
string TimeEnd_txt,
string TimeLate,
string NumCheckIN,
string Entitled,
string NotEntitled,
string Contact,
string IsClose)
{
try
{
var errors = ModelState
.Where(x => x.Value.Errors.Count > 0)
.Select(x => new { x.Key, x.Value.Errors })
.ToArray();
if (ModelState.IsValid)
{
//string TempID = CourseHD.CourseHDID;
//Delete Detail Old
var CourseDT = db.tblCourseDTs.Where(h => h.CourseHDID == CourseHDID);
db.tblCourseDTs.RemoveRange(CourseDT);
db.SaveChanges();
tblCourseHD HD = new tblCourseHD();
HD.CourseHDID = CourseHDID;
HD.CourseCode = CourseCode;
HD.SujectID = SujectID;
HD.CourseYear = Convert.ToInt32(CourseYear);
HD.Semester = Convert.ToInt32(Semester);
HD.teachID = teachID;
HD.TimeStart_txt = TimeStart_txt;
HD.TimeEnd_txt = TimeEnd_txt;
HD.TimeLate = Convert.ToInt32(TimeLate);
HD.NumCheckIN = Convert.ToInt32(NumCheckIN);
HD.Entitled = Convert.ToInt32(Entitled);
HD.NotEntitled = Convert.ToInt32(NotEntitled);
HD.Contact = Convert.ToInt32(Contact);
if (IsClose == "1")
{
HD.IsClose = true;
}
else
{
HD.IsClose = false;
}
if (TimeStart_txt.Contains(":"))
{
string[] TempTimeStart = TimeStart_txt.Split(':');
HD.TimeStart = (Convert.ToInt32(TempTimeStart[0]) * 60) + Convert.ToInt32(TempTimeStart[1]);
}
else
{
HD.TimeStart = 0;
}
if (TimeEnd_txt.Contains(":"))
{
string[] TempTimeEnd = TimeEnd_txt.Split(':');
HD.TimeEnd = (Convert.ToInt32(TempTimeEnd[0]) * 60) + Convert.ToInt32(TempTimeEnd[1]);
}
else
{
HD.TimeEnd = 0;
}
db.Entry(HD).State = EntityState.Modified;
db.SaveChanges();
// If Sucess== 1 then Save/Update Successfull else there it has Exception
return(Json(new { Success = 1, ex = "HD" }));
}
}
catch (Exception ex)
{
// If Sucess== 0 then Unable to perform Save/Update Operation and send Exception to View as JSON
return(Json(new { Success = 0, ex = ex.Message.ToString() }));
}
return(Json(new { Success = 0, ex = new Exception("Unable to save").Message.ToString() }));
}
