private static void ReadDataFromBase(EmployeesDAL employeesDAL)
{
try
{
WriteLine($"Количество строк в таблице: {employeesDAL.CountRows}");
SqlDataReader reader;
reader = employeesDAL.Select();
WriteLine("Объект чтения данных --> " + reader.GetType().Name);
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Write($"|{reader[i],15}");
}
WriteLine();
}
}
catch (SqlException ex)
{
WriteLine(ex.Message);
}
finally
{
employeesDAL.CloseConnection();
}
}
public int AddEmployeeAttendance(EmployeeAttendance attendance)
{
//Modified by Talha: Jan 26th, 2012 - Added Return variable to ensure data inserted successfully
int cmd_success;
cmd_success = new EmployeesDAL().Insert(attendance);
return(cmd_success);
}
public List <Employee> GetEmployees(int id)
{
List <Employee> employees = new EmployeesDAL().GetEmployees(id);
employees.All(x => { x.AnnualSalary = EmployeeFactory.getEmployeeType(x.contractTypeName).getAnnualSalary(x.hourlySalary, x.monthlySalary); return(true); });
return(employees);
}
public ActionResult Create(EmployeesViewModel model)
{
if (EmployeesDAL.Add(model))
{
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public virtual int Add()
{
try
{
EmployeesDAL employeeDal = new EmployeesDAL();
Employees employee = new Employees()
{
EmployeeIDNo = this.EmployeeIDNo,
FirstNameAr = this.FirstNameAr,
MiddleNameAr = this.MiddleNameAr,
GrandFatherNameAr = this.GrandFatherNameAr,
FifthNameAr = this.FifthNameAr,
LastNameAr = this.LastNameAr,
FirstNameEn = this.FirstNameEn,
MiddleNameEn = this.MiddleNameEn,
GrandFatherNameEn = this.GrandFatherNameEn,
FifthNameEn = this.FifthNameEn,
LastNameEn = this.LastNameEn,
EmployeeBirthDate = (DateTime)this.EmployeeBirthDate.Value.Date,
EmployeeBirthPlace = this.EmployeeBirthPlace,
EmployeeMobileNo = this.EmployeeMobileNo,
EmployeePassportNo = this.EmployeePassportNo,
EmployeeEMail = this.EmployeeEMail,
EmployeeIDIssueDate = this.EmployeeIDIssueDate != null ? (DateTime)this.EmployeeIDIssueDate.Value.Date : (DateTime?)null,
EmployeePassportSource = this.EmployeePassportSource,
EmployeePassportIssueDate = this.EmployeePassportIssueDate != null ? (DateTime)this.EmployeePassportIssueDate.Value.Date : (DateTime?)null,
EmployeePassportEndDate = this.EmployeePassportEndDate != null ? (DateTime)this.EmployeePassportEndDate.Value.Date : (DateTime?)null,
EmployeeIDExpiryDate = this.EmployeeIDExpiryDate,
EmployeeIDCopyNo = this.EmployeeIDCopyNo,
EmployeeIDIssuePlace = this.EmployeeIDIssuePlace,
DependentCount = this.DependentCount,
MaritalStatusID = this.MaritalStatus.MaritalStatusID,
GenderID = this.Gender.GenderID,
NationalityID = this.Nationality.CountryID,
CreatedDate = DateTime.Now,
CreatedBy = this.LoginIdentity.EmployeeCodeID,
};
employeeDal.Insert(employee);
return(this.EmployeeID);
}
catch (Exception ex)
{
throw ex;
}
}
public virtual List <EmployeesBLL> GetEmployees()
{
try
{
List <Employees> EmployeesList = new EmployeesDAL().GetEmployees();
List <EmployeesBLL> EmployeesBLLList = new List <EmployeesBLL>();
foreach (var item in EmployeesList)
{
EmployeesBLLList.Add(new EmployeesBLL().MapEmployee(item));
}
return(EmployeesBLLList.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
public virtual EmployeesBLL GetByEmployeeID(int EmployeeID)
{
try
{
EmployeesBLL EmployeeBLL = null;
Employees Employee = new EmployeesDAL().GetByEmployeeID(EmployeeID);
if (Employee != null)
{
EmployeeBLL = this.MapEmployee(Employee);
}
return(EmployeeBLL);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ResultPT> InsertAsync(EmployeesDTO objEmployeesDTO)
{
try
{
objResultPT = new ResultPT();
using (EmployeesDAL objEmployeesDAL = new EmployeesDAL())
{
objResultPT.ReturnObject = await objEmployeesDAL.InsertAsync(objEmployeesDTO);
if (Convert.ToInt32(objResultPT.ReturnObject) == 2)
{
objResultPT.ResultMsg = string.Format(Messages.ObjectExist, "Employees");
objResultPT.TransactionStatus = Enums.ResultStatus.Warning;
}
else if (Convert.ToInt32(objResultPT.ReturnObject) > 0)
{
objResultPT.ResultMsg = Messages.Success;
objResultPT.TransactionStatus = Enums.ResultStatus.Success;
}
else if (Convert.ToInt32(objResultPT.ReturnObject) == 0)
{
objResultPT.ResultMsg = Messages.NoDataFound;
objResultPT.TransactionStatus = Enums.ResultStatus.Information;
}
else
{
objResultPT.ResultMsg = Messages.Error;
objResultPT.TransactionStatus = Enums.ResultStatus.Failure;
}
}
return(objResultPT);
}
catch (Exception Ex)
{
////log error message into database.
await this.LogErrorAsync(ErrorLog.ApplicationName.BAL, System.Reflection.MethodBase.GetCurrentMethod().Name, Ex.Message, Ex.StackTrace);
objResultPT.TransactionStatus = Enums.ResultStatus.Failure;
objResultPT.ResultMsg = Ex.Message;
}
return(objResultPT);
}
public EmployeesBLL GetByEmployeeNameAr(string EmployeeNameAr)
{
try
{
Employees Employee = new EmployeesDAL().GetByEmployeeNameAr(EmployeeNameAr);
if (Employee != null)
{
EmployeesBLL EmployeeBLL = MapEmployee(Employee);
EmployeeBLL.EmployeePicture = EmployeeBLL.GetEmployeePicture();
return(EmployeeBLL);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public virtual EmployeesBLL GetByEmployeeIDWithEmpPic(int EmployeeID)
{
try
{
Employees Employee = new EmployeesDAL().GetByEmployeeID(EmployeeID);
if (Employee != null)
{
EmployeesBLL EmployeeBLL = MapEmployee(Employee);
EmployeeBLL.EmployeePicture = EmployeeBLL.GetEmployeePicture();
return(EmployeeBLL);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ResultPT> GetAllAsync( )
{
try
{
objResultPT = new ResultPT();
using (EmployeesDAL objEmployeesDAL = new EmployeesDAL())
{
objResultPT.ReturnObject = await objEmployeesDAL.GetAllAsync();
}
throw new Exception("Error Test");
return(objResultPT);
}
catch (Exception Ex)
{
////log error message into database.
await this.LogErrorAsync(ErrorLog.ApplicationName.BAL, System.Reflection.MethodBase.GetCurrentMethod().Name, Ex.Message, Ex.StackTrace);
objResultPT.TransactionStatus = Enums.ResultStatus.Failure;
objResultPT.ResultMsg = Ex.Message;
}
return(objResultPT);
}
//// public async Task<ResultPT> DeleteAllAsync()
//// {
//// try
//// {
//// objResultPT = new ResultPT();
//// using (EmployeesDAL objEmployeesDAL = new EmployeesDAL())
//// {
//// objResultPT.ReturnObject = objEmployeesDAL.DeleteAll();
//// objResultPT.TransactionStatus = Enums.ResultStatus.Success;
//// objResultPT.ResultMsg = "success";
//// }
//// return objResultPT;
//// }
//// catch (Exception Ex)
//// {
//// ////log error message into database.
//// await this.LogError(ErrorLog.application.BAL, System.Reflection.MethodBase.GetCurrentMethod().Name, Ex.Message, Ex.StackTrace);
//// objResultPT.TransactionStatus = Enums.ResultStatus.Failure;
//// objResultPT.ResultMsg = Ex.Message;
//// }
//// return objResultPT;
//// }
public async Task <ResultPT> GetByIDAsync(long ID)
{
try
{
objResultPT = new ResultPT();
using (EmployeesDAL objEmployeesDAL = new EmployeesDAL())
{
DataSet dset = await objEmployeesDAL.GetByIDAsync(ID);
if (dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0)
{
DataTable dt = dset.Tables[0];
objResultPT.ReturnObject = CommonFunctions.FillProperties <EmployeesDTO>(dt.Rows[0]);
objResultPT.ResultMsg = Messages.Success;
objResultPT.TransactionStatus = Enums.ResultStatus.Success;
}
else
{
objResultPT.ReturnObject = "";
objResultPT.ResultMsg = Messages.NoDataFound;
objResultPT.TransactionStatus = Enums.ResultStatus.NodData;
}
}
return(objResultPT);
}
catch (Exception Ex)
{
////log error message into database.
await this.LogErrorAsync(ErrorLog.ApplicationName.BAL, System.Reflection.MethodBase.GetCurrentMethod().Name, Ex.Message, Ex.StackTrace);
objResultPT.TransactionStatus = Enums.ResultStatus.Failure;
objResultPT.ResultMsg = Ex.Message;
}
return(objResultPT);
}
public static void Delete(EmployeesDTO employeesTypes)
{
EmployeesDAL.Delete(EmployeesCast.ToDAL(employeesTypes));
}
// GET: Employees
public ActionResult Index()
{
return(View(EmployeesDAL.GetAll()));
}
public static EmployeesDTO login(string username, string password)
{
return(EmployeesCast.ToDTO(EmployeesDAL.Login(username, password)));
}
public Employees_Business_Manager()
{
_employeesDAL = new EmployeesDAL();
}
public static void Update(EmployeesDTO employeesTypes)
{
EmployeesDAL.Update(EmployeesCast.ToDAL(employeesTypes));
}
public static List <EmployeesDTO> GetAll()
{
return(EmployeesCast.ListToDTO(EmployeesDAL.GetAll()));
}
static void Main(string[] args)
{
//string connectionString =
// @" Data Source=(localdb)\MSSQLLocalDB;
// Initial Catalog=DataEmployees_22_08_2019;
// Integrated Security=True;
// Connect Timeout=30;
// Encrypt=False;
// TrustServerCertificate=False;
// ApplicationIntent=ReadWrite;
// MultiSubnetFailover=False";
string connectionString =
@" Data Source=andrey-kotelnik\sqlexpress;
Initial Catalog=EmployeesDataMSSQL;
Integrated Security=True";
ConnectionString.Text = connectionString;
EmployeesDAL employeesDAL = new EmployeesDAL();
DepartmentsDAL departmentsDAL = new DepartmentsDAL();
try
{
ReadDataFromBase(employeesDAL);
employeesDAL.OpenConnection();
//SqlDataAdapter dataAdapter = employeesDAL.GetDataAdapter();
////SqlParameter[] parameters = new SqlParameter[cmdTest.Parameters.Count];
////cmdTest.Parameters.CopyTo(parameters, 0);
////cmdTest.Parameters.Remove(parameters[0]);
////parameters[0].Value = 58;
////cmdTest.Parameters.Add(parameters[0]);
////cmdTest.ExecuteNonQuery();
////employeesDAL.CloseConnection();
//DataTable table = new DataTable();
//dataAdapter.Fill(table);
//DataRow rowUpd = table.Rows[0];
//var res = rowUpd.ItemArray.GetValue(1);
//var f = rowUpd.ItemArray.IsReadOnly;
//rowUpd.ItemArray[1] = "ИИИИИИИИ";
//var arr = rowUpd.ItemArray;
//arr[1] = "Иваныч2";
//rowUpd.ItemArray = arr;
//res = rowUpd.ItemArray.GetValue(1);
//DataRow row = table.NewRow();
//row[1] = "Andr2";
//row[2] = "Andr2";
//row[3] = 35;
//table.Rows.Add(row);
//table.AcceptChanges();
//WriteLine($"The number of rows successfully updated: {dataAdapter.Update(table)}");
//////employeesDAL.OpenConnection();
var empList = Employee.GetEmployees();
foreach (var item in empList)
{
employeesDAL.Insert(item.Name, item.Surname, item.Age, item.DepID);
}
//WriteLine($"Номер вставленной строки: {employeesDAL.Insert("Й", "Й", 10, null)}");
WriteLine($"Количество строк в таблице: {employeesDAL.CountRows}");
//employeesDAL.Delete(25);
//employeesDAL.Update(8, "8", "8", 8, 1);
SqlDataReader reader;
reader = employeesDAL.Select();
WriteLine("Объект чтения данных --> " + reader.GetType().Name);
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Write($"|{reader[i],15}");
}
WriteLine();
}
}
catch (SqlException ex)
{
WriteLine(ex.Message);
}
finally
{
employeesDAL.CloseConnection();
}
//try
//{
// departmentsDAL.OpenConnection();
// WriteLine($"Номер вставленной строки: {departmentsDAL.Insert("qwerty")}");
// WriteLine($"Количество строк в таблице: {departmentsDAL.CountRows}");
// departmentsDAL.Delete(3);
// departmentsDAL.Update(1, "FFFFFF");
// SqlDataReader reader;
// reader = departmentsDAL.Select();
// WriteLine("Объект чтения данных --> " + reader.GetType().Name);
// while (reader.Read())
// {
// for (int i = 0; i < reader.FieldCount; i++)
// {
// Write($"|{reader[i],15}");
// }
// WriteLine();
// }
//}
//catch (SqlException ex)
//{
// WriteLine(ex.Message);
//}
//finally
//{
// departmentsDAL.CloseConnection();
//}
//SqlDataAdapter dataAdapterEmp = employeesDAL.GetDataAdapter();
//DataTable dataEmp = new DataTable("Employees");
//SqlDataAdapter dataAdapterDep = departmentsDAL.GetDataAdapter();
//DataTable dataDep = new DataTable("Departments");
//try
//{
// dataAdapterEmp.Fill(dataEmp);
//}
//catch (SqlException ex)
//{
// WriteLine(ex.Message);
//}
//try
//{
// dataAdapterDep.Fill(dataDep);
//}
//catch (SqlException ex)
//{
// WriteLine(ex.Message);
//}
//WriteLine($"Столбцы в Emp: { dataEmp.Columns.Count}");
//WriteLine($"Столбцы в Dep: { dataDep.Columns.Count}");
}
public virtual int AddHiringNewEmployee(EmployeesBLL EmployeesBLL, EmployeesCodesBLL EmployeesCodesBLL, EmployeesCareersHistoryBLL EmployeesCareersHistoryBLL, EmployeesQualificationsBLL EmployeesQualificationsBLL, ContractorsBasicSalariesBLL ContractorsBasicSalariesBLL, List <EmployeesAllowancesBLL> EmployeesAllowancesBLLLst)
{
try
{
EmployeesDAL employeeDal = new EmployeesDAL();
Employees employee = new Employees()
{
EmployeeIDNo = this.EmployeeIDNo,
FirstNameAr = this.FirstNameAr,
MiddleNameAr = this.MiddleNameAr,
GrandFatherNameAr = this.GrandFatherNameAr,
FifthNameAr = this.FifthNameAr,
LastNameAr = this.LastNameAr,
FirstNameEn = this.FirstNameEn,
MiddleNameEn = this.MiddleNameEn,
GrandFatherNameEn = this.GrandFatherNameEn,
FifthNameEn = this.FifthNameEn,
LastNameEn = this.LastNameEn,
EmployeeBirthDate = (DateTime)this.EmployeeBirthDate.Value.Date,
EmployeeBirthPlace = this.EmployeeBirthPlace,
EmployeeMobileNo = this.EmployeeMobileNo,
EmployeePassportNo = this.EmployeePassportNo,
EmployeeEMail = this.EmployeeEMail,
EmployeeIDIssueDate = this.EmployeeIDIssueDate != null ? (DateTime)this.EmployeeIDIssueDate.Value.Date : (DateTime?)null,
EmployeePassportSource = this.EmployeePassportSource,
EmployeePassportIssueDate = this.EmployeePassportIssueDate != null ? (DateTime)this.EmployeePassportIssueDate.Value.Date : (DateTime?)null,
EmployeePassportEndDate = this.EmployeePassportEndDate != null ? (DateTime)this.EmployeePassportEndDate.Value.Date : (DateTime?)null,
EmployeeIDExpiryDate = this.EmployeeIDExpiryDate,
EmployeeIDCopyNo = this.EmployeeIDCopyNo,
EmployeeIDIssuePlace = this.EmployeeIDIssuePlace,
DependentCount = this.DependentCount,
MaritalStatusID = this.MaritalStatus.MaritalStatusID,
GenderID = this.Gender.GenderID,
NationalityID = this.Nationality.CountryID,
CreatedDate = DateTime.Now,
CreatedBy = this.LoginIdentity.EmployeeCodeID,
};
EmployeesCodes employeesCode = new EmployeesCodes()
{
EmployeeCodeNo = EmployeesCodesBLL.EmployeeCodeNo,
EmployeeTypeID = EmployeesCodesBLL.EmployeeType.EmployeeTypeID,
IsActive = true,
CreatedDate = DateTime.Now,
CreatedBy = this.LoginIdentity.EmployeeCodeID
};
EmployeesCareersHistory employeeCareerHistory = new EmployeesCareersHistory()
{
CareerHistoryTypeID = EmployeesCareersHistoryBLL.CareerHistoryType.CareerHistoryTypeID,
CareerDegreeID = EmployeesCareersHistoryBLL.CareerDegree.CareerDegreeID,
OrganizationJobID = EmployeesCareersHistoryBLL.OrganizationJob.OrganizationJobID,
JoinDate = EmployeesCareersHistoryBLL.JoinDate.Date,
TransactionStartDate = EmployeesCareersHistoryBLL.JoinDate.Date,
IsActive = true,
CreatedBy = this.LoginIdentity.EmployeeCodeID,
CreatedDate = DateTime.Now
};
EmployeesQualifications employeeQualification = new EmployeesQualifications();
employeeQualification.QualificationDegreeID = EmployeesQualificationsBLL.QualificationDegree.QualificationDegreeID;
employeeQualification.QualificationID = EmployeesQualificationsBLL.Qualification.QualificationID;
employeeQualification.GeneralSpecializationID = EmployeesQualificationsBLL.GeneralSpecialization.GeneralSpecializationID;
employeeQualification.ExactSpecializationID = EmployeesQualificationsBLL.ExactSpecialization.ExactSpecializationID == 0 ? (int?)null : EmployeesQualificationsBLL.ExactSpecialization.ExactSpecializationID;
employeeQualification.UniSchName = EmployeesQualificationsBLL.UniSchName;
employeeQualification.Department = EmployeesQualificationsBLL.Department;
employeeQualification.FullGPA = EmployeesQualificationsBLL.FullGPA;
employeeQualification.GPA = EmployeesQualificationsBLL.GPA;
employeeQualification.StudyPlace = EmployeesQualificationsBLL.StudyPlace;
employeeQualification.GraduationDate = EmployeesQualificationsBLL.GraduationDate;
employeeQualification.GraduationYear = EmployeesQualificationsBLL.GraduationYear;
employeeQualification.Percentage = EmployeesQualificationsBLL.Percentage;
employeeQualification.QualificationTypeID = EmployeesQualificationsBLL.QualificationType.QualificationTypeID == 0 ? (int?)null : EmployeesQualificationsBLL.QualificationType.QualificationTypeID;
employeeQualification.CreatedDate = DateTime.Now;
employeeQualification.CreatedBy = this.LoginIdentity.EmployeeCodeID;
ContractorsBasicSalaries contractorBasicSalary = new ContractorsBasicSalaries();
contractorBasicSalary.BasicSalary = ContractorsBasicSalariesBLL.BasicSalary;
contractorBasicSalary.TransfareAllowance = ContractorsBasicSalariesBLL.TransfareAllowance;
contractorBasicSalary.CreatedDate = DateTime.Now;
contractorBasicSalary.CreatedBy = this.LoginIdentity.EmployeeCodeID;
List <EmployeesAllowances> employeesAllowancesList = new List <EmployeesAllowances>();
foreach (var EmployeeAllowanceBLL in EmployeesAllowancesBLLLst)
{
employeesAllowancesList.Add(new EmployeesAllowances()
{
AllowanceID = EmployeeAllowanceBLL.Allowance.AllowanceID,
AllowanceStartDate = EmployeeAllowanceBLL.AllowanceStartDate,
IsActive = EmployeeAllowanceBLL.IsActive,
CreatedBy = this.LoginIdentity.EmployeeCodeID,
CreatedDate = DateTime.Now
});
}
employee.EmployeesCodes = new List <EmployeesCodes>();
employee.EmployeesCodes.Add(employeesCode);
employeesCode.EmployeesCareersHistory = new List <EmployeesCareersHistory>();
employeesCode.EmployeesCareersHistory.Add(employeeCareerHistory);
employeesCode.EmployeesQualifications = new List <EmployeesQualifications>();
employeesCode.EmployeesQualifications.Add(employeeQualification);
#region check if the new employee is contractor then add financial advantages to him
OrganizationsJobsBLL OrganizationsJobsBLL = new OrganizationsJobsBLL().GetByOrganizationJobID(employeeCareerHistory.OrganizationJobID);
if (OrganizationsJobsBLL.Rank.RankCategory.RankCategoryID == (int)RanksCategoriesEnum.ContractualExpats || OrganizationsJobsBLL.Rank.RankCategory.RankCategoryID == (int)RanksCategoriesEnum.ContractualSaudis)
{
employeesCode.ContractorsBasicSalaries = new List <ContractorsBasicSalaries>();
employeesCode.ContractorsBasicSalaries.Add(contractorBasicSalary);
employeeCareerHistory.EmployeesAllowances = employeesAllowancesList;
}
#endregion
employeeDal.Insert(employee);
return(this.EmployeeID);
}
catch
{
throw;
}
}
public bool DeleteEmployeeData(Hr_Employees objUpdate, List <Hr_EmpDues> ListDtlsEmpDus, Hr_EmpDuesVactionTicket Obj_DtlsVaction)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
bool result = false;
var strErrorMessage = string.Empty;
try
{
//int resultUpdateEmployee = 0;
Guid? varEmpHdrId;
decimal varEmpSerialNo;
string varBranchId, varCompanyId;
varEmpHdrId = ListDtlsEmpDus[0].EmpHdrId;
varEmpSerialNo = ListDtlsEmpDus[0].Emp_Serial_No;
varBranchId = ListDtlsEmpDus[0].Branch_Id;
varCompanyId = ListDtlsEmpDus[0].Company_Id;
using (AthelHREntities varcontext = new AthelHREntities())
{
using (var dbContextTransaction = varcontext.Database.BeginTransaction())
{
try
{
if (varcontext.Database.Connection.State == System.Data.ConnectionState.Closed)
{
varcontext.Database.Connection.Open();
}
//OpenEntityConnection();
EmpDuesDAL objEmpGrade = new EmpDuesDAL();
result = objEmpGrade.DeleteEmpDuesHireItemByContext(varBranchId, varCompanyId, varEmpHdrId, varEmpSerialNo, varcontext);
if (result)
{
//EmpSpousesDAL objSpouses = new EmpSpousesDAL();
//result = objSpouses.DeleteEmpSpousesByContext(varBranchId, varCompanyId, varEmpHdrId, varEmpSerialNo, varcontext);
//if (result)
//{
EmpDuesVactionTicketDAL objEmpVaction = new EmpDuesVactionTicketDAL();
Obj_DtlsVaction.EmpHdrId = varEmpHdrId;
Obj_DtlsVaction.UpdateUser = UserNameProperty;
result = objEmpVaction.DeleteEmpVactionTicketByContext(varBranchId, varCompanyId, varEmpHdrId, varEmpSerialNo, varcontext);
if (result)
{
EmployeesDAL objEmp = new EmployeesDAL();
objUpdate.EmpHdrId = varEmpHdrId;
objUpdate.DeleteUser = UserNameProperty;
result = objEmp.DeleteTaskByContext(objUpdate, varcontext);
//result = (resultInsertEmployee > 0);
varcontext.SaveChanges();
dbContextTransaction.Commit();
}
}
//}
else
{
dbContextTransaction.Rollback();
result = false;
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
strErrorMessage = fullErrorMessage;
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
//((System.Data.Entity.Validation.DbEntityValidationException)$exception).EntityValidationErrors.First().ValidationErrors.First().ErrorMessage
// dbTran.Rollback();
dbContextTransaction.Rollback();
result = false;
}
//--- End Try Of Using
catch (Exception ex)
{
dbContextTransaction.Rollback(); //Required according to MSDN article
throw; //Not in MSDN article, but recommended so the exception still bubbles up
}
finally
{
varcontext.Database.Connection.Close();
dbContextTransaction.Dispose();
}
//--- End catch
}
//--- End Using
}
}
//--- End Try
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
strErrorMessage = fullErrorMessage;
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
//((System.Data.Entity.Validation.DbEntityValidationException)$exception).EntityValidationErrors.First().ValidationErrors.First().ErrorMessage
// dbTran.Rollback();
result = false;
}
catch (Exception ex)
{
//Rollback transaction if exception occurs
// dbTran.Rollback();
result = false;
}
finally
{
objPharmaEntities.Database.Connection.Close();
// dbTran.Dispose();
if (!string.IsNullOrEmpty(strErrorMessage))
{
SaveErrorLog(System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(), strErrorMessage, this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString());
}
}
return(result);
}
public static EmployeesDTO GetById(int id)
{
return(EmployeesCast.ToDTO(EmployeesDAL.GetById(id)));
}
public void TestName1(string user_name, string password)
{
EmployeesDAL e = new EmployeesDAL();
Assert.NotNull(e.GetEmployeeByUserPassword(user_name, password));
}
public static void Add(EmployeesDTO employeesTypes)
{
EmployeesDAL.Add(EmployeesCast.ToDAL(employeesTypes));
}
