public List <Budget> GetBudgetForEMP(Employee employee) { List <Budget> budgets = new List <Budget>(); int CurrentBudget, Minbudget, Maxbudget, projectid; string Projectname; using (SqlConnection con = new SqlConnection(connectionstring)) { try { con.Open(); SqlCommand cmd = new SqlCommand("Spu_Focus_GetBudgetForEID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@EID", employee.ID)); SqlDataReader Reader = cmd.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { Projectname = Reader["ProjektName"].ToString(); projectid = int.Parse(Reader["ProjektID"].ToString()); if (Reader["BudgetMin"] == DBNull.Value) { Minbudget = 0; } else { Minbudget = int.Parse(Reader["BudgetMin"].ToString()); } if (Reader["BudgetMax"] == DBNull.Value) { Maxbudget = 0; } else { Maxbudget = int.Parse(Reader["BudgetMax"].ToString()); } if (Reader["CurrentBudget"] == DBNull.Value) { CurrentBudget = 0; } else { CurrentBudget = int.Parse(Reader["CurrentBudget"].ToString()); } Project project = new Project(Projectname, projectid); Budget budget = new Budget(employee, project, CurrentBudget, Minbudget, Maxbudget); budgets.Add(budget); } } // Array.Resize(ref EmpBudget, EmpBudget.Length); return(budgets); } catch (SqlException e) { throw e; } } }
public List <Budget> GetBudgetForProjekt(Project project) { List <Budget> budgets = new List <Budget>(); int EmployeeID, CurrentBudget, Minbudget, Maxbudget; string EmployeeName; using (SqlConnection con = new SqlConnection(connectionstring)) { try { con.Open(); SqlCommand cmd = new SqlCommand("Spu_Focus_GetBudgetForPID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ProjectID", project.ProjectID)); SqlDataReader Reader = cmd.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { EmployeeID = int.Parse(Reader["EmployeeID"].ToString()); if (Reader["CurrentBudget"] == DBNull.Value) { CurrentBudget = 0; } else { CurrentBudget = int.Parse(Reader["CurrentBudget"].ToString()); } EmployeeName = Reader["EmployeeName"].ToString(); if (Reader["BudgetMin"] == DBNull.Value) { Minbudget = 0; } else { Minbudget = int.Parse(Reader["BudgetMin"].ToString()); } if (Reader["BudgetMax"] == DBNull.Value) { Maxbudget = 0; } else { Maxbudget = int.Parse(Reader["BudgetMax"].ToString()); } Employee employee = new Employee(EmployeeName, EmployeeID); Budget budget = new Budget(employee, project, CurrentBudget, Minbudget, Maxbudget); budgets.Add(budget); } } } catch (SqlException e) { throw e; } } return(budgets); }