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