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