public async Task <List <Timing> > Get()
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
var timings = mySoftCorporationDbContext.Timings.Include(t => t.User);
return(await timings.ToListAsync());
}
public bool Update(VoucherType voucherType)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
mySoftCorporationDbContext.Entry(voucherType).State = EntityState.Modified;
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
public bool Delete(Province objectFirst)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
mySoftCorporationDbContext.Entry(objectFirst).State = EntityState.Deleted;
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
public List <Company> GetAll()
{
using (var context = new MySoftCorporationDbContext())
{
return(context.Companies.ToList());
}
}
public Admission GetByID(int AdmissionID)
{
using (var mySoftCorporationDbContext = new MySoftCorporationDbContext())
{
return(mySoftCorporationDbContext.Admissions.Where(x => x.AdmissionID == AdmissionID).SingleOrDefault());
}
}
public Student GetStudentByUserId(string UserID)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
var Students = mySoftCorporationDbContext.Students.AsQueryable();
return(Students.Where(a => a.UserID.Contains(UserID)).SingleOrDefault());
}
public bool Update(Country objectFirst)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
mySoftCorporationDbContext.Entry(objectFirst).State = EntityState.Modified;
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
public bool Save(CourseCategory objectFirst)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
mySoftCorporationDbContext.CourseCategories.Add(objectFirst);
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
public Employee GetByID(int ID)
{
using (var context = new MySoftCorporationDbContext())
{
return(context.Employees.FirstOrDefault(x => x.ID == ID));
}
}
public bool Save(Province objectFirst)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
mySoftCorporationDbContext.Provinces.Add(objectFirst);
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
public bool SavePicture(Picture picture)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
mySoftCorporationDbContext.Pictures.Add(picture);
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
public VoucherType GetByID(int ID)
{
using (var mySoftCorporationDbContext = new MySoftCorporationDbContext())
{
return(mySoftCorporationDbContext.VoucherTypes.Find(ID));
}
}
public Student GetByID(int ID)
{
using (var context = new MySoftCorporationDbContext())
{
return(context.Students.Find(ID));
}
}
public bool Delete(Employee employee)
{
using (var mySoftCorporationDbContext = new MySoftCorporationDbContext())
{
mySoftCorporationDbContext.Entry(employee).State = EntityState.Deleted;
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
}
public (bool isSaved, string Error) Save(Employee employee)
{
using (var mySoftCorporationDbContext = new MySoftCorporationDbContext())
{
mySoftCorporationDbContext.Employees.Add(employee);
return(mySoftCorporationDbContext.SaveChanges() > 0, "success");
}
}
public bool Save(Company company)
{
using (var context = new MySoftCorporationDbContext())
{
context.Companies.Add(company);
return(context.SaveChanges() > 0);
}
}
public (bool IsTrue, string Msg) ApproveAdmission(Admission admission)
{
using (var db = new MySoftCorporationDbContext())
{
db.Entry(admission).State = EntityState.Modified;
return(db.SaveChanges() > 0, "Success");
}
}
public bool Save(Timing timing)
{
using (var context = new MySoftCorporationDbContext())
{
context.Timings.Add(timing);
return(context.SaveChanges() > 0);
}
}
public bool Save(Course course)
{
using (var context = new MySoftCorporationDbContext())
{
context.Courses.Add(course);
return(context.SaveChanges() > 0);
}
}
public bool Save(VoucherType voucherType)
{
using (var context = new MySoftCorporationDbContext())
{
context.VoucherTypes.Add(voucherType);
return(context.SaveChanges() > 0);
}
}
public IEnumerable <VoucherType> Search(string Search)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
var voucherTypes = mySoftCorporationDbContext.VoucherTypes.AsQueryable();
voucherTypes = voucherTypes.Where(a => a.Name == Search);
return(voucherTypes.AsEnumerable());
}
public bool Delete(Student objectFirst)
{
using (var context = new MySoftCorporationDbContext())
{
context.Entry(objectFirst).State = EntityState.Deleted;
return(context.SaveChanges() > 0);
}
}
public bool Save(Student objectFirst)
{
using (var context = new MySoftCorporationDbContext())
{
context.Students.Add(objectFirst);
return(context.SaveChanges() > 0);
}
}
public bool Update(Company company)
{
using (var newContext = new MySoftCorporationDbContext())
{
newContext.Entry(company).State = EntityState.Modified;
return(newContext.SaveChanges() > 0);
}
}
public bool Update(Timing timing)
{
using (var mySoftCorporationDbContext = new MySoftCorporationDbContext())
{
mySoftCorporationDbContext.Entry(timing).State = EntityState.Modified;
return(mySoftCorporationDbContext.SaveChanges() > 0);
}
}
public bool Delete(Course course)
{
using (var context = new MySoftCorporationDbContext())
{
context.Entry(course).State = EntityState.Deleted;
return(context.SaveChanges() > 0);
}
}
public Province GetByID(int ID)
{
using (MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext())
{
return(mySoftCorporationDbContext.Provinces.Find(ID));
//return mySoftCorporationDbContext.Provinces.Include(x => x.ID).SingleOrDefault(x => x.ID = ID);
}
}
public Company GetByID(int ID)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
//using (mySoftCorporationDbContext)
//{
return(mySoftCorporationDbContext.Companies.Find(ID));
//}
}
public bool Update(CourseCategory objectFirst)
{
var oldContext = new MySoftCorporationDbContext();
var oldCourseCategory = oldContext.CourseCategories.Find(objectFirst.ID);
var NewContext = new MySoftCorporationDbContext();
NewContext.Entry(objectFirst).State = EntityState.Modified;
return(oldContext.SaveChanges() > 0);
}
public bool Update(Course course)
{
MySoftCorporationDbContext mySoftCorporationDbContext = new MySoftCorporationDbContext();
var PreviousContext = mySoftCorporationDbContext.Courses.Find(course.ID);
mySoftCorporationDbContext.CoursePictures.RemoveRange(PreviousContext.CoursePictures);
mySoftCorporationDbContext.Entry(PreviousContext).CurrentValues.SetValues(course);
mySoftCorporationDbContext.CoursePictures.AddRange(course.CoursePictures);
return(mySoftCorporationDbContext.SaveChanges() > 0);
}