public static void Insert(Empdemo obj)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
model_Emp_DB.Empdemoes.Add(obj);
model_Emp_DB.SaveChanges();
}
public static void UpdateDept(int id, string deptname)
{
Model_Emp_DBContainer db = new Model_Emp_DBContainer();
Deptdemo update = db.Deptdemoes.Find(id);
update.Name = deptname;
db.SaveChanges();
}
public static void Delete(int id)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
Empdemo todelete = model_Emp_DB.Empdemoes.Find(id);
model_Emp_DB.Empdemoes.Remove(todelete);
model_Emp_DB.SaveChanges();
}
public static void UpdateSalary(int id, float salary)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
Empdemo update = model_Emp_DB.Empdemoes.Find(id);
update.Salary = salary;
model_Emp_DB.SaveChanges();
}
public static void UpdateName(int id, string name)
{
Model_Emp_DBContainer model_Emp_DB = new Model_Emp_DBContainer();
var update = model_Emp_DB.Empdemoes.Find(id);
update.Name = name;
model_Emp_DB.SaveChanges();
}
public static void DeleteDept(int id)
{
Model_Emp_DBContainer db = new Model_Emp_DBContainer();
Deptdemo todel = db.Deptdemoes.Find(id);
db.Deptdemoes.Remove(todel);
db.SaveChanges();
}
public static void AddNewDept(string deptname)
{
Model_Emp_DBContainer db = new Model_Emp_DBContainer();
Deptdemo dd = new Deptdemo()
{
Name = deptname
};
db.Deptdemoes.Add(dd);
db.SaveChanges();
//Deptdemo dd1 = db.Deptdemoes.Last<Deptdemo>();
//Console.WriteLine("New dept added\n{0}\t{1}", dd1.Id, dd1.Name);
}
