public bool AddNewRecord(List <Hr_EmpQualifications> ListDtls) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); var strErrorMessage = string.Empty; // ObjWorkFlow_HdrDL.InsUser = "******"; // ObjCommTransHeaderDL.InsDate = DateTime.Now.ToString("dd/MM/yyyy"); bool result = true; //using (System.Data.Entity.DbContextTransaction dbTran = objPharmaEntities.Database.BeginTransaction()) //{ try { if (objPharmaEntities.Database.Connection.State == System.Data.ConnectionState.Closed) { objPharmaEntities.Database.Connection.Open(); } string strBranch_Id = ListDtls[0].Branch_Id.ToString(); string strCompany_Id = ListDtls[0].Company_Id.ToString(); decimal?strEmp_Serial_No = ListDtls[0].Emp_Serial_No; if (!String.IsNullOrEmpty(strBranch_Id) && !String.IsNullOrEmpty(strCompany_Id) && !String.IsNullOrEmpty(strCompany_Id)) { result = DeleteEmpQualifications(strBranch_Id, strCompany_Id, strEmp_Serial_No); } if (result == true) { foreach (Hr_EmpQualifications Obj_Dtls in ListDtls) { if (Obj_Dtls != null) { // University_Name, FromDate, ToDate, Country_Id, Degree, City_Id, InsUser, InsDate, UpdateUser, //UpdateDate, Faculty_Name, DocAttach, EmpHdrId Hr_EmpQualifications loclDtls = new Hr_EmpQualifications { Dtls_Id = Obj_Dtls.Dtls_Id, EmpHdrId = Obj_Dtls.EmpHdrId, Branch_Id = Obj_Dtls.Branch_Id, Company_Id = Obj_Dtls.Company_Id, University_Name = Obj_Dtls.University_Name, FromDate = Obj_Dtls.FromDate, ToDate = Obj_Dtls.ToDate, Country_Id = Obj_Dtls.Country_Id, Degree = Obj_Dtls.Degree, City_Id = Obj_Dtls.City_Id, Qualification_Id = Obj_Dtls.Qualification_Id, Specialization = Obj_Dtls.Specialization, Faculty_Name = Obj_Dtls.Faculty_Name, DocAttach = Obj_Dtls.DocAttach, Notes = Obj_Dtls.Notes, Emp_Serial_No = Obj_Dtls.Emp_Serial_No, InsDate = DateTime.Now, InsUser = UserNameProperty }; objPharmaEntities.Hr_EmpQualifications.Add(loclDtls); //saves all above operations within one transaction objPharmaEntities.SaveChanges(); // dbTran.Commit(); // } } } } //commit transaction // dbTran.Commit(); } 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 List <Hr_EmpQualifications> SelectAllEmpQualificationsetting(string Company_Id, string Branch_Id, decimal Emp_Serial_No) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); List <Hr_EmpQualifications> objectList = new List <Hr_EmpQualifications>(); var objlist = (from objLinq in objPharmaEntities.Hr_EmpQualifications where objLinq.Company_Id == Company_Id && objLinq.Branch_Id == Branch_Id && objLinq.Emp_Serial_No == Emp_Serial_No //&& objLinq.Grade_Id == Grade_Id select new { EmpHdrId = objLinq.EmpHdrId, Branch_Id = objLinq.Branch_Id, Company_Id = objLinq.Company_Id, Emp_Serial_No = objLinq.Emp_Serial_No, University_Name = objLinq.University_Name, FromDate = objLinq.FromDate, ToDate = objLinq.ToDate, Country_Id = objLinq.Country_Id, Degree = objLinq.Degree, City_Id = objLinq.City_Id, Qualification_Id = objLinq.Qualification_Id, Specialization = objLinq.Specialization, Faculty_Name = objLinq.Faculty_Name, DocAttach = objLinq.DocAttach, Notes = objLinq.Notes }).ToList(); foreach (var obj in objlist) { Hr_EmpQualifications objEmpQualificationsDL = new Hr_EmpQualifications(); objEmpQualificationsDL.Branch_Id = obj.Branch_Id; objEmpQualificationsDL.Company_Id = obj.Company_Id; objEmpQualificationsDL.EmpHdrId = obj.EmpHdrId; objEmpQualificationsDL.University_Name = obj.University_Name; objEmpQualificationsDL.FromDate = obj.FromDate; objEmpQualificationsDL.ToDate = obj.ToDate; objEmpQualificationsDL.Country_Id = obj.Country_Id; objEmpQualificationsDL.Degree = obj.Degree; objEmpQualificationsDL.City_Id = obj.City_Id; objEmpQualificationsDL.Faculty_Name = obj.Faculty_Name; objEmpQualificationsDL.DocAttach = obj.DocAttach; objEmpQualificationsDL.Notes = obj.Notes; objEmpQualificationsDL.Qualification_Id = obj.Qualification_Id; objEmpQualificationsDL.Specialization = obj.Specialization; objEmpQualificationsDL.Emp_Serial_No = obj.Emp_Serial_No; objectList.Add(objEmpQualificationsDL); } return(objectList); //Rec_No ,ReferenceNo ,BranchAccount_Id //,Company_Id ,Branch_Id ,Emp_Serial_No ,TransDate ,FromDate ,ToDate ,BackDate ,Reason ,InsUser ,InsDate ,Order_Status ,City_IdOfResidence ,DocumentPath ,BranchAccountTypeName ,StatusName } catch (Exception ex) { catchEntityvalidation((System.Data.Entity.Validation.DbEntityValidationException)ex, System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(), this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString()); ex.InnerException.Message.ToString(); return(null); } finally { CloseEntityConnection(); } }