public static bool Update(DepartmentCOMMON pDepart)
{
bool retorno = true;
try
{
var conn = new SqlConnection(CadenaDeConexion);
conn.Open();
// 1. identificamos el store procedure a ejecutar
SqlCommand cmd = new SqlCommand("Update_Department", conn);
// 2. identificamos el tipo de ejecución, en este caso un SP
cmd.CommandType = CommandType.StoredProcedure;
// 3. en caso de que los lleve se ponen los parametros del SP
cmd.Parameters.Add(new SqlParameter("@Id", pDepart.Id));
cmd.Parameters.Add(new SqlParameter("@Name", pDepart.Name));
foreach (CityCOMMON c in pDepart.ListCities)
{
if (c.Id == 0)
{
Boolean allOk = CityPERS.Add(pDepart.Id, c);
}
}
// ejecutamos el store desde c#
int rtn = cmd.ExecuteNonQuery();
if (rtn <= 0)
{
retorno = false;
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(retorno);
}
public static List <DepartmentCOMMON> SearchAll()
{
List <DepartmentCOMMON> retorno = new List <DepartmentCOMMON>();
DepartmentCOMMON Department;
try
{
var conn = new SqlConnection(CadenaDeConexion);
conn.Open();
// 1. identificamos el store procedure a ejecutar
SqlCommand cmd = new SqlCommand("Select_All_Department", conn);
// 2. identificamos el tipo de ejecución, en este caso un SP
cmd.CommandType = CommandType.StoredProcedure;
// ejecutamos el store desde c#
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
Department = new DepartmentCOMMON();
Department.Id = short.Parse(oReader["Department_Id"].ToString());
Department.Name = oReader["Department_Name"].ToString();
try{
Department.ListCities = CityPERS.SearchAllofDepartment(Department.Id);
}
catch (Exception ex) {
throw ex;
}
retorno.Add(Department);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(retorno);
}
public static bool Delete(DepartmentCOMMON pDepart)
{
bool retorno = true;
try
{
var conn = new SqlConnection(CadenaDeConexion);
conn.Open();
// 1. identificamos el store procedure a ejecutar
SqlCommand cmd = new SqlCommand("Delete_Department", conn);
// 2. identificamos el tipo de ejecución, en este caso un SP
cmd.CommandType = CommandType.StoredProcedure;
// 3. en caso de que los lleve se ponen los parametros del SP
cmd.Parameters.Add(new SqlParameter("@Department_Id", pDepart.Id));
// ejecutamos el store desde c#
int rtn = cmd.ExecuteNonQuery();
if (rtn <= 0)
{
retorno = false;
}
// si la conexion esta abierta, la cerramos.
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(retorno);
}
public static DepartmentCOMMON SearchDepartment(DepartmentCOMMON pDepart)
{
DepartmentCOMMON Department = null;
try
{
var conn = new SqlConnection(CadenaDeConexion);
conn.Open();
// 1. identificamos el store procedure a ejecutar
SqlCommand cmd = new SqlCommand("Select_Department", conn);
// 2. identificamos el tipo de ejecución, en este caso un SP
cmd.CommandType = CommandType.StoredProcedure;
// 3. en caso de que los lleve se ponen los parametros del SP
cmd.Parameters.Add(new SqlParameter("@Department_Id", pDepart.Id));
// ejecutamos el store desde c#
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
Department = new DepartmentCOMMON();
Department.Id = short.Parse(oReader["Department_Id"].ToString());
Department.Name = oReader["Department_Name"].ToString();
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Department);
}
public ActionResult addDepartment(DepartmentModels pModel)
{
DepartmentCOMMON unDpto = new DepartmentCOMMON();
unDpto.Name = pModel.Name;
List <DepartmentCOMMON> theList = new List <DepartmentCOMMON>();
if (Session["LaLista"] != null)
{
theList = (List <DepartmentCOMMON>)Session["LaLista"];
}
theList.Add(unDpto);
Fachada Fachada = new Fachada();
Fachada.Department_Add(unDpto);
Session["LaLista"] = theList;
#region Vaciar Textboxs
pModel.mensaje = "Ingreso Correcto";
#endregion
return(View(pModel));
}
public static bool Update(DepartmentCOMMON pDpart)
{
return(DepartmentPERS.Update(pDpart));
}
public static bool Delete(DepartmentCOMMON pDpart)
{
return(DepartmentPERS.Delete(pDpart));
}
public static bool Add(DepartmentCOMMON pDpart)
{
return(DepartmentPERS.Add(pDpart));
}
public static bool Department_Update(DepartmentCOMMON pDpart)
{
return(DepartmentDOM.Update(pDpart));
}
public static bool Department_Add(DepartmentCOMMON pDpart)
{
return(DepartmentDOM.Add(pDpart));
}