public void insertTagDetails(Tagmodel tagmodel) { if (con.State.ToString() != "Open") { con.Open(); } int i = 0; string query1 = "SELECT * from Tag_table"; SqlDataReader dr1 = new SqlCommand(query1, con).ExecuteReader(); while (dr1.Read()) { if (tagmodel.Tag_name1.Equals(dr1.GetValue(1).ToString()) || tagmodel.Tag_name1 == "Tutorial") { MessageBox.Show("Tags Repeated!!", "Error"); i = 1; break; } } if (i != 1) { string query = "INSERT INTO Tag_table(Tag_Name) VALUES ('" + tagmodel.Tag_name1 + "')"; SqlCommand com = new SqlCommand(query, con); int ret = NewMethod(com); MessageBox.Show("No of Records have been inserted" + ret, "Information"); } dr1.Close(); con.Close(); }
public void updatetagdetails(Tagmodel tagmodel) { if (con.State.ToString() != "Open") { con.Open(); } string sql = "UPDATE Tag_table SET Tag_Name='" + tagmodel.Tag_name1 + "' WHERE Tag_Id = '" + tagmodel.Tag_id1 + "'"; SqlDataAdapter sad = new SqlDataAdapter(sql, con); sad.SelectCommand.ExecuteNonQuery(); MessageBox.Show(" Record have been updated", "Information"); }
public void DeleteTagdetails(Tagmodel tagmodel) { if (con.State.ToString() != "Open") { con.Open(); } string query = "DELETE FROM Tag_table WHERE Tag_Id='" + tagmodel.Tag_id1 + "'"; SqlCommand com = new SqlCommand(query, con); string ans = MessageBox.Show("Are sure to delete this record?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString(); if (ans == "Yes") { int ret = com.ExecuteNonQuery(); MessageBox.Show("No of records deleted" + ret, "Information"); } con.Close(); }