public string InsertFamilia(E_Familia ObjFamilia)
{
string IDFamilia = "";
SqlDatabase SqlClient = new SqlDatabase(connectionString);
DbConnection tCnn;
tCnn = SqlClient.CreateConnection();
tCnn.Open();
DbTransaction tran = tCnn.BeginTransaction();
try
{
DbCommand SqlCommand = SqlClient.GetStoredProcCommand("[Producto].[Usp_InsertFamilia]");
SqlClient.AddInParameter(SqlCommand, "@NomFamilia", SqlDbType.VarChar, ObjFamilia.NomFamilia);
SqlClient.AddInParameter(SqlCommand, "@UsuarioID", SqlDbType.Int, ObjFamilia.UsuarioID);
IDFamilia = 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(IDFamilia);
}
public void UpdateFamilia(E_Familia ObjFamilia, 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_UpdateFamilia]");
SqlClient.AddInParameter(SqlCommand, "@IDFamilia", SqlDbType.Char, ObjFamilia.IDFamilia);
SqlClient.AddInParameter(SqlCommand, "@NomFamilia", SqlDbType.VarChar, ObjFamilia.NomFamilia);
SqlClient.AddInParameter(SqlCommand, "@UsuarioID", SqlDbType.Int, ObjFamilia.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()
{
ObjFamilia = new E_Familia();
ObjFamilia.IDFamilia = TxtIDFamilia.Text;
ObjFamilia.NomFamilia = TxtNomFamilia.Text;
ObjFamilia.UsuarioID = AppSettings.UserID;
}
public string InsertFamilia(E_Familia ObjFamilia)
{
string IDFamilia = "";
CD_Producto ObjCD_Producto = new CD_Producto(AppSettings.GetConnectionString);
IDFamilia = ObjCD_Producto.InsertFamilia(ObjFamilia);
return(IDFamilia);
}
public void UpdateFamilia(E_Familia ObjFamilia, string Tipo)
{
CD_Producto ObjCD_Producto = new CD_Producto(AppSettings.GetConnectionString);
ObjCD_Producto.UpdateFamilia(ObjFamilia, Tipo);
}
