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); }