public int DeleteNews(BONews objNews) { dCmd = objDatabaseHelper.Command; dCmd.CommandText = "SP_DeleteNews"; dCmd.CommandType = CommandType.StoredProcedure; try { objDatabaseHelper.BeginTransaction(); objDatabaseHelper.AddParameter("@NewsID", objNews.NewsID, SqlDbType.Int); returnValue = Convert.ToInt32(objDatabaseHelper.ExecuteNonQuery(dCmd.CommandText, dCmd.CommandType, DatabaseHelper.ConnectionState.KeepOpen)); objDatabaseHelper.CommitTransaction(); } catch { objDatabaseHelper.RollbackTransaction(); } finally { if (objDatabaseHelper.Connection.State == System.Data.ConnectionState.Open) { objDatabaseHelper.Connection.Close(); } } return(returnValue); }
public ActionResult RemoveNews(Guid id) { BONews BON = new BONews(); BON.NewsId = id; var Response = client.DeleteAsync("News/" + BON.NewsId).Result; if (Response.IsSuccessStatusCode) { var Responsedata = Convert.ToBoolean(Response.Content.ReadAsStringAsync().Result); if (Responsedata == true) { return(RedirectToAction("ManageNews", "News")); } else { TempData ["DeleteSuccess"] = false; } } else { Console.WriteLine("Fail"); } return(null); }
public int deleteNews(BONews objNews) { DALNesw objDALNesw = new DALNesw(); try { return(objDALNesw.DeleteNews(objNews)); } catch { throw; } finally { objDALNesw = null; } }
public async System.Threading.Tasks.Task <ActionResult> InsertNews(FormCollection FC) { if (ModelState.IsValid) { BONews BON = new BONews(); BON.News1 = FC ["News1"]; if (BON.News1 != "") { if (FC ["NewsId"] != null) { BON.NewsId = Guid.Parse(FC ["NewsId"]); var Response = await client.PutAsJsonAsync("News", BON); if (Response.IsSuccessStatusCode) { var Responsedata = Convert.ToBoolean(Response.Content.ReadAsStringAsync().Result); if (Responsedata == true) { TempData ["UpdateSuccess"] = true; } else { TempData ["UpdateSuccess"] = false; } } else { ViewBag.UpdateSuccess = false; } } else { var Response = await client.PostAsJsonAsync("News", BON); if (Response.IsSuccessStatusCode) { var Responsedata = Convert.ToBoolean(Response.Content.ReadAsStringAsync().Result); if (Responsedata == true) { TempData ["InsertSuccess"] = true; } else { TempData ["InsertSuccess"] = false; } } else { ViewBag.InsertSuccess = false; } } } else { TempData ["DataNull"] = true; } } else { TempData ["DataNull"] = true; } return(RedirectToAction("ManageNews", "News")); }