public int DeleteDesignation(int Id)
{
int returnVal = 0;
try
{
using (var dBContext1 = new EmployeeDatabaseContext())
{
Model1.Entity.TblDesignation designationEntity = new TblDesignation();
Models.Commen.Designation DeleteDes = new Models.Commen.Designation();
designationEntity = dBContext1.TblDesignation.FirstOrDefault(x => x.DesignationId == Id);
if (designationEntity != null)
{
dBContext1.TblDesignation.Remove(designationEntity);
}
returnVal = dBContext1.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(returnVal);
}
public List <Models.Commen.Designation> GetDesignation()
{
List <Models.Commen.Designation> designations = new List <Models.Commen.Designation>();
try
{
using (var dBContext = new EmployeeDatabaseContext())
{
//GetDesignations
Models.Commen.Designation designation1;
foreach (var des in dBContext.TblDesignation)
{
designation1 = new Models.Commen.Designation();
designation1.DesignationId = des.DesignationId;
designation1.DesignationName = des.DesignationName;
designations.Add(designation1);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(designations);
}
public int EditDesignation(Models.Commen.Designation EditDes, string DesignationName, int DesignationId)
{
List <Models.Commen.Designation> designations = new List <Models.Commen.Designation>();
int returnVal = 0;
try
{
using (var dBContext1 = new EmployeeDatabaseContext())
{
//GetDesignations
Models.Commen.Designation designation1;
foreach (var des in dBContext1.TblDesignation)
{
designation1 = new Models.Commen.Designation();
designation1.DesignationId = des.DesignationId;
designation1.DesignationName = des.DesignationName;
designations.Add(designation1);
}
Model1.Entity.TblDesignation designationEntity = new TblDesignation();
designationEntity = dBContext1.TblDesignation.FirstOrDefault(x => x.DesignationId == EditDes.DesignationId);
if (designationEntity != null)
{
designationEntity.DesignationId = EditDes.DesignationId;
designationEntity.DesignationName = EditDes.DesignationName;
dBContext1.TblDesignation.Update(designationEntity);
DesignationId = designationEntity.DesignationId;
DesignationName = designationEntity.DesignationName;
}
bool degtexist1 = designations.Any(x => (x.DesignationId == DesignationId) && (x.DesignationName == DesignationName));
bool degtexist = designations.Any(x => x.DesignationName == DesignationName);
if (degtexist1 == true)
{
returnVal = dBContext1.SaveChanges();
}
else if (degtexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext1.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(returnVal);
}
public int AddDesignation(Models.Commen.Designation DesignationModel, string DesignationName)
{
int returnVal = 0;
try
{
List <Models.Commen.Designation> designations = new List <Models.Commen.Designation>();
using (var dBContext = new EmployeeDatabaseContext())
{
//GetDesignations
Models.Commen.Designation designation1;
foreach (var des in dBContext.TblDesignation)
{
designation1 = new Models.Commen.Designation();
designation1.DesignationName = des.DesignationName;
designations.Add(designation1);
}
Model1.Entity.TblDesignation designationEntity;
//Add Designation
if (DesignationModel.DesignationId == 0)
{
designationEntity = new TblDesignation();
designationEntity.DesignationName = DesignationModel.DesignationName;
dBContext.TblDesignation.Add(designationEntity);
DesignationName = designationEntity.DesignationName;
}
bool degtexist = designations.Any(x => x.DesignationName == DesignationName);
if (degtexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//throw;
}
return(returnVal);
}
//************************
//Designation
//************************
public Models.Commen.Designation GetDesignationById(int id)
{
Models.Commen.Designation DesignationData = new Models.Commen.Designation();
try
{
using (var dBContext = new EmployeeDatabaseContext())
{
//GetEmployee
var deg = dBContext.TblDesignation.Where(x => x.DesignationId == id).SingleOrDefault();
if (deg != null)
{
DesignationData.DesignationId = deg.DesignationId;
DesignationData.DesignationName = deg.DesignationName;
}
return(DesignationData);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
