public void Delete_Department(Params_Delete_Department i_Params_Delete_Department)
{
// You should Always create a complex type (Class) which has properties matching parameters
// 1. Define Your Connection String
// 2. Create Sql Connection Object
using (SqlConnection oConn = new SqlConnection(connStr))
{
// 3. Open the Connection
oConn.Open();
//4 . Prepare Sql Command Object
using (SqlCommand command = new SqlCommand("UP_DELETE_DEPARTMENT"))
{
//5. Set the Command Type to Stored Procedure
command.CommandType = System.Data.CommandType.StoredProcedure;
//6. Inform the Command on Wich connection it should work
command.Connection = oConn;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "DEPARTMENT_ID", Value = i_Params_Delete_Department.DEPARTMENT_ID
});
command.ExecuteNonQuery();
}
}
}
public List <Employee> Get_Youngest_Employee(Params_Delete_Department i_Params_Delete_Department)
{
DALC.DALC oDALC = new DALC.DALC();
oDALC.connStr = this.connStr;
List <Employee> oList = oDALC.Get_Youngest_Employee(i_Params_Delete_Department);
//oList = oList.OrderBy(x => x.NAME).ToList();
//oList.RemoveAll(x => x.ADDRESS == "Tripoli");
return(oList);
}
//-------------------------------------------------
public List <Manager> GetAllManagersOfDepartment(Params_Delete_Department i_Params_Delete_Department)
{
DALC.DALC oDALC = new DALC.DALC();
oDALC.connStr = this.connStr;
List <Manager> oList = oDALC.GetAllManagersOfDepartment(i_Params_Delete_Department);
//oList = oList.OrderBy(x => x.NAME).ToList();
//oList.RemoveAll(x => x.ADDRESS == "Tripoli");
return(oList);
}
public List <Employee> Get_Youngest_Employee(Params_Delete_Department i_Params_Delete_Department)
{
List <Employee> oList = new List <Employee>();
// 2. Create Sql Connection Object
using (SqlConnection oConn = new SqlConnection(connStr))
{
// 3. Open the Connection
oConn.Open();
//4 . Prepare Sql Command Object
using (SqlCommand command = new SqlCommand("UP_GET_YOUNGEST_EMPLOYEE"))
{
//5. Set the Command Type to Stored Procedure
command.CommandType = System.Data.CommandType.StoredProcedure;
//6. Inform the Command on Wich connection it should work
command.Connection = oConn;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "DEPARTMENT_ID", Value = i_Params_Delete_Department.DEPARTMENT_ID
});
command.ExecuteNonQuery();
// 7. Execute the Command (ExecuteReader)
// 8. The Reader is a kind of Hand/Cursor pointing to data retrieved by the Command
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Employee oEmployee = new Employee();
oEmployee.EMPLOYEE_ID = Convert.ToInt32(reader["EMPLOYEE_ID"]);
oEmployee.FIRST_NAME = Convert.ToString(reader["FIRST_NAME"]);
oEmployee.LAST_NAME = Convert.ToString(reader["LAST_NAME"]);
oEmployee.MOBILE = Convert.ToString(reader["MOBILE"]);
oEmployee.AGE = Convert.ToInt32(reader["AGE"]);
oEmployee.SALARY = Convert.ToDecimal(reader["SALARY"]);
oEmployee.DEPARTMENT_ID = Convert.ToInt32(reader["DEPARTMENT_ID"]);
oList.Add(oEmployee);
}
}
}
}
}
return(oList);
}
//---------------------------------------------------
public List <Manager> GetAllManagersOfDepartment(Params_Delete_Department i_Params_Delete_Department)
{
List <Manager> oList = new List <Manager>();
// 2. Create Sql Connection Object
using (SqlConnection oConn = new SqlConnection(connStr))
{
// 3. Open the Connection
oConn.Open();
//4 . Prepare Sql Command Object
using (SqlCommand command = new SqlCommand("UP_GET_MANAGERS_OF_DEPARTMENT"))
{
//5. Set the Command Type to Stored Procedure
command.CommandType = System.Data.CommandType.StoredProcedure;
//6. Inform the Command on Wich connection it should work
command.Connection = oConn;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "DEPARTMENT_ID", Value = i_Params_Delete_Department.DEPARTMENT_ID
});
command.ExecuteNonQuery();
// 7. Execute the Command (ExecuteReader)
// 8. The Reader is a kind of Hand/Cursor pointing to data retrieved by the Command
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Manager oManager = new Manager();
oManager.MANAGER_ID = Convert.ToInt32(reader["MANAGER_ID"]);
oManager.FIRST_NAME = Convert.ToString(reader["FIRST_NAME"]);
oManager.LAST_NAME = Convert.ToString(reader["LAST_NAME"]);
oManager.DEPARTMENT_ID = Convert.ToInt32(reader["DEPARTMENT_ID"]);
oList.Add(oManager);
}
}
}
}
}
return(oList);
}
public void Delete_Department(Params_Delete_Department i_Params_Delete_Department)
{
DALC.DALC oDALC = new DALC.DALC();
oDALC.connStr = this.connStr;
oDALC.Delete_Department(i_Params_Delete_Department);
}
public List <Employee> Get_Youngest_Employee(Params_Delete_Department i_Params_Delete_Department)
{
BLC.BLC oBLC = new BLC.BLC();
oBLC.connStr = this.MyConfig["AppSettings:MyDBConnection"];
return(oBLC.Get_Youngest_Employee(i_Params_Delete_Department));
}
public List <Manager> GetAllManagersOfDepartment(Params_Delete_Department i_Params_Delete_Department)
{
BLC.BLC oBLC = new BLC.BLC();
oBLC.connStr = this.MyConfig["AppSettings:MyDBConnection"];
return(oBLC.GetAllManagersOfDepartment(i_Params_Delete_Department));
}
public void Delete_Department(Params_Delete_Department i_Params_Delete_Department)
{
BLC.BLC oBLC = new BLC.BLC();
oBLC.connStr = this.MyConfig["AppSettings:MyDBConnection"];
oBLC.Delete_Department(i_Params_Delete_Department);
}
