public string InsertEnvase(E_Envase ObjEnvase)
{
string EnvaseID = "";
SqlDatabase SqlClient = new SqlDatabase(connectionString);
DbConnection tCnn;
tCnn = SqlClient.CreateConnection();
tCnn.Open();
DbTransaction tran = tCnn.BeginTransaction();
try
{
DbCommand SqlCommand = SqlClient.GetStoredProcCommand("[Producto].[Usp_InsertEnvase]");
SqlClient.AddInParameter(SqlCommand, "@NomEnvase", SqlDbType.VarChar, ObjEnvase.NomEnvase);
SqlClient.AddInParameter(SqlCommand, "@UsuarioID", SqlDbType.Int, ObjEnvase.UsuarioID);
EnvaseID = Convert.ToString(SqlClient.ExecuteScalar(SqlCommand, tran));
tran.Commit();
tCnn.Close();
tCnn.Dispose();
SqlCommand.Dispose();
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception(ex.Message);
}
return(EnvaseID);
}
public void UpdateEnvase(E_Envase ObjEnvase, string Tipo)
{
SqlDatabase SqlClient = new SqlDatabase(connectionString);
DbConnection tCnn;
tCnn = SqlClient.CreateConnection();
tCnn.Open();
DbTransaction tran = tCnn.BeginTransaction();
try
{
DbCommand SqlCommand = SqlClient.GetStoredProcCommand("[Producto].[Usp_UpdateEnvase]");
SqlClient.AddInParameter(SqlCommand, "@EnvaseID", SqlDbType.Char, ObjEnvase.EnvaseID);
SqlClient.AddInParameter(SqlCommand, "@NomEnvase", SqlDbType.VarChar, ObjEnvase.NomEnvase);
SqlClient.AddInParameter(SqlCommand, "@UsuarioID", SqlDbType.Int, ObjEnvase.UsuarioID);
SqlClient.AddInParameter(SqlCommand, "@Tipo", SqlDbType.Char, Tipo);
SqlClient.ExecuteNonQuery(SqlCommand, tran);
tran.Commit();
tCnn.Close();
tCnn.Dispose();
SqlCommand.Dispose();
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception(ex.Message);
}
}
private void ObtenerDatosControles()
{
ObjEnvase = new E_Envase();
ObjEnvase.EnvaseID = TxtEnvaseID.Text;
ObjEnvase.NomEnvase = TxtNomEnvase.Text;
ObjEnvase.UsuarioID = AppSettings.UserID;
}
public string InsertEnvase(E_Envase ObjEnvase)
{
string EnvaseID = "";
CD_Producto ObjCD_Producto = new CD_Producto(AppSettings.GetConnectionString);
EnvaseID = ObjCD_Producto.InsertEnvase(ObjEnvase);
return(EnvaseID);
}
public void UpdateEnvase(E_Envase ObjEnvase, string Tipo)
{
CD_Producto ObjCD_Producto = new CD_Producto(AppSettings.GetConnectionString);
ObjCD_Producto.UpdateEnvase(ObjEnvase, Tipo);
}
