public int SaveConfig(tblConfigEntities configEntities)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpInsertUpdatetblConfig", con);
cmd.CommandType = CommandType.StoredProcedure;
//if (String.IsNullOrEmpty(configEntities.KeyName.ToString()) || (configEntities.ID == 0))
//{
// cmd.Parameters.AddWithValue("@Id", DBNull.Value);
//}
//else
//{
// cmd.Parameters.AddWithValue("@Id", configEntities.ID);
//}
cmd.Parameters.AddWithValue("@KeyName", configEntities.KeyName);
cmd.Parameters.AddWithValue("@ConfigValue", configEntities.ConfigValue);
int recordsAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordsAffected);
}
public tblConfigEntities GettblConfigByKeyName(string KeyName)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetByKeyName", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@KeyName", KeyName);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
tblConfigEntities topicEntities = new tblConfigEntities();
topicEntities.KeyName = Convert.ToString(ds.Tables[0].Rows[0]["KeyName"]);
topicEntities.ConfigValue = Convert.ToString(ds.Tables[0].Rows[0]["ConfigValue"]);
return(topicEntities);
}
public JsonResult Add(tblConfigEntities configEntities)
{
tblConfigBL topicBL = new tblConfigBL();
return(Json(topicBL.SavetblConfig(configEntities), JsonRequestBehavior.AllowGet));
}
public int SavetblConfig(tblConfigEntities configEntities)
{
tblConfigDAL topicDAL = new tblConfigDAL();
return(topicDAL.SaveConfig(configEntities));
}
