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 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); }