public void UpdateStatus(DTO.LABURNUM.COM.HomeWorkModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
new FrontEndApi.HomeWorkApi().UpdateIsActive(model);
}
}
private long AddValidation(DTO.LABURNUM.COM.HomeWorkModel model)
{
model.FacultyId.TryValidate();
model.ClassId.TryValidate();
model.SectionId.TryValidate();
model.HomeWorkText.TryValidate();
return(AddHomeWork(model));
}
public dynamic SearchHomeWorkByAdvanceSearch(DTO.LABURNUM.COM.HomeWorkModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(GetApiResponseModel("Successfully Performed.", true, new HomeWorkHelper(new FrontEndApi.HomeWorkApi().GetHomeWorkByAdvanceSearch(model)).Map()));
}
else
{
return(GetApiResponseModel("Api Access User Name or Password Invalid.", false, null));
}
}
public List <DTO.LABURNUM.COM.HomeWorkModel> SearchHomeWorkByAdvanceSearch(DTO.LABURNUM.COM.HomeWorkModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new HomeWorkHelper(new FrontEndApi.HomeWorkApi().GetHomeWorkByAdvanceSearch(model)).Map());
}
else
{
return(null);
}
}
public long Add(DTO.LABURNUM.COM.HomeWorkModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new FrontEndApi.HomeWorkApi().Add(model));
}
else
{
return(-1);
}
}
private long AddHomeWork(DTO.LABURNUM.COM.HomeWorkModel model)
{
API.LABURNUM.COM.HomeWork apiHomeWork = new HomeWork()
{
FacultyId = model.FacultyId,
ClassId = model.ClassId,
SectionId = model.SectionId,
SubjectId = model.SubjectId,
Attachment = model.Attachment,
HomeWorkText = model.HomeWorkText,
CreatedOn = new Component.Utility().GetISTDateTime(),
IsActive = true
};
this._laburnum.HomeWork.Add(apiHomeWork);
this._laburnum.SaveChanges();
return(apiHomeWork.HomeWorkId);
}
public void UpdateIsActive(DTO.LABURNUM.COM.HomeWorkModel model)
{
model.HomeWorkId.TryValidate();
IQueryable <API.LABURNUM.COM.HomeWork> iQuery = this._laburnum.HomeWork.Where(x => x.HomeWorkId == model.HomeWorkId && x.IsActive == true);
List <API.LABURNUM.COM.HomeWork> dbHomeWorkes = iQuery.ToList();
if (dbHomeWorkes.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbHomeWorkes.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbHomeWorkes[0].IsActive = model.IsActive;
dbHomeWorkes[0].LastUpdated = new Component.Utility().GetISTDateTime();
this._laburnum.SaveChanges();
}
private DTO.LABURNUM.COM.HomeWorkModel MapCore(API.LABURNUM.COM.HomeWork model)
{
DTO.LABURNUM.COM.HomeWorkModel dtoClass = new DTO.LABURNUM.COM.HomeWorkModel()
{
HomeWorkId = model.HomeWorkId,
FacultyId = model.FacultyId,
SubjectId = model.SubjectId,
ClassId = model.ClassId,
SectionId = model.SectionId,
HomeWorkText = model.HomeWorkText,
FacultyName = model.Faculty.FacultyName,
SubjectName = model.Subject.SubjectName,
ClassName = model.Class.ClassName,
SectionName = model.Section.SectionName,
Attachment = model.Attachment,
CreatedOn = model.CreatedOn,
IsActive = model.IsActive,
LastUpdated = model.LastUpdated
};
return(dtoClass);
}
public dynamic UpdateHomeWork(DTO.LABURNUM.COM.HomeWorkModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
if (model.HomeWorkId == 0 || model.HomeWorkId < 0)
{
return(GetApiResponseModel("HomeWork Id Cannot be Zero", true, null));
}
if (model.HomeWorkText.Trim() == null)
{
return(GetApiResponseModel("HomeWork Text Cannot be Null", true, null));
}
if (model.HomeWorkText.Trim() == "")
{
return(GetApiResponseModel("HomeWork Text Cannot be Blank", true, null));
}
new FrontEndApi.HomeWorkApi().Update(model);
return(GetApiResponseModel("Home Work Updated Successfully.", true, null));
}
else
{
return(GetApiResponseModel("Api Access User Name or Password Invalid.", false, null));
}
}
public dynamic AddHomeWork(DTO.LABURNUM.COM.HomeWorkModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
if (model.FacultyId == 0)
{
return(GetApiResponseModel("Faculty Id Cannot be Zero", true, null));
}
if (model.ClassId == 0)
{
return(GetApiResponseModel("Class Id Cannot be Zero", true, null));
}
if (model.SectionId == 0)
{
return(GetApiResponseModel("Section Id Cannot be Zero", true, null));
}
if (model.SubjectId == 0)
{
return(GetApiResponseModel("Subject Id Cannot be Zero", true, null));
}
if (model.HomeWorkText.Trim() == null)
{
return(GetApiResponseModel("HomeWork Text Cannot be Null", true, null));
}
if (model.HomeWorkText.Trim() == "")
{
return(GetApiResponseModel("Home Work Cannot be Blank", true, null));
}
long homeworkid = new FrontEndApi.HomeWorkApi().Add(model);
return(GetApiResponseModel("Home Work Posted Successfully.", true, homeworkid));
}
else
{
return(GetApiResponseModel("Api Access User Name or Password Invalid.", false, null));
}
}
public long Add(DTO.LABURNUM.COM.HomeWorkModel model)
{
return(AddValidation(model));
}
public List <API.LABURNUM.COM.HomeWork> GetHomeWorkByAdvanceSearch(DTO.LABURNUM.COM.HomeWorkModel model)
{
IQueryable <API.LABURNUM.COM.HomeWork> iQuery = null;
//Search By Home Work Id
if (model.HomeWorkId > 0)
{
iQuery = this._laburnum.HomeWork.Where(x => x.HomeWorkId == model.HomeWorkId && x.IsActive == true);
}
//Search By Home Work Text.
if (iQuery != null)
{
if (model.HomeWorkText != null)
{
iQuery = iQuery.Where(x => x.HomeWorkText.Trim().ToLower().Contains(model.HomeWorkText.Trim().ToLower()) && x.IsActive == true);
}
}
else
{
if (model.HomeWorkText != null)
{
iQuery = this._laburnum.HomeWork.Where(x => x.HomeWorkText.Trim().ToLower().Contains(model.HomeWorkText.Trim().ToLower()) && x.IsActive == true);
}
}
//Search By FacultyID.
if (iQuery != null)
{
if (model.FacultyId > 0)
{
iQuery = iQuery.Where(x => x.FacultyId == model.FacultyId && x.IsActive == true);
}
}
else
{
if (model.FacultyId > 0)
{
iQuery = this._laburnum.HomeWork.Where(x => x.FacultyId == model.FacultyId && x.IsActive == true);
}
}
//Search By ClassId.
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.HomeWork.Where(x => x.ClassId == model.ClassId && x.IsActive == true);
}
}
//Search By SectionId.
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.HomeWork.Where(x => x.SectionId == model.SectionId && x.IsActive == true);
}
}
//Search By SubjectId.
if (iQuery != null)
{
if (model.SubjectId > 0)
{
iQuery = iQuery.Where(x => x.SubjectId == model.SubjectId && x.IsActive == true);
}
}
else
{
if (model.SectionId > 0)
{
iQuery = this._laburnum.HomeWork.Where(x => x.SubjectId == model.SubjectId && 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);
}
//if (model.StartDate.Year != 0001)
//{
// if (model.EndDate.Year == 0001) { model.EndDate = model.StartDate.AddDays(1).AddSeconds(-1); }
// if (model.EndDate.Year != 0001) { model.EndDate = model.EndDate.AddDays(1).AddSeconds(-1); }
// 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.HomeWork.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true);
}
//if (model.StartDate.Year != 0001)
//{
// if (model.EndDate.Year == 0001) { model.EndDate = model.StartDate.AddDays(1).AddSeconds(-1); }
// if (model.EndDate.Year != 0001) { model.EndDate = model.EndDate.AddDays(1).AddSeconds(-1); }
// iQuery = this._laburnum.HomeWork.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true);
//}
}
List <API.LABURNUM.COM.HomeWork> dbHomeWorkes = iQuery.ToList();
return(dbHomeWorkes);
}
