public static String GetSubCategory(String Name, String Category, String Result) { try { return(SubCategories.Select(String.Format("Name = '{0}' AND Category = '{1}'", Name, Category))[0][Result].ToString()); } catch (Exception ex) { IMessageHandler.ShowError(ISystemMessages.DevelopmentError(ex.Message)); } return(null); }
public void ExecuteStoredProc(SqlCommand Command) { try { Connect(); try { BeginTran(); Command.Connection = VConnection; Command.Transaction = VTransaction; Command.ExecuteNonQuery(); CommitTran(); } catch (Exception ex) { Rollback(); IMessageHandler.ShowError(ISystemMessages.ErrorExecutingCommand(ex.Message)); } } finally { Disconnect(); } }