public Response Update_tbAttendance(AttendanceCustomModel objModel)
{
DateTime DateCheck = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0));
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
tblAttendance cmd = dbcontext.tblAttendances.FirstOrDefault(x =>
x.IsDeleted == false && x.AdmissionId == objModel.AdmissionId &&
x.AttendanceDate.Year == DateCheck.Year &&
x.AttendanceDate.Month == DateCheck.Month &&
x.AttendanceDate.Day == DateCheck.Day &&
x.SectionId == objModel.SectionId
);
if (cmd != null)
{
cmd.Attendance = objModel.Attendance;
dbcontext.SaveChanges();
response.message = "Record Updated Successfully!!";
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public Response GetAttendanceListing(AttendanceCustomModel objModel)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
var rs = dbcontext.USP_GetAttendanceDetail(objModel.SectionId, objModel.AttendanceDate).ToList();
if (rs.Count > 0)
{
//return rs;
response.message = "Update";
response.responseData = rs;
}
else
{
var rs2 = dbcontext.USP_BindStudentWithClassAndSection(objModel.SessionId, objModel.ClassId, objModel.SectionId, "").ToList();
//return rs2;
response.message = "Insert";
response.responseData = rs2;
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
//return response;
}
}
public Response SaveAttendanceDetails(AttendanceCustomModel objModel)
{
using (objDAL = new AttendanceRepo())
{
return(objDAL.SaveAttendanceDetails(objModel));
}
}
public Response GetAttendanceListing(AttendanceCustomModel objModel)
{
using (objDAL = new AttendanceRepo())
{
return(objDAL.GetAttendanceListing(objModel));
}
}
public ActionResult SearchAttendanceAllocationList(int?SessionId, int?ClassId, int?SectionId, string StudentName, DateTime AttendanceDate)
{
AttendanceCustomModel objModel = new AttendanceCustomModel();
objModel.SectionId = SectionId;
objModel.AttendanceDate = AttendanceDate;
objBDC = new AttendanceBusiness();
ViewBag.AllocationDetail = objBDC.GetAttendanceListing(objModel).responseData;
ViewBag.AllocationAction = objBDC.GetAttendanceListing(objModel).message;
return(PartialView("SearchAttendanceAllocationList"));
}
public ActionResult SubmitAttendanceDetails(string[] Parameters, string[] ParametersValue, int SectionId, DateTime AttendanceDate, string AttendanceAction)
{
string ResultMessage = "";
try
{
int TotalStudent = 0;
objBDC = new AttendanceBusiness();
AttendanceCustomModel objModel = new AttendanceCustomModel();
if (AttendanceAction == "Insert")
{
foreach (var nw in Parameters.Zip(ParametersValue, Tuple.Create))
{
//Console.WriteLine(nw.Item1 + nw.Item2);
objModel.AdmissionId = Convert.ToInt32(nw.Item1);
objModel.Attendance = Convert.ToString(nw.Item2);
objModel.SectionId = SectionId;
objModel.AttendanceDate = AttendanceDate;
objBDC.SaveAttendanceDetails(objModel);
}
}
else if (AttendanceAction == "Update")
{
foreach (var nw in Parameters.Zip(ParametersValue, Tuple.Create))
{
//Console.WriteLine(nw.Item1 + nw.Item2);
objModel.AdmissionId = Convert.ToInt32(nw.Item1);
objModel.Attendance = Convert.ToString(nw.Item2);
objModel.SectionId = SectionId;
objModel.AttendanceDate = AttendanceDate;
objBDC.SaveAttendanceDetails(objModel);
}
}
ResultMessage = "Student Allocated in batch Successfully.";
}
catch (Exception ex)
{
}
return(View(ResultMessage));
}
public Response SaveAttendanceDetails(AttendanceCustomModel objModel)
{
DateTime DateCheck = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0));
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
var rs = dbcontext.tblAttendances.FirstOrDefault(x =>
x.IsDeleted == false && x.AdmissionId == objModel.AdmissionId &&
x.AttendanceDate.Year == DateCheck.Year &&
x.AttendanceDate.Month == DateCheck.Month &&
x.AttendanceDate.Day == DateCheck.Day &&
x.Attendance == objModel.Attendance &&
x.SectionId == objModel.SectionId
);
if (rs == null)
{
tblAttendance objAddNew = new tblAttendance
{
EnquiryId = objModel.EnquiryId,
AdmissionId = objModel.AdmissionId,
SectionId = objModel.SectionId ?? 0,
AttendanceDate = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0)),
Attendance = objModel.Attendance,
Reason = objModel.Reason,
IsActive = true,
IsDeleted = false,
CreatedBy = objModel.CreatedBy,
CreatedDate = DateTime.Now,
ModifiedBy = objModel.ModifiedBy,
ModifiedDate = DateTime.Now
};
dbcontext.tblAttendances.Add(objAddNew);
dbcontext.SaveChanges();
response.responseData = new { AttendanceId = objAddNew.AdmissionId, AdmissionDate = objAddNew.AttendanceDate };
response.message = "Record Added Successfully!";
}
else
{
response.success = false;
response.message = "Record Already Exists!";
}
//var rs = dbcontext.tblAttendances.FirstOrDefault(x => x.IsDeleted == false && x.AttendanceDate == objModel.AttendanceDate && x.AttendanceId != objModel.AttendanceId);
//if (rs == null)
//{
// var objUpdate = dbcontext.tblAttendances.FirstOrDefault(m => m.AttendanceId == objModel.AttendanceId);
// if (objUpdate != null)
// {
// objUpdate.EnquiryId = objModel.EnquiryId;
// objUpdate.AdmissionId = objModel.AdmissionId;
// objUpdate.SectionId = objModel.SectionId ?? 0;
// objUpdate.AttendanceDate = objModel.AttendanceDate;
// objUpdate.Attendance = objModel.Attendance;
// objUpdate.Reason = objModel.Reason;
// objUpdate.ModifiedBy = objModel.ModifiedBy;
// objUpdate.ModifiedDate = DateTime.Now;
// dbcontext.SaveChanges();
// response.responseData = new { AttendanceId = objUpdate.AdmissionId, AdmissionDate = objUpdate.AttendanceDate };
// response.message = "Record Updated Successfully!";
// }
//}
//else
//{
// response.success = false;
// response.message = "Record Already Exists!";
//}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public ActionResult Index(AttendanceCustomModel collection)
{
return(View());
}
