public int Delete(DisciplineModel objectModel)
{
int count = -2;
// check the vendor information if exists in another table
if (context.tblVendors.Any(o => o.DisciplineId == objectModel.DisciplineId))
{
return(count);
}
tblDiscipline tblDisciplineDb = new tblDiscipline();
tblDisciplineDb.DisciplineId = objectModel.DisciplineId;
context.Entry(tblDisciplineDb).State = EntityState.Deleted;
count = context.SaveChanges();
if (count == 1)
{
count = 0;
}
else
{
count = -1;
}
return(count);
}
public int update(DisciplineModel objectModel)
{
tblDiscipline tblDisciplineDb = new tblDiscipline();
tblDisciplineDb.DisciplineId = objectModel.DisciplineId;
tblDisciplineDb.DisciplineName = objectModel.DisciplineName;
tblDisciplineDb.Status = objectModel.Status;
if (objectModel.DisciplineId > 0)
{
tblDisciplineDb.ModifiedBy = AdminSessionData.AdminUserId;
tblDisciplineDb.ModifiedOn = DateTime.Now;
tblDisciplineDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblDisciplines.Attach(tblDisciplineDb);
context.Entry(tblDisciplineDb).Property(x => x.DisciplineName).IsModified = true;
context.Entry(tblDisciplineDb).Property(x => x.Status).IsModified = true;
context.Entry(tblDisciplineDb).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(tblDisciplineDb).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(tblDisciplineDb).Property(x => x.ModifiedFromIP).IsModified = true;
}
else
{
tblDisciplineDb.CreatedBy = AdminSessionData.AdminUserId;
tblDisciplineDb.CreatedOn = DateTime.Now;
tblDisciplineDb.CreatedFromIp = HttpContext.Current.Request.UserHostAddress;
context.tblDisciplines.Add(tblDisciplineDb);
}
int count = context.SaveChanges();
if (count == 1)
{
count = 0;
}
else
{
count = -1;
}
return(count);
}
public int AddOtherDiscipline(string disciplineName)
{
try
{
tblDiscipline discipline = new tblDiscipline();
discipline.DisciplineName = disciplineName;
discipline.CreatedBy = 0;
discipline.CreatedOn = DateTime.UtcNow;
discipline.CreatedFromIp = HttpContext.Current.Request.UserHostAddress;
discipline.Status = 1;
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
context.tblDisciplines.Add(discipline);
context.SaveChanges();
}
return(discipline.DisciplineId);
}
catch (Exception)
{
throw;
}
}
public int ActDeact(DisciplineModel objectModel)
{
tblDiscipline tblDisciplineDb = new tblDiscipline();
tblDisciplineDb.DisciplineId = objectModel.DisciplineId;
tblDisciplineDb.Status = objectModel.Status;
context.tblDisciplines.Attach(tblDisciplineDb);
context.Entry(tblDisciplineDb).Property(x => x.Status).IsModified = true;
int count = context.SaveChanges();
if (count == 1)
{
count = 0;
}
else
{
count = -1;
}
return(count);
}
