public ActionResult CreateTerms(termsModel ob)
{
SqlConnection con = new SqlConnection(constring);
string q = "Insert into termsOfServices(terms_head,terms)" + "values(@terms_head,@terms)";
SqlCommand cmd = new SqlCommand(q, con);
con.Open();
if (ob.terms_head != null)
{
cmd.Parameters.AddWithValue("@terms_head", ob.terms_head);
}
else
{
cmd.Parameters.AddWithValue("@terms_head", DBNull.Value);
}
if (ob.terms != null)
{
cmd.Parameters.AddWithValue("@terms", ob.terms);
}
else
{
cmd.Parameters.AddWithValue("@terms", DBNull.Value);
}
cmd.ExecuteNonQuery();
return(RedirectToAction("TermsTable"));
}
public ActionResult EditTerms(int id)
{
SqlConnection con = new SqlConnection(constring);
string q = "SELECT * from termsOfServices where term_id=@term_id";
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
cmd.Parameters.AddWithValue("@term_id", id);
cmd.ExecuteNonQuery();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
termsModel ob = new termsModel();
if (dt.Rows.Count == 1)
{
ob.term_id = Convert.ToInt32(dt.Rows[0][0].ToString());
ob.terms_head = dt.Rows[0][1].ToString();
ob.terms = dt.Rows[0][2].ToString();
}
return(View(ob));
}
public ActionResult EditTerms(termsModel ob)
{
SqlConnection con = new SqlConnection(constring);
String q = "Update termsOfServices set terms_heads=@terms_heads,terms=@terms where term_id=@term_id";
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
cmd.Parameters.AddWithValue("@term_id", ob.term_id);
cmd.Parameters.AddWithValue("@terms_head ", ob.terms_head);
cmd.Parameters.AddWithValue("@terms ", ob.terms);
cmd.ExecuteNonQuery();
return(RedirectToAction("TermsTable"));
}
public ActionResult CreateTerms()
{
termsModel ob = new termsModel();
return(View(ob));
}
