public Target_Setting Get_Setting()
{
Target_Setting target_Setting = new Target_Setting();
dao = new DAO(DBConnection.enConnectionType.SourceConnectionString);
cmd = new SqlCommand();
cmd.CommandText = "select [SETTING_ID],[SETTING_NAME_VC],[SETTING_VALUE_VC],[SETTING_DESCRIPTION_VC] FROM [SETTINGS] where[SETTING_ID] in (16,18,19,108)";
SqlDataReader sqlDataReader = dao.ExeDataReader(cmd);
while (sqlDataReader.Read())
{
Int32 SETTING_ID;
SETTING_ID = Convert.ToInt32(sqlDataReader["SETTING_ID"]);
if (SETTING_ID == 16)
{
target_Setting.RestaurantTitle = Convert.ToString(sqlDataReader["SETTING_VALUE_VC"]);
}
if (SETTING_ID == 18)
{
target_Setting.RestaurantAddress = Convert.ToString(sqlDataReader["SETTING_VALUE_VC"]);
}
if (SETTING_ID == 19)
{
target_Setting.Phone = Convert.ToString(sqlDataReader["SETTING_VALUE_VC"]);
}
if (SETTING_ID == 108)
{
target_Setting.ResturantId = Convert.ToInt64(sqlDataReader["SETTING_VALUE_VC"]);
}
}
return(target_Setting);
}
private void Fill_Resturant(DAL.Source.Target_Setting target_Setting)
{
txtPhone.Text = target_Setting.Phone;
txtRestaurantAddress.Text = target_Setting.RestaurantAddress;
txtRestaurantTitle.Text = target_Setting.RestaurantTitle;
txtTwoPersonCost.Text = target_Setting.TwoPersonCost.ToString();
txtX.Text = target_Setting.X;
txtY.Text = target_Setting.Y;
txtRestaurantId.Text = target_Setting.ResturantId.ToString();
chkHasHealthyFood.Checked = target_Setting.HasHealthyFood;
chkHasHokan.Checked = target_Setting.HasHokan;
chkHasParking.Checked = target_Setting.HasParking;
chkHasSeaFood.Checked = target_Setting.HasSeaFood;
}