//************************
//Department
//************************
public List <Models.Commen.Department> GetDepartment()
{
List <Models.Commen.Department> departments = new List <Models.Commen.Department>();
try
{
using (var dBContext = new database2Context())
{
//GetDepartment
Models.Commen.Department department1;
foreach (var dept in dBContext.TblDepartment)
{
department1 = new Models.Commen.Department();
department1.DepartmentId = dept.DepartmentId;
department1.DepartmentName = dept.DepartmentName;
departments.Add(department1);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(departments);
}
public int DeleteDepartment(int Id)
{
int returnVal = 0;
try
{
using (var dBContext1 = new EmployeeDatabaseContext())
{
Model1.Entity.TblDepartment departmentEntity = new TblDepartment();
Models.Commen.Department DeleteDept = new Models.Commen.Department();
departmentEntity = dBContext1.TblDepartment.FirstOrDefault(x => x.DepartmentId == Id);
if (departmentEntity != null)
{
dBContext1.TblDepartment.Remove(departmentEntity);
}
returnVal = dBContext1.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(returnVal);
}
public int EditDepartment(Models.Commen.Department EditDept, string DepartmentName, int DepartmentId)
{
List <Models.Commen.Department> departments = new List <Models.Commen.Department>();
int returnVal = 0;
try
{
using (var dBContext1 = new EmployeeDatabaseContext())
{
//GetDepartment
Models.Commen.Department department1;
foreach (var dept in dBContext1.TblDepartment)
{
department1 = new Models.Commen.Department();
department1.DepartmentId = dept.DepartmentId;
department1.DepartmentName = dept.DepartmentName;
departments.Add(department1);
}
Model1.Entity.TblDepartment departmentEntity = new TblDepartment();
departmentEntity = dBContext1.TblDepartment.FirstOrDefault(x => x.DepartmentId == EditDept.DepartmentId);
if (departmentEntity != null)
{
departmentEntity.DepartmentId = EditDept.DepartmentId;
departmentEntity.DepartmentName = EditDept.DepartmentName;
dBContext1.TblDepartment.Update(departmentEntity);
DepartmentName = departmentEntity.DepartmentName;
DepartmentId = departmentEntity.DepartmentId;
}
bool deptexist = departments.Any(x => x.DepartmentName == DepartmentName);
bool deptexist1 = departments.Any(x => (x.DepartmentId == DepartmentId) && (x.DepartmentName == DepartmentName));
if ((deptexist1 == true))
{
returnVal = dBContext1.SaveChanges();
}
else if (deptexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext1.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(returnVal);
}
public int AddDepartment(Models.Commen.Department DepartmentModel, string DepartmentName)
{
List <Models.Commen.Department> departments = new List <Models.Commen.Department>();
int returnVal = 0;
try
{
using (var dBContext = new EmployeeDatabaseContext())
{
//GetDepartment
Models.Commen.Department department1;
foreach (var dept in dBContext.TblDepartment)
{
department1 = new Models.Commen.Department();
department1.DepartmentName = dept.DepartmentName;
departments.Add(department1);
}
Model1.Entity.TblDepartment departmentEntity;
//Add Designation
if (DepartmentModel.DepartmentId == 0)
{
departmentEntity = new TblDepartment();
departmentEntity.DepartmentName = DepartmentModel.DepartmentName;
dBContext.TblDepartment.Add(departmentEntity);
DepartmentName = departmentEntity.DepartmentName;
}
bool deptexist = departments.Any(x => x.DepartmentName == DepartmentName);
if (deptexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(returnVal);
}
//************************
//Department
//************************
public Models.Commen.Department GetDepartmentById(int id)
{
Models.Commen.Department departments = new Models.Commen.Department();
try
{
using (var dBContext = new EmployeeDatabaseContext())
{
//GetEmployee
var dept = dBContext.TblDepartment.Where(x => x.DepartmentId == id).SingleOrDefault();
if (dept != null)
{
departments.DepartmentId = dept.DepartmentId;
departments.DepartmentName = dept.DepartmentName;
}
return(departments);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
