public void insertRecommendationSetting(Recommendation_Setting rs)
{
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@Key", rs.Key);
parameters.Add("@DataType", rs.DataType);
parameters.Add("@Description", rs.Description);
executeNonQuery("INSERT INTO [RS].[RECOMMEND_SETTING_TBL]([Key],[DataType],[Description]) VALUES(@Key ,@DataType,@Description)", parameters);
}
public List<Recommendation_Setting> getListRecommendationSetting()
{
List<Recommendation_Setting> lstRecommendationSetting = new List<Recommendation_Setting>();
Dictionary<string, object> parameters = new Dictionary<string, object>();
SqlDataReader reader = executeReader("SELECT RS.RECOMMEND_SETTING_TBL.[Key],RS.RECOMMEND_SETTING_TBL.[DataType],RS.RECOMMEND_SETTING_TBL.[Description] FROM RS.RECOMMEND_SETTING_TBL,RS.DATATYPE_TBL WHERE RS.RECOMMEND_SETTING_TBL.DataType = RS.DATATYPE_TBL.DataType ", parameters);
while (reader.Read())
{
Recommendation_Setting cs = new Recommendation_Setting();
cs.Key = reader.GetString(reader.GetOrdinal("Key"));
cs.DataType = reader.GetString(reader.GetOrdinal("DataType"));
cs.Description = reader.GetString(reader.GetOrdinal("Description"));
lstRecommendationSetting.Add(cs);
}
reader.Close();
return lstRecommendationSetting;
}
public void updateRecommendationSetting(Recommendation_Setting rs)
{
Recommendation_DAO dao = null;
try
{
dao = new Recommendation_DAO();
dao.beginTransaction();
dao.updateRecommendationSetting(rs);
List<Recommend_Setting_Value> lstAvailable = dao.getListRecommendationSettingValue(rs.Key);
foreach (Recommend_Setting_Value avai in lstAvailable)
{
bool isDeleted = true;
foreach (Recommend_Setting_Value val in rs.Values)
{
if (val.ValueID == avai.ValueID)
{
isDeleted = false;
break;
}
}
if (isDeleted)
dao.deleteRecommendationSettingDetail(avai.ValueID);
}
foreach (Recommend_Setting_Value val in rs.Values)
{
if (val.ValueID != -1)
{
dao.updateRecommendationSettingDetail(val);
}
else
{
dao.insertRecommendationSettingDetail(val);
}
}
dao.commitTransaction();
}
catch (Exception ex)
{
dao.rollbackTransaction();
throw ex;
}
}
public void insertRecommendationSetting(Recommendation_Setting rs)
{
Recommendation_DAO dao = null;
try
{
dao = new Recommendation_DAO();
dao.beginTransaction();
dao.insertRecommendationSetting(rs);
foreach (Recommend_Setting_Value val in rs.Values)
{
dao.insertRecommendationSettingDetail(val);
}
dao.commitTransaction();
}
catch (Exception ex)
{
dao.rollbackTransaction();
throw ex;
}
}
public List<Recommendation_Setting> GetRecommendationSetting()
{
List<Recommendation_Setting> list = new List<Recommendation_Setting>();
Recommendation_Setting item = null;
string str = "SELECT [Key], [DataType],[Description] FROM [RS].[RECOMMEND_SETTING_TBL]";
SqlDataReader dr = executeReader(str);
while (dr.Read())
{
item = new Recommendation_Setting();
item.Key = dr[0].ToString();
item.DataType = dr[1].ToString();
item.Description = dr[2].ToString();
item.Values = null;
list.Add(item);
}
dr.Close();
//-------------------------------
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@Key1", list[i].Key);
Recommend_Setting_Value it = null;
list[i].Values = new List<Recommend_Setting_Value>();
str = "SELECT [Key], [Value], [isDefault] FROM [RS].[RECOMMEND_SETTING_VALUE_TBL] WHERE [Key] = @Key1";
SqlDataReader dr1 = executeReader(str, parameters);
while (dr1.Read())
{
it = new Recommend_Setting_Value();
it.Key = dr1[0].ToString();
it.Value = dr1[1].ToString();
it.isDedault = Convert.ToBoolean(dr1[2]);
list[i].Values.Add(it);
}
dr1.Close();
}
}
return list;
}
public void updateRecommendationSetting(Recommendation_Setting rs)
{
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@Key", rs.Key);
parameters.Add("@DataType", rs.DataType);
parameters.Add("@Description", rs.Description);
executeNonQuery("UPDATE [RS].[RECOMMEND_SETTING_TBL] SET [Key] = @Key ,[DataType] = @DataType ,[Description] = @Description WHERE [Key] = @Key", parameters);
}