public List <EmpRptDL> FillEmployeeBySerialAndRoleWithPara(string Company_Id, string Branch_Id, decimal EmpSerialNo, string wherestr) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); List <EmpRptDL> objectList = new List <EmpRptDL>();; try { OpenEntityConnection(); object[] param1 = { new SqlParameter("@Company_Id", Company_Id), new SqlParameter("@Branch_Id", Branch_Id), new SqlParameter("@EmpSerialNo", EmpSerialNo), new SqlParameter("@wherestr", wherestr) }; var objlist = objPharmaEntities.Database.SqlQuery <EmpRptDL>("exec dbo._SpFillEmployeeBySerialAndRoleWithPara @Company_Id,@Branch_Id,@EmpSerialNo,@wherestr", param1).ToList(); if (objlist != null) { foreach (var obj in objlist) { EmpRptDL objCombDL = new EmpRptDL(); objCombDL.Id = Convert.ToString(obj.Id); objCombDL.Name = obj.Name; objCombDL.FullNameArabic = obj.FullNameArabic; objectList.Add(objCombDL); } } } 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()); objectList = null; throw ex; } finally { CloseEntityConnection(); } return(objectList); }
public List <EmpRptDL> FillEmployeeBySerialAndRoleWithShow(string Company_Id, string Branch_Id, decimal EmpSerialNo) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); List <EmpRptDL> objectList = new List <EmpRptDL>();; try { OpenEntityConnection(); object[] param1 = { new SqlParameter("@Company_Id", Company_Id), new SqlParameter("@Branch_Id", Branch_Id), new SqlParameter("@EmpSerialNo", EmpSerialNo) }; // object[] params = { // new SqlParameter("@ParametterWithNummvalue", DBNull.Value), // new SqlParameter("@In_Parameter", "Value"), // new SqlParameter("@Out_Parameter", SqlDbType.INT) //{Direction = ParameterDirection.Output}}; // YourDbContext.Database.ExecuteSqlCommand("exec StoreProcedure_Name @ParametterWithNummvalue, @In_Parameter, @Out_Parameter", params); // YourDbContext.SaveChanges(); //Var ReturnValue = ((SqlParameter)params[2]).Value var objlist = objPharmaEntities.Database.SqlQuery <EmpRptDL>("exec dbo._SpFillEmployeeBySerialAndRoleWithShow @Company_Id,@Branch_Id,@EmpSerialNo", param1).ToList(); //var objlist = objPharmaEntities.Database.ExecuteSqlCommand("exec dbo.SP_GeneralAnyCombo @FldIdName,@FldName,@TblName,@Strwhere", param1); if (objlist != null) { foreach (var obj in objlist) { EmpRptDL objCombDL = new EmpRptDL(); objCombDL.Id = Convert.ToString(obj.Id); objCombDL.Name = obj.Name; objCombDL.FullNameArabic = obj.FullNameArabic; objectList.Add(objCombDL); } } } 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()); objectList = null; throw ex; } finally { CloseEntityConnection(); } return(objectList); }