public void UpdateStatus(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
new FrontEndApi.CircularNotificationTableApi().UpdateIsActive(model);
}
}
public long Add(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new FrontEndApi.CircularNotificationTableApi().Add(model));
}
else
{
return(-1);
}
}
private DTO.LABURNUM.COM.CircularNotificationTableModel MapCore(API.LABURNUM.COM.CircularNotificationTable model)
{
DTO.LABURNUM.COM.CircularNotificationTableModel dtoClass = new DTO.LABURNUM.COM.CircularNotificationTableModel()
{
CircularNotificationTableId = model.CircularNotificationTableId,
CircularId = model.CircularId,
IsForAdmin = model.IsForAdmin,
IsForFaculty = model.IsForFaculty,
IsForParents = model.IsForParents,
IsForStudent = model.IsForStudent,
ClassIds = model.ClassIds,
CreatedOn = model.CreatedOn,
IsActive = model.IsActive,
LastUpdated = model.LastUpdated
};
return(dtoClass);
}
public void UpdateIsActive(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
model.CircularNotificationTableId.TryValidate();
IQueryable <API.LABURNUM.COM.CircularNotificationTable> iQuery = this._laburnum.CircularNotificationTables.Where(x => x.CircularNotificationTableId == model.CircularNotificationTableId && x.IsActive == true);
List <API.LABURNUM.COM.CircularNotificationTable> 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 long AddCircularNotificationTable(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
API.LABURNUM.COM.CircularNotificationTable apiCircularNotificationTable = new CircularNotificationTable()
{
CircularId = model.CircularId,
ClassIds = model.ClassIds,
IsForAdmin = model.IsForAdmin,
IsForFaculty = model.IsForFaculty,
IsForParents = model.IsForParents,
IsForStudent = model.IsForStudent,
LastUpdated = model.LastUpdated,
CreatedOn = new Component.Utility().GetISTDateTime(),
IsActive = true
};
this._laburnum.CircularNotificationTables.Add(apiCircularNotificationTable);
this._laburnum.SaveChanges();
return(apiCircularNotificationTable.CircularNotificationTableId);
}
public long Add(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
return(AddValidation(model));
}
private long AddValidation(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
model.CircularId.TryValidate();
return(AddCircularNotificationTable(model));
}
public List <API.LABURNUM.COM.CircularNotificationTable> GetCircularNotificationTableByAdvanceSearch(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
IQueryable <API.LABURNUM.COM.CircularNotificationTable> iQuery = null;
//Search CircularNotificationTableId.
if (model.CircularNotificationTableId > 0)
{
iQuery = this._laburnum.CircularNotificationTables.Where(x => x.CircularNotificationTableId == model.CircularNotificationTableId && x.IsActive == true);
}
//Search For Admin.
if (iQuery != null)
{
if (model.IsForAdmin == true)
{
iQuery = iQuery.Where(x => x.IsForAdmin == model.IsForAdmin && x.IsActive == true);
}
}
else
{
if (model.IsForAdmin == true)
{
iQuery = this._laburnum.CircularNotificationTables.Where(x => x.IsForAdmin == model.IsForAdmin && x.IsActive == true);
}
}
//Search For IsForFaculty.
if (iQuery != null)
{
if (model.IsForFaculty == true)
{
iQuery = iQuery.Where(x => x.IsForFaculty == model.IsForFaculty && x.IsActive == true);
}
}
else
{
if (model.IsForFaculty == true)
{
iQuery = this._laburnum.CircularNotificationTables.Where(x => x.IsForFaculty == model.IsForFaculty && x.IsActive == true);
}
}
//Search For IsForParents.
if (iQuery != null)
{
if (model.IsForParents == true)
{
iQuery = iQuery.Where(x => x.IsForParents == model.IsForParents && x.IsActive == true);
}
}
else
{
if (model.IsForAdmin == true)
{
iQuery = this._laburnum.CircularNotificationTables.Where(x => x.IsForParents == model.IsForParents && x.IsActive == true);
}
}
//Search For IsForStudent.
if (iQuery != null)
{
if (model.IsForStudent == true)
{
iQuery = iQuery.Where(x => x.IsForStudent == model.IsForStudent && x.IsActive == true);
}
}
else
{
if (model.IsForStudent == true)
{
iQuery = this._laburnum.CircularNotificationTables.Where(x => x.IsForStudent == model.IsForStudent && 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.CircularNotificationTables.Where(x => x.CreatedOn >= model.StartDate && x.CreatedOn <= model.EndDate && x.IsActive == true);
}
}
List <API.LABURNUM.COM.CircularNotificationTable> dbCircularNotificationTable = iQuery.ToList();
return(dbCircularNotificationTable);
}
public List <DTO.LABURNUM.COM.CircularNotificationTableModel> SearchCircularNotificationTableByAdvanceSearch(DTO.LABURNUM.COM.CircularNotificationTableModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new CircularNotificationTableHelper(new FrontEndApi.CircularNotificationTableApi().GetCircularNotificationTableByAdvanceSearch(model)).Map());
}
else
{
return(null);
}
}
