public IHttpActionResult DeleteAboutUs(int Id)
{
HowToInvolve howtoinvolve = new HowToInvolve();
var howtoinvolveservice = new HowToInvolveService();
howtoinvolveservice.DeleteHowToInvolve(Id);
return(Ok(howtoinvolve));
}
public IHttpActionResult DeleteAboutUs1([FromBody] HowToInvolve value)
{
HowToInvolve howtoinvolve = new HowToInvolve();
var howtoinvolveservice = new HowToInvolveService();
howtoinvolveservice.DeleteHowToInvolve(value.Id);
return(Ok(howtoinvolve));
}
public IHttpActionResult UpdateHowToInvolve([FromBody] HowToInvolve value)
{
HowToInvolve howtoinvolve = new HowToInvolve();
var howtoinvolveservice = new HowToInvolveService();
howtoinvolveservice.UpdateHowToInvolve(value);
return(Ok(howtoinvolve));
}
public void UpdateHowToInvolve(HowToInvolve howtoinvolve)
{
HowToInvolveData howtoinvolveData = new HowToInvolveData();
try
{
howtoinvolveData.UpdateHowToInvolve(howtoinvolve);
}
catch (Exception ex)
{
throw ex;
}
}
public List <HowToInvolve> MapHowToInvolve(DataTable tbl)
{
List <HowToInvolve> _List = new List <HowToInvolve>();
foreach (DataRow row in tbl.Rows)
{
HowToInvolve howtoinvolve = new HowToInvolve()
{
Id = Int32.Parse(row["Id"].ToString()),
Title = row["Title"].ToString(),
Description = row["Description"].ToString()
};
_List.Add(howtoinvolve);
}
return(_List);
}
public void UpdateHowToInvolve(HowToInvolve value)
{
System.Data.SqlClient.SqlCommand cmdSQL = null;
System.Data.SqlClient.SqlConnection cnSQL = null;
string ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["SteppingStoneDB"].ConnectionString;
try
{
cnSQL = new System.Data.SqlClient.SqlConnection(ConnString);
cnSQL.Open();
cmdSQL = new System.Data.SqlClient.SqlCommand();
cmdSQL.Connection = cnSQL;
cmdSQL.CommandType = CommandType.Text;
cmdSQL.CommandText = String.Format("UPDATE HowToInvolve SET Title = '{0}', Description = '{1}' where Id = {2}", value.Title, value.Description, value.Id);
cmdSQL.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
public void AddHowToInvolve(HowToInvolve value)
{
System.Data.SqlClient.SqlCommand cmdSQL = null;
System.Data.SqlClient.SqlConnection cnSQL = null;
string ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["SteppingStoneDB"].ConnectionString;
try
{
cnSQL = new System.Data.SqlClient.SqlConnection(ConnString);
cnSQL.Open();
cmdSQL = new System.Data.SqlClient.SqlCommand();
cmdSQL.Connection = cnSQL;
cmdSQL.CommandType = CommandType.Text;
cmdSQL.CommandText = String.Format("INSERT INTO HowToInvolve (Title, Description) VALUES ('{0}', N'{1}')", value.Title, value.Description);
cmdSQL.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
