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