public List <tbl_setting> GetAllSetting()
{
using (SqlConnection DBCon = new SqlConnection(connectionString))
{
List <tbl_setting> email_awaiting_list = new List <tbl_setting>();
SqlCommand CmdSelect = new SqlCommand("get_setting", DBCon);
CmdSelect.CommandType = CommandType.StoredProcedure;
CmdSelect.Connection = DBCon;
DBCon.Open();
SqlDataReader rd = CmdSelect.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
tbl_setting email_awaiting = new tbl_setting();
email_awaiting.id = Convert.ToInt32((!DBNull.Value.Equals(rd["id"])) ? rd["id"].ToString() : "0");
email_awaiting.key = ((!DBNull.Value.Equals(rd["key"])) ? rd["key"] : string.Empty).ToString();
email_awaiting.value = ((!DBNull.Value.Equals(rd["value"])) ? rd["value"] : string.Empty).ToString();
email_awaiting_list.Add(email_awaiting);
}
}
return(email_awaiting_list);
}
}
public List<tbl_setting> GetAllSetting()
{
using (SqlConnection DBCon = new SqlConnection(connectionString))
{
List<tbl_setting> email_awaiting_list = new List<tbl_setting>();
SqlCommand CmdSelect = new SqlCommand("get_setting", DBCon);
CmdSelect.CommandType = CommandType.StoredProcedure;
CmdSelect.Connection = DBCon;
DBCon.Open();
SqlDataReader rd = CmdSelect.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
tbl_setting email_awaiting = new tbl_setting();
email_awaiting.id = Convert.ToInt32((!DBNull.Value.Equals(rd["id"])) ? rd["id"].ToString() : "0");
email_awaiting.key = ((!DBNull.Value.Equals(rd["key"])) ? rd["key"] : string.Empty).ToString();
email_awaiting.value = ((!DBNull.Value.Equals(rd["value"])) ? rd["value"] : string.Empty).ToString();
email_awaiting_list.Add(email_awaiting);
}
}
return email_awaiting_list;
}
}
public string GetSettingFromKey(string key, string defaultVal)
{
using (SqlConnection DBCon = new SqlConnection(connectionString))
{
SqlCommand CmdSelect = new SqlCommand("get_setting_from_key", DBCon);
CmdSelect.CommandType = CommandType.StoredProcedure;
CmdSelect.Connection = DBCon;
CmdSelect.Parameters.AddWithValue("@key", SqlDbType.VarChar).Value = key;
CmdSelect.Parameters.AddWithValue("@defaultVal", SqlDbType.VarChar).Value = defaultVal;
DBCon.Open();
SqlDataReader rd = CmdSelect.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
tbl_setting email_awaiting = new tbl_setting();
email_awaiting.id = Convert.ToInt32((!DBNull.Value.Equals(rd["id"])) ? rd["id"].ToString() : "0");
email_awaiting.key = ((!DBNull.Value.Equals(rd["key"])) ? rd["key"] : string.Empty).ToString();
email_awaiting.value = ((!DBNull.Value.Equals(rd["value"])) ? rd["value"] : string.Empty).ToString();
return(email_awaiting.value);
}
}
}
return("");
}
public string GetSettingFromKey(string key, string defaultVal)
{
using (SqlConnection DBCon = new SqlConnection(connectionString))
{
SqlCommand CmdSelect = new SqlCommand("get_setting_from_key", DBCon);
CmdSelect.CommandType = CommandType.StoredProcedure;
CmdSelect.Connection = DBCon;
CmdSelect.Parameters.AddWithValue("@key", SqlDbType.VarChar).Value = key;
CmdSelect.Parameters.AddWithValue("@defaultVal", SqlDbType.VarChar).Value = defaultVal;
DBCon.Open();
SqlDataReader rd = CmdSelect.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
tbl_setting email_awaiting = new tbl_setting();
email_awaiting.id = Convert.ToInt32((!DBNull.Value.Equals(rd["id"])) ? rd["id"].ToString() : "0");
email_awaiting.key = ((!DBNull.Value.Equals(rd["key"])) ? rd["key"] : string.Empty).ToString();
email_awaiting.value = ((!DBNull.Value.Equals(rd["value"])) ? rd["value"] : string.Empty).ToString();
return email_awaiting.value;
}
}
}
return "";
}
