public BECommonConfig GetCommonConfig(SQLHelper sqlHelper, string GroupName, int id) { string sql = string.Empty; BECommonConfigs CommonConfigs = new BECommonConfigs(); try { sql = sqlHelper.MakeSQL("SELECT * FROM TblCommonConfig"); if (GroupName != "") { sql = sqlHelper.MakeSQL(sql + " WHERE GroupName=$s", GroupName); } IDataReader reader = sqlHelper.ExecuteQuery(sql); AddToCommonConfigCollection(CommonConfigs, reader); reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } if (CommonConfigs.Count > 0) { return(CommonConfigs[0]); } else { return(new BECommonConfig()); } }
private BECommonConfigs AddToCommonConfigCollection(BECommonConfigs CommonConfigs, IDataReader reader) { NULLHandler nullHandler = new NULLHandler(reader); while (reader.Read()) { CommonConfigs.Add(PreaperCommonConfigObject(nullHandler)); } return(CommonConfigs); }
public BECommonConfigs GetCommonConfigs(string GroupName) { try { BECommonConfigs commonConfigs = null; sqlHelper = new SQLHelper(); commonConfigs = daCommonConfig.GetCommonConfigs(sqlHelper, GroupName); sqlHelper.CommitTran(); return(commonConfigs); } catch (Exception ex) { RnD.BLTemp.Common.Utility.SaveErrorLog(this.GetType().ToString(), "", ex); if (sqlHelper != null) { sqlHelper.Rollback(); } throw ex; } }