public void UpdateStatus(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
new FrontEndApi.ClassSubjectFacultyTableApi().UpdateIsActive(model);
}
}
private long AddValidation(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
model.ClassId.TryValidate();
// model.SubjectId.TryValidate();
model.FacultyId.TryValidate();
model.SectionId.TryValidate();
return(AddClassSubjectFacultyTable(model));
}
public long Add(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new FrontEndApi.ClassSubjectFacultyTableApi().Add(model));
}
else
{
return(-1);
}
}
private long AddClassSubjectFacultyTable(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
API.LABURNUM.COM.ClassSubjectFacultyTable apiClassSubjectFacultyTable = new ClassSubjectFacultyTable()
{
ClassId = model.ClassId,
SubjectId = model.SubjectId,
FacultyId = model.FacultyId,
SectionId = model.SectionId,
CreatedOn = new Component.Utility().GetISTDateTime(),
IsActive = true
};
this._laburnum.ClassSubjectFacultyTables.Add(apiClassSubjectFacultyTable);
this._laburnum.SaveChanges();
return(apiClassSubjectFacultyTable.ClassSubjectFacultyTableId);
}
/// <summary>
/// Search Assigned Classes to Faculties.
/// </summary>
/// <param name="model">Accepting Faculty Id To Search Details</param>
/// <returns>Returng Assigned Classes to Faculties.</returns>
public dynamic SearchAssignedClassForFaculties(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel 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));
}
return(GetApiResponseModel("Successfully Performed.", true, new ClassSubjectFacultyTableHelper(new FrontEndApi.ClassSubjectFacultyTableApi().GetClassSubjectFacultyTableByAdvanceSearch(model)).Map()));
}
else
{
return(GetApiResponseModel("Api Access User Name or Password Invalid.", false, null));
}
}
public void UpdateIsActive(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
model.ClassSubjectFacultyTableId.TryValidate();
IQueryable <API.LABURNUM.COM.ClassSubjectFacultyTable> iQuery = this._laburnum.ClassSubjectFacultyTables.Where(x => x.ClassSubjectFacultyTableId == model.ClassSubjectFacultyTableId && x.IsActive == true);
List <API.LABURNUM.COM.ClassSubjectFacultyTable> dbRoutes = iQuery.ToList();
if (dbRoutes.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbRoutes.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbRoutes[0].IsActive = model.IsActive;
dbRoutes[0].LastUpdated = new Component.Utility().GetISTDateTime();
this._laburnum.SaveChanges();
}
private DTO.LABURNUM.COM.ClassSubjectFacultyTableModel MapCore(API.LABURNUM.COM.ClassSubjectFacultyTable apiModel)
{
DTO.LABURNUM.COM.ClassSubjectFacultyTableModel dtoClass = new DTO.LABURNUM.COM.ClassSubjectFacultyTableModel()
{
ClassSubjectFacultyTableId = apiModel.ClassSubjectFacultyTableId,
ClassId = apiModel.ClassId,
SubjectId = apiModel.SubjectId.GetValueOrDefault() != 0 ? apiModel.SubjectId : null,
FacultyId = apiModel.FacultyId,
SectionId = apiModel.SectionId,
CreatedOn = apiModel.CreatedOn,
LastUpdated = apiModel.LastUpdated,
IsActive = apiModel.IsActive,
ClassName = apiModel.Class.ClassName,
SubjectName = apiModel.SubjectId.GetValueOrDefault() != 0 ? apiModel.Subject.SubjectName : "",
FacultyName = apiModel.Faculty.FacultyName,
SectionName = apiModel.Section.SectionName,
FacultyContact = apiModel.Faculty.ContactNumber,
FacultyEmail = apiModel.Faculty.Email,
};
return(dtoClass);
}
public long Add(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
return(AddValidation(model));
}
public List <API.LABURNUM.COM.ClassSubjectFacultyTable> GetClassSubjectFacultyTableByAdvanceSearch(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
IQueryable <API.LABURNUM.COM.ClassSubjectFacultyTable> iQuery = null;
//Search Bus Route Id.
if (model.ClassSubjectFacultyTableId > 0)
{
iQuery = this._laburnum.ClassSubjectFacultyTables.Where(x => x.ClassSubjectFacultyTableId == model.ClassSubjectFacultyTableId && 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.ClassSubjectFacultyTables.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.ClassSubjectFacultyTables.Where(x => x.SectionId == model.SectionId && x.IsActive == true);
}
}
//Search ByFacultyId
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.ClassSubjectFacultyTables.Where(x => x.FacultyId == model.FacultyId && 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.SubjectId > 0)
{
iQuery = this._laburnum.ClassSubjectFacultyTables.Where(x => x.SubjectId == model.SubjectId && x.IsActive == true);
}
}
List <API.LABURNUM.COM.ClassSubjectFacultyTable> dbClassSubjectFacultyTable = iQuery.ToList();
return(dbClassSubjectFacultyTable);
}
public List <DTO.LABURNUM.COM.ClassSubjectFacultyTableModel> SearchClassSubjectFacultyByAdvanceSearch(DTO.LABURNUM.COM.ClassSubjectFacultyTableModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new ClassSubjectFacultyTableHelper(new FrontEndApi.ClassSubjectFacultyTableApi().GetClassSubjectFacultyTableByAdvanceSearch(model)).Map());
}
else
{
return(null);
}
}
