public static string Update(ctz_bodegasEntity ctz_bodegas) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString())) { conn.Open(); string sql = @"update ctz_bodegas " + "set " + "cod_bodega = @cod_bodega, " + "nombre_bodega = @nombre_bodega" + " where cod_bodega = @_cod_bodega "; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@cod_bodega", ctz_bodegas.cod_bodega); cmd.Parameters.AddWithValue("@nombre_bodega", ctz_bodegas.nombre_bodega); cmd.Parameters.AddWithValue("@_cod_bodega", ctz_bodegas.cod_bodega); try { cmd.ExecuteNonQuery(); return("OK"); } catch (Exception EX) { return("Error en ctz_bodegasDAL.Update Detalle: " + EX.Message); } } } }
private static ctz_bodegasEntity Load(IDataReader reader) { ctz_bodegasEntity ctz_bodegas = new ctz_bodegasEntity(); ctz_bodegas.cod_bodega = Convert.ToString(reader["cod_bodega"]); ctz_bodegas.nombre_bodega = Convert.ToString(reader["nombre_bodega"]); return(ctz_bodegas); }
public static string Agregar(ctz_bodegasEntity u) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString())) { conn.Open(); string sql_encontrar = @"SELECT count(1) from ctz_bodegas where cod_bodega = @cod_bodega"; SqlCommand cmd_encontrar = new SqlCommand(sql_encontrar, conn); cmd_encontrar.Parameters.AddWithValue("@cod_bodega", u.cod_bodega); try { string respuesta = cmd_encontrar.ExecuteScalar().ToString(); if (Convert.ToInt32(respuesta) > 0) { string resp = Update(u); if (resp == "OK") { return("2"); } else { return("3"); } } else { string resp = Insert(u); if (resp == "OK") { return("1"); } else { return("3"); } } } catch (Exception EX) { return("3"); } } }
public static string Insert_Scope(ctz_bodegasEntity ctz_bodegas) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString())) { conn.Open(); string sql = @"insert into ctz_bodegas(cod_bodega, nombre_bodega) " + "values (@cod_bodega, @nombre_bodega); SELECT SCOPE_IDENTITY(); "; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@cod_bodega", ctz_bodegas.cod_bodega); cmd.Parameters.AddWithValue("@nombre_bodega", ctz_bodegas.nombre_bodega); try { string respuesta = cmd.ExecuteScalar().ToString(); return(respuesta); } catch (Exception EX) { return("Error en ctz_bodegasDAL.Insert Detalle: " + EX.Message); } } } }
public static string encontrar(ref ctz_bodegasEntity u) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString())) { conn.Open(); string sql = @"SELECT * from ctz_bodegas where cod_bodega = @cod_bodega"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@cod_bodega", u.cod_bodega); try { SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { u = Load(reader); return("OK"); } } catch (Exception EX) { return("Error en ctz_bodegasDAL.Validar Detalle: " + EX.Message); } } return("No encontrado en DAL"); }
public static string encontrar(ref ctz_bodegasEntity u) { return(ctz_bodegasDAL.encontrar(ref u)); }
public static String eliminar(ctz_bodegasEntity b) { return(ctz_bodegasDAL.Delete(b)); }
public static String agregar(ctz_bodegasEntity b) { return(ctz_bodegasDAL.Agregar(b)); }
public static String actualizar(ctz_bodegasEntity b) { return(ctz_bodegasDAL.Update(b)); }
public static String registrar_scope(ctz_bodegasEntity b) { return(ctz_bodegasDAL.Insert_Scope(b)); }
public static String registrar(ctz_bodegasEntity b) { return(ctz_bodegasDAL.Insert(b)); }