public bool EditGradeListPoroduct([FromBody] ScoolGradesListViewModel model)
{
ScoolGradesList db = _context.ScoolGradesList.Where(p => p.SchoolId == model.SchoolId && p.ScoolGradesListID == model.ScoolGradesListID && p.ProductId == model
.ProductId).FirstOrDefault();
try
{
if (db.SchoolId == model.SchoolId && db.ScoolGradesListID == model.ScoolGradesListID && db.ProductId == model.ProductId)
{
if (model.ProducListDescription != null)
{
if (model.ProducListDescription.Length == 0)
{
model.ProducListDescription = null;
}
}
Mapper.Map(model, db);
db.Active = true;
var result = _context.ScoolGradesList.Attach(db);
_context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
var error = ex.InnerException;
return(false);
}
}
public bool DeleteGradeListPoroduct([FromBody] ScoolGradesListViewModel model)
{
ScoolGradesList db = _context.ScoolGradesList.Where(l => l.ScoolGradesListID == model.ScoolGradesListID && l.SchoolId == model.SchoolId && l.ProductId == model.ProductId).FirstOrDefault();
try
{
db.Active = false;
var result = _context.ScoolGradesList.Update(db);
_context.SaveChanges();
return(true);
}
catch (Exception ex)
{
var error = ex.InnerException;
return(false);
}
}
public bool AddGradeListPoroduct([FromBody] ScoolGradesListViewModel model)
{
ScoolGradesList db = _context.ScoolGradesList.Where(p => p.SchoolId == model.SchoolId && p.SchoolGradeId == model.SchoolGradeId && p.ProductId == model.ProductId).FirstOrDefault();
if (db != null)
{
_context.ScoolGradesList.Remove(db);
_context.SaveChanges();
}
db = _context.ScoolGradesList.Where(p => p.SchoolId == model.SchoolId && p.SchoolGradeId == model.SchoolGradeId && p.ProductId == model.ProductId).FirstOrDefault();
try
{
if (db == null)
{
ScoolGradesList savedata = new ScoolGradesList();
Mapper.Map(model, savedata);
if (model.ProducListDescription != null)
{
if (model.ProducListDescription.Trim().Length == 0)
{
savedata.ProducListDescription = null;
}
}
savedata.Active = true;
savedata.PeriodId = _IPeriods.PeriodId;
var result = _context.ScoolGradesList.Add(savedata);
_context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex) {
var error = ex.InnerException;
return(false);
}
}
