public void UpdateStatus(DTO.LABURNUM.COM.AttendanceClass2Model model) { if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password)) { new FrontEndApi.AttendanceClass2Api().UpdateIsActive(model); } }
public long Add(DTO.LABURNUM.COM.AttendanceClass2Model model) { if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password)) { return(new FrontEndApi.AttendanceClass2Api().Add(model)); } else { return(-1); } }
public void UpdateIsActive(DTO.LABURNUM.COM.AttendanceClass2Model model) { model.AttendanceClass2Id.TryValidate(); IQueryable <API.LABURNUM.COM.AttendanceClass2> iQuery = this._laburnum.AttendanceClass2.Where(x => x.AttendanceClass2Id == model.AttendanceClass2Id && x.IsActive == true); List <API.LABURNUM.COM.AttendanceClass2> dbAttendanceClass2 = iQuery.ToList(); if (dbAttendanceClass2.Count == 0) { throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND); } if (dbAttendanceClass2.Count > 1) { throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND); } dbAttendanceClass2[0].IsActive = model.IsActive; dbAttendanceClass2[0].LastUpdated = new Component.Utility().GetISTDateTime(); this._laburnum.SaveChanges(); }
private long AddAttendanceClass2(DTO.LABURNUM.COM.AttendanceClass2Model model) { API.LABURNUM.COM.AttendanceClass2 apiAClass2 = new AttendanceClass2() { StudentId = model.StudentId, ClassId = model.ClassId, SectionId = model.SectionId, MorningAttendanceDate = model.MorningAttendanceDate, IsPresentAfterLuch = model.IsPresentAfterLuch, IsPresentInMorning = model.IsPresentInMorning, CreatedOn = new Component.Utility().GetISTDateTime(), IsActive = true, FacultyId = model.FacultyId }; this._laburnum.AttendanceClass2.Add(apiAClass2); this._laburnum.SaveChanges(); return(apiAClass2.AttendanceClass2Id); }
private DTO.LABURNUM.COM.AttendanceClass2Model MapCore(API.LABURNUM.COM.AttendanceClass2 apiclass) { DTO.LABURNUM.COM.AttendanceClass2Model dtoClass = new DTO.LABURNUM.COM.AttendanceClass2Model() { AttendanceClass2Id = apiclass.AttendanceClass2Id, ClassId = apiclass.ClassId, SectionId = apiclass.SectionId, StudentId = apiclass.StudentId, MorningAttendanceDate = apiclass.MorningAttendanceDate, LunchAttendanceDate = apiclass.LunchAttendanceDate.GetValueOrDefault().Year != 0001 ? apiclass.LunchAttendanceDate : null, IsPresentAfterLuch = apiclass.IsPresentAfterLuch, IsPresentInMorning = apiclass.IsPresentInMorning, CreatedOn = apiclass.CreatedOn, IsActive = apiclass.IsActive, LastUpdated = apiclass.LastUpdated, StudentName = apiclass.Student.FirstName + " " + apiclass.Student.MiddleName + " " + apiclass.Student.LastName, FatherName = apiclass.Student.FatherName, AttendanceId = apiclass.AttendanceClass2Id, }; return(dtoClass); }
public static void TryValidate(this DTO.LABURNUM.COM.AttendanceClass2Model item) { item.ClassId.TryValidate(); item.SectionId.TryValidate(); item.StudentId.TryValidate(); }
public List <DTO.LABURNUM.COM.AttendanceClass2Model> SearchAttendanceClass2ByAdvanceSearch(DTO.LABURNUM.COM.AttendanceClass2Model model) { if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password)) { return(new AttendanceClass2Helper(new FrontEndApi.AttendanceClass2Api().GetAttendanceClass2ByAdvanceSearch(model)).Map()); } else { return(null); } }
public List <API.LABURNUM.COM.AttendanceClass2> GetAttendanceClass2ByAdvanceSearch(DTO.LABURNUM.COM.AttendanceClass2Model model) { IQueryable <API.LABURNUM.COM.AttendanceClass2> iQuery = null; if (model.AttendanceClass2Id > 0) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.AttendanceClass2Id == model.AttendanceClass2Id && x.IsActive == true); } //Search By Class Id. if (iQuery != null) { if (model.ClassId > 0) { iQuery = iQuery.Where(x => x.ClassId == model.ClassId && x.IsActive == true); } } else { if (model.ClassId > 0) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.ClassId == model.ClassId && x.IsActive == true); } } //Search By Section Id. if (iQuery != null) { if (model.SectionId > 0) { iQuery = iQuery.Where(x => x.SectionId == model.SectionId && x.IsActive == true); } } else { if (model.SectionId > 0) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.SectionId == model.SectionId && x.IsActive == true); } } //Search By Section Id. if (iQuery != null) { if (model.SectionId > 0) { iQuery = iQuery.Where(x => x.SectionId == model.SectionId && x.IsActive == true); } } else { if (model.SectionId > 0) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.SectionId == model.SectionId && x.IsActive == true); } } //Search By Student Id. if (iQuery != null) { if (model.StudentId > 0) { iQuery = iQuery.Where(x => x.StudentId == model.StudentId && x.IsActive == true); } } else { if (model.StudentId > 0) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.StudentId == model.StudentId && x.IsActive == true); } } //Search By IsPresentInMorning. if (iQuery != null) { if (model.IsPresentInMorning) { iQuery = iQuery.Where(x => x.IsPresentInMorning == model.IsPresentInMorning && x.IsActive == true); } } else { if (model.IsPresentInMorning) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.IsPresentInMorning == model.IsPresentInMorning && x.IsActive == true); } } //Search By IsPresentAfterLuch. if (iQuery != null) { if (model.IsPresentAfterLuch) { iQuery = iQuery.Where(x => x.IsPresentAfterLuch == model.IsPresentAfterLuch && x.IsActive == true); } } else { if (model.IsPresentAfterLuch) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.IsPresentAfterLuch == model.IsPresentAfterLuch && x.IsActive == true); } } //Search By Date Range. if (iQuery != null) { if (model.StartDate.Year != 0001) { model.StartDate = new Component.Utility().GetDate(model.StartDate); } if (model.EndDate.Year != 0001) { model.EndDate = new Component.Utility().GetDate(model.EndDate).AddDays(1).AddSeconds(-1); } if (model.EndDate.Year == 0001) { model.EndDate = model.StartDate.AddDays(1).AddSeconds(-1); } if (model.StartDate.Year != 0001) { iQuery = iQuery.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true); } } else { if (model.StartDate.Year != 0001) { model.StartDate = new Component.Utility().GetDate(model.StartDate); } if (model.EndDate.Year != 0001) { model.EndDate = new Component.Utility().GetDate(model.EndDate).AddDays(1).AddSeconds(-1); } if (model.EndDate.Year == 0001) { model.EndDate = model.StartDate.AddDays(1).AddSeconds(-1); } if (model.StartDate.Year != 0001) { iQuery = this._laburnum.AttendanceClass2.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true); } } List <API.LABURNUM.COM.AttendanceClass2> dbAttendanceClass2 = iQuery.ToList(); return(dbAttendanceClass2); }
public long Add(DTO.LABURNUM.COM.AttendanceClass2Model model) { return(AddValidation(model)); }
private long AddValidation(DTO.LABURNUM.COM.AttendanceClass2Model model) { model.TryValidate(); return(AddAttendanceClass2(model)); }