Пример #1
0
 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);
             }
         }
     }
 }
Пример #2
0
        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);
        }
Пример #3
0
 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");
         }
     }
 }
Пример #4
0
 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);
             }
         }
     }
 }
Пример #5
0
 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");
 }
Пример #6
0
 public static string encontrar(ref ctz_bodegasEntity u)
 {
     return(ctz_bodegasDAL.encontrar(ref u));
 }
Пример #7
0
 public static String eliminar(ctz_bodegasEntity b)
 {
     return(ctz_bodegasDAL.Delete(b));
 }
Пример #8
0
 public static String agregar(ctz_bodegasEntity b)
 {
     return(ctz_bodegasDAL.Agregar(b));
 }
Пример #9
0
 public static String actualizar(ctz_bodegasEntity b)
 {
     return(ctz_bodegasDAL.Update(b));
 }
Пример #10
0
 public static String registrar_scope(ctz_bodegasEntity b)
 {
     return(ctz_bodegasDAL.Insert_Scope(b));
 }
Пример #11
0
 public static String registrar(ctz_bodegasEntity b)
 {
     return(ctz_bodegasDAL.Insert(b));
 }