public bool Update(Batch batch)
{
using (SmartSchoolDataModel dataModel = new SmartSchoolDataModel())
{
try
{
var oldBatch = (from a in dataModel.Batches
where a.Id == batch.Id
select a).FirstOrDefault();
oldBatch.Title = batch.Title;
oldBatch.BatchCapacity = batch.BatchCapacity;
oldBatch.TimeFrom = batch.TimeFrom;
oldBatch.TimeTo = batch.TimeTo;
oldBatch.IsActive = batch.IsActive;
oldBatch.OnSunday = batch.OnSunday;
oldBatch.OnMonday = batch.OnMonday;
oldBatch.OnTuesday = batch.OnTuesday;
oldBatch.OnWednesday = batch.OnWednesday;
oldBatch.OnThursday = batch.OnThursday;
oldBatch.OnFriday = batch.OnFriday;
oldBatch.OnSaturday = batch.OnSaturday;
oldBatch.Description = batch.Description;
dataModel.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public int Insert(Batch batch)
{
using (SmartSchoolDataModel dataModel = new SmartSchoolDataModel())
{
dataModel.Batches.Add(batch);
dataModel.SaveChanges();
return(batch.Id);
}
}
public IEnumerable <Object> getBatches()
{
using (SmartSchoolDataModel dataModel = new SmartSchoolDataModel())
{
return((from a in dataModel.Batches
select new
{
Id = a.Id,
Title = a.Title + "(" + a.TimeFrom.Hour + ":" + a.TimeFrom.Minute + " - " + a.TimeTo.Hour + ":" + a.TimeTo.Minute + ")"
}).ToList());
}
}
public int Insert(FeesDetail fees)
{
using (SmartSchoolDataModel dataModel = new SmartSchoolDataModel())
{
try
{
dataModel.FeesDetails.Add(fees);
dataModel.SaveChanges();
return(fees.Id);
}
catch (Exception ex)
{
return(0);
}
}
}
public IEnumerable <Object> GetFeesDetail(int studentId)
{
using (SmartSchoolDataModel dataModel = new SmartSchoolDataModel())
{
return((from a in dataModel.FeesDetails
where a.StudentProgram.Student.Id == studentId
select new
{
Id = a.Id,
ProgramId = a.StudentProgram.ProgramId,
ProgramName = a.StudentProgram.Program.Name,
FeesPaid = a.FeesPaid,
Duration = a.Duration.ToString() + ((a.Duration == 1)? " month" : " months"),
PaidOn = a.PaidOn,
ValidTill = a.ValidTill
}).ToList());
}
}
public Object getBatchDetailById(int batchId)
{
using (SmartSchoolDataModel dataModel = new SmartSchoolDataModel())
{
return((from a in dataModel.Batches
where a.Id == batchId
select new
{
Id = a.Id,
Title = a.Title,
TimeFrom = a.TimeFrom,
TimeTo = a.TimeTo,
BatchCapacity = a.BatchCapacity,
OnSunday = a.OnSunday,
OnMonday = a.OnMonday,
OnTuesday = a.OnTuesday,
OnWednesday = a.OnWednesday,
OnThursday = a.OnThursday,
OnFriday = a.OnFriday,
OnSaturday = a.OnSaturday,
Description = a.Description
}).FirstOrDefault());
}
}
