public void inserir(ClassificacaoPlano entidade)
{
using (var context = new CrudDbContext())
{
context.ClassificacaoPlano.Add(entidade);
context.SaveChanges();
}
}
public StudentUnitOfWork(CrudDbContext context,
IDepartmentRepository departmentReository,
IStudentRepository studentRepository
)
: base(context)
{
DepartmentRepository = departmentReository;
StudentRepository = studentRepository;
}
public void Sil(int id)
{
using (CrudDbContext db = new CrudDbContext())
{
var silinecekCalisan = db.Calisan.Find(id);
db.Calisan.Remove(silinecekCalisan);
db.SaveChanges();
}
}
public ActionResult Edit(int id, Person person)
{
using(CrudDbContext db = new CrudDbContext())
{
db.Entry(person).State = EntityState.Modified;
db.SaveChanges();
}
return RedirectToAction("Index");
}
public void Sil(int id)
{
using (CrudDbContext db = new CrudDbContext())
{
var silinecekKullanici = db.Login.Find(id);
db.Login.Remove(silinecekKullanici);
db.SaveChanges();
}
}
public ActionResult Create(Person person)
{
using(CrudDbContext db = new CrudDbContext())
{
db.People.Add(person);
db.SaveChanges();
}
return RedirectToAction("Index");
}
public ActionResult Delete(int id,Person person)
{
using (CrudDbContext db = new CrudDbContext())
{
person = db.People.Where(x => x.Id == id).FirstOrDefault();
db.People.Remove(person);
db.SaveChanges();
}
return RedirectToAction("Index");
}
public List <Plano> ConsultarPlanosPorNome(string nomePlano)
{
List <Plano> consultarPlanosPorNome;
using (var context = new CrudDbContext())
{
consultarPlanosPorNome = context.Planos.Where(p => p.Nome.Contains(nomePlano)).ToList();
}
return(consultarPlanosPorNome);
}
public List <ClassificacaoPlano> ConsultarClassificacao()
{
List <ClassificacaoPlano> classificacao;
using (var context = new CrudDbContext())
{
classificacao = context.ClassificacaoPlano.ToList();
}
return(classificacao);
}
public List <CoberturaPlano> ConsultarTodos()
{
List <CoberturaPlano> consultarCoberturas;
using (var context = new CrudDbContext())
{
consultarCoberturas = context.CoberturaPlano.ToList();
}
return(consultarCoberturas);
}
public void Deletar(int id)
{
var classificacao = new ClassificacaoPlano()
{
Id = id
};
using (var context = new CrudDbContext())
{
context.ClassificacaoPlano.Remove(classificacao);
context.SaveChanges();
}
}
public void Deletar(int id)
{
var coberturaPlano = new CoberturaPlano()
{
Id = id
};
using (var context = new CrudDbContext())
{
context.CoberturaPlano.Remove(coberturaPlano);
context.SaveChanges();
}
}
public List <Plano> ConsultarPlanosPorCobertura(int idCobertura)
{
List <Plano> consultarPlanoPorCobertura;
using (var context = new CrudDbContext())
{
consultarPlanoPorCobertura = context.Planos
.Where(p => p.IdCobertura == idCobertura)
.ToList();
}
return(consultarPlanoPorCobertura);
}
public List <Plano> ConsultarTodos()
{
List <Plano> consultarPlanos;
using (var context = new CrudDbContext())
{
consultarPlanos = context.Planos
.Include(x => x.ClassificacaoPlano)
.Include(x => x.Cobertura)
.ToList();
}
return(consultarPlanos);
}
public CreateModel(CrudDbContext dbContext)
{
_dbContext = dbContext;
Customer = new Customer
{
Name = "",
Email = "",
Salary = 0,
Birthday = DateTime.Now.AddYears(-18),
Gender = "M"
};
alert = new Alert(this);
}
public List <Plano> ConsultarPlanosPorClassificacao(int idClassificacao)
{
List <Plano> consultarPlanosPorClassificacao;
using (var context = new CrudDbContext())
{
consultarPlanosPorClassificacao =
context.Planos
.Where(p => p.IdClassificacaoPlano == idClassificacao)
.ToList();
}
return(consultarPlanosPorClassificacao);
}
public void Deletar(int idPlano)
{
var planos = new Plano()
{
Id = idPlano
};
using (var context = new CrudDbContext())
{
context.Remove(planos);
context.SaveChanges();
}
}
public void Kaydet(Departman departman)
{
using (CrudDbContext db = new CrudDbContext())
{
if (departman.Id == 0)
{
db.Departman.Add(departman);
}
else
{
var guncellenecekDepartman = db.Departman.Find(departman.Id);
if (guncellenecekDepartman == null)
{
return;
}
guncellenecekDepartman.Ad = departman.Ad;
}
db.SaveChanges();
}
}
public void Kaydet(Login login)
{
using (CrudDbContext db = new CrudDbContext())
{
if (login.Id == 0)
{
db.Login.Add(login);
}
else
{
var guncellenecekKullanici = db.Login.Find(login.Id);
if (guncellenecekKullanici == null)
{
return;
}
guncellenecekKullanici.KullaniciAdi = login.KullaniciAdi;
guncellenecekKullanici.Sifre = login.Sifre;
}
db.SaveChanges();
}
}
public void Kaydet(Calisan calisan)
{
using (CrudDbContext db = new CrudDbContext())
{
if (calisan.Id == 0)
{
db.Calisan.Add(calisan);
}
else
{
var guncellenecekCalisan = db.Calisan.Find(calisan.Id);
if (guncellenecekCalisan == null)
{
return;
}
guncellenecekCalisan.Ad = calisan.Ad;
guncellenecekCalisan.Soyad = calisan.Soyad;
guncellenecekCalisan.Maas = calisan.Maas;
guncellenecekCalisan.departmanId = calisan.departmanId;
}
db.SaveChanges();
}
}
public CaminhaoController(CrudDbContext crudContext)
{
_crudContext = crudContext;
}
public HomeController(CrudDbContext Db)
{
_db = Db;
}
public PersonneRepository(CrudDbContext crudDbContext)
{
_crudDbContext = crudDbContext;
}
public EmployeeController(CrudDbContext context)
{
_context = context;
}
public HomeController(CrudDbContext context)
{
_context = context;
}
public PersonController(CrudDbContext context)
{
_context = context;
}
public IndexModel(CrudDbContext dbContext)
{
_dbContext = dbContext;
alert = new Alert(this);
}
public MigrationHostedService(CrudDbContext crudDbContext)
{
_crudDbContext = crudDbContext;
}
public GenericRepository()
{
db = new CrudDbContext();
this.dbSet = db.Set <T>();
}
public DetailsModel(CrudDbContext dbContext)
{
_dbContext = dbContext;
alert = new Alert(this);
}
