public static void UpdateDanceGroup(DanceGroupModel model)
{
using (var ctx = new DFAppEntities())
{
DBModel.DanceGroups t = ctx.DanceGroups.FirstOrDefault(x => x.DanceGroupID == model.DanceGroupID);
if (t != null)
{
if (!string.IsNullOrEmpty(model.DanceGroupName))
{
t.DanceGroupName = model.DanceGroupName;
}
if (!string.IsNullOrEmpty(model.DanceGroupDesc))
{
t.DanceGroupDesc = model.DanceGroupDesc;
}
if (model.AgeCategoryID.HasValue)
{
t.AgeCategoryID = model.AgeCategoryID;
}
ctx.SaveChanges();
}
}
}
public static ApiTableResponseModel <DanceGroupModel> GetDanceGroups(DanceGroupModel filter)
{
ApiTableResponseModel <DanceGroupModel> response = new ApiTableResponseModel <DanceGroupModel>();
using (var ctx = new DFAppEntities())
{
var q = ctx.DanceGroups
.Include(t => t.Lookup_AgeCategories)
.AsQueryable();
if (!string.IsNullOrEmpty(filter.DanceGroupName))
{
q = q.Where(x => x.DanceGroupName.ToLower().Contains(filter.DanceGroupName.ToLower()));
}
if (string.IsNullOrEmpty(filter.OrderByClause))
{
// default order
filter.OrderByClause = "DanceGroupName";
}
if (filter.PageNo < 1)
{
filter.PageNo = 1;
}
if (filter.RecordsPerPage < 1)
{
// unlimited
filter.RecordsPerPage = 1000000;
}
response.Total = q.Count();
var Data =
q.ToList()
.Select(x =>
new DanceGroupModel()
{
DanceGroupID = x.DanceGroupID,
DanceGroupName = x.DanceGroupName,
DanceGroupDesc = x.DanceGroupDesc,
AgeCategoryID = x.AgeCategoryID,
AgeCategory = (x.Lookup_AgeCategories != null) ? x.Lookup_AgeCategories.Name : string.Empty
}
)
.OrderBy(filter.OrderByClause)
.Skip((filter.PageNo - 1) * filter.RecordsPerPage)
.Take(filter.RecordsPerPage);
response.Data = Data;
}
return(response);
}
public DanceGroupModel CreateDanceGroup(DanceGroupModel model)
{
try
{
return(DB.DanceGroups.CreateDanceGroup(model));
}
catch (Exception ex)
{
throw new HttpResponseException(
new HttpResponseMessage()
{
StatusCode = HttpStatusCode.Forbidden,
ReasonPhrase = ex.Message
});
}
}
public static DanceGroupModel CreateDanceGroup(DanceGroupModel model)
{
using (var ctx = new DFAppEntities())
{
DBModel.DanceGroups existing = ctx.DanceGroups.FirstOrDefault(x => x.DanceGroupName.ToLower() == model.DanceGroupName.ToLower());
if (existing != null)
{
throw new Exception("Grupa sa datim imenom već postoji.");
}
DBModel.DanceGroups dg = new DBModel.DanceGroups();
dg.DanceGroupName = model.DanceGroupName;
dg.DanceGroupDesc = model.DanceGroupDesc;
dg.AgeCategoryID = model.AgeCategoryID;
ctx.DanceGroups.Add(dg);
ctx.SaveChanges();
model.DanceGroupID = dg.DanceGroupID;
return(model);
}
}
public void UpdateDanceGroup(DanceGroupModel model)
{
DB.DanceGroups.UpdateDanceGroup(model);
}
public ApiTableResponseModel <DanceGroupModel> GetDanceGroups(DanceGroupModel filter)
{
return(DB.DanceGroups.GetDanceGroups(filter));
}
