public static int GetUltimoNumeroFactura(SqlTransaction transaction) { var sp = new StoreProcedure(DataBaseConst.Factura.SPGetUltimoNumeroFactura); var numeroFactura = Convert.ToInt32(sp.ExecuteScalar(transaction)); return(numeroFactura); }
public Rol InsertRol(Rol rol) { List <SPParameter> param = new List <SPParameter>(); param.Add(new SPParameter("rolName", rol.Name)); param.Add(new SPParameter("rolHabilitado", rol.Habilitado)); StoreProcedure sp = new StoreProcedure(DataBaseConst.Rol.SP_InsertRol, param); rol.ID = (int)sp.ExecuteScalar(); return(rol); }