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