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