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 void ChecktblAttendance()
{
tblAttendance attendance = new tblAttendance();
attendance.courseID = 10;
Assert.IsNotNull(attendance);
Assert.AreEqual(10, attendance.courseID);
}
public ActionResult Edit(tblAttendance model, int id)
{
if (ModelState.IsValid)
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(PartialView("_Details", db.tblAttendances.ToList()));
}
public ActionResult Add(AttendanceViewModel atv)
{
if (ModelState.IsValid)
{
tblAttendance tbat = db.tblAttendances.Where(a => a.MemberId == atv.MemberId && a.AttendanceDate == DateTime.Today).FirstOrDefault();
if (tbat != null)
{
ViewBag.Message = "Attendance Already Done";
}
else
{
tblAttendance tb = new tblAttendance();
tb.MemberId = atv.MemberId;
tb.Status = atv.Status;
tb.AttendanceDate = atv.AttendanceDate;
db.tblAttendances.Add(tb);
db.SaveChanges();
ViewBag.Message = "Attendance Done Successfully";
}
}
List <MemberViewModel> lstmemvm = new List <MemberViewModel>();
var users = db.tblUsers.Where(u => u.Usertype == "User").ToList();
foreach (var item in users)
{
tblMembership tbm = db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault();
if (tbm != null)
{
lstmemvm.Add(new MemberViewModel()
{
MemberId = tbm.MembershipId, Fullname = item.Fullname
});
}
}
ViewBag.Fullname = lstmemvm;
return(View());
}
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);
}
}
}
}
