public async Task <ActionResult> Edit(int id, string Title, string Message, int?TagID, int?TipStatusID)
{
var user = await GetCurrentUserAsync();
var userstate = await GetUserDetails(user);
if (userstate == 2)
{
if (db.TipAndLetters.Find(id) == null)
{
//Show error message
return(NotFound());
}
//Raw query data
string query = "update TipAndLetters set Title = @Title, Message = @Message,TipStatusID = @TipStatusID ,TagID = @TagID" +
" where TipAndLetterID = @id";
SqlParameter[] myparams = new SqlParameter[5];
myparams[0] = new SqlParameter("@Title", Title);
myparams[1] = new SqlParameter("@Message", Message);
myparams[2] = new SqlParameter("@TagID", TagID);
myparams[3] = new SqlParameter("@TipStatusID", TipStatusID);
myparams[4] = new SqlParameter("@id", id);
db.Database.ExecuteSqlCommand(query, myparams);
TipStatus ts = db.TipStatuss.Find(TipStatusID);
if (ts.TipStatusName.Equals("Publish"))
{
return(RedirectToAction("Sendletter/" + id));
}
return(RedirectToAction("List"));
//return RedirectToAction("Show/" + id);
}
else
{
return(RedirectToAction("index", "Home"));
}
}
public async Task <ActionResult> Create(string Title, string Message, int?TagID, int?TipStatusID)
{
var user = await GetCurrentUserAsync();
var userstate = await GetUserDetails(user);
if (userstate == 2)
{
DateTime d = DateTime.Now;
string query = "insert into TipAndLetters (Title, Message,DateCreated, TagID,TipStatusID) " +
"values (@Title, @Message,@DateCreated, @TagID,@TipStatusID)";
SqlParameter[] myparams = new SqlParameter[5];
myparams[0] = new SqlParameter("@Title", Title);
myparams[1] = new SqlParameter("@Message", Message);
myparams[2] = new SqlParameter("@TagID", TagID);
myparams[3] = new SqlParameter("@TipStatusID", TipStatusID);
myparams[4] = new SqlParameter("@DateCreated", d);
db.Database.ExecuteSqlCommand(query, myparams);
TipStatus ts = db.TipStatuss.Find(TipStatusID);
if (ts.TipStatusName.Equals("Publish"))
{
List <TipAndLetter> tl = db.TipAndLetters.ToList();
int id = (int)tl.Max(tipandlet => tipandlet.TipAndLetterID);
return(RedirectToAction("Sendletter/" + id));
}
return(RedirectToAction("List"));
}
else
{
return(RedirectToAction("index", "Home"));
}
}