public async Task <ActionResult> DeleteConfirmed(int id)
{
OurApproach ourApproach = db.OurApproach.Find(id);
db.OurApproach.Remove(ourApproach);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public IHttpActionResult DeleteAboutUs1([FromBody] OurApproach value)
{
OurApproach ourapproach = new OurApproach();
var ourapproachservice = new OurApproachService();
ourapproachservice.DeleteOurApproach(value.Id);
return(Ok(ourapproach));
}
public ActionResult Edit([Bind(Include = "Id,Title,Content")] OurApproach ourApproach)
{
if (ModelState.IsValid)
{
db.Entry(ourApproach).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ourApproach));
}
public IHttpActionResult DeleteAboutUs(int Id)
{
OurApproach ourapproach = new OurApproach();
var ourapproachservice = new OurApproachService();
ourapproachservice.DeleteOurApproach(Id);
return(Ok(ourapproach));
}
public IHttpActionResult AddAboutUs([FromBody] OurApproach value)
{
OurApproach ourapproach = new OurApproach();
var ourapproachservice = new OurApproachService();
ourapproachservice.AddOurApproach(value);
return(Ok(ourapproach));
}
public async Task <ActionResult> Create([Bind(Include = "Id,Title,Content")] OurApproach ourApproach)
{
if (ModelState.IsValid)
{
db.OurApproach.Add(ourApproach);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(ourApproach));
}
public void UpdateOurApproach(OurApproach ourapproach)
{
OurApproachData ourapproachData = new OurApproachData();
try
{
ourapproachData.UpdateOurApproach(ourapproach);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OurApproach ourApproach = db.OurApproach.Find(id);
if (ourApproach == null)
{
return(HttpNotFound());
}
return(View(ourApproach));
}
public List <OurApproach> MapOurApproach(DataTable tbl)
{
List <OurApproach> _List = new List <OurApproach>();
foreach (DataRow row in tbl.Rows)
{
OurApproach ourapproach = new OurApproach()
{
Id = Int32.Parse(row["Id"].ToString()),
Title = row["Title"].ToString(),
Description = row["Description"].ToString()
};
_List.Add(ourapproach);
}
return(_List);
}
public void UpdateOurApproach(OurApproach 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 OurApproach SET Title = '{0}', Description = '{1}' where Id = {2}", value.Title, value.Description, value.Id);
cmdSQL.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
public void AddOurApproach(OurApproach 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 OurApproach (Title, Description) VALUES ('{0}', '{1}')", value.Title, value.Description);
cmdSQL.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
