public async Task <IActionResult> Delete(int?id)
{
if (id == null)
{
return(NotFound());
}
Special_Tags st = null;
if (orm == 1)
{
st = db.retSpecialTag((int)id);
}
else
{
st = await _db.SpecialTags.FindAsync(id);
}
if (st == null)
{
return(NotFound());
}
return(View(st));
}
public Special_Tags retSpecialTag(int id)
{
SqlCommand cmd = new SqlCommand("fspecialtag", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter pmt = new SqlParameter("@id", SqlDbType.Int);
pmt.Value = id;
cmd.Parameters.Add(pmt);
connection.Open();
var read = cmd.ExecuteReader();
Special_Tags tag = null;
while (read.Read())
{
tag = new Special_Tags()
{
Id = Convert.ToInt32(read[0]),
Name = read[1].ToString()
};
}
connection.Close();
return(tag);
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
Special_Tags st = await _db.SpecialTags.FindAsync(id);
return(View(st));
}
public void InSpecialTagses(Special_Tags input)
{
//List<Special_Tags> ls = new List<Special_Tags>();
SqlCommand cmd = new SqlCommand("inspacialtag", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter pmt = new SqlParameter("@name", System.Data.SqlDbType.NVarChar);
pmt.Value = input.Name;
cmd.Parameters.Add(pmt);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
public void upSpecialTag(Special_Tags input)
{
SqlCommand cmd = new SqlCommand("upspecialtag", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter pmt = new SqlParameter("@name", System.Data.SqlDbType.NVarChar);
SqlParameter pmt2 = new SqlParameter("@id", SqlDbType.Int);
pmt.Value = input.Name;
pmt2.Value = input.Id;
cmd.Parameters.Add(pmt);
cmd.Parameters.Add(pmt2);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
public async Task <IActionResult> DelteConfirmed(int id)
{
if (orm == 1)
{
db.rmSpecialTag(id);
}
else
{
Special_Tags st = await _db.SpecialTags.FindAsync(id);
_db.Remove(st);
await _db.SaveChangesAsync();
}
TempData["delete"] = 1;
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create(Special_Tags st)
{
if (ModelState.IsValid)
{
if (orm == 1)
{
db = new Qdatabase();
db.InSpecialTagses(st);
}
else
{
_db.Add(st);
await _db.SaveChangesAsync();
}
TempData["create"] = 1;
return(RedirectToAction(nameof(Index)));
}
return(View(st));
}
public async Task <IActionResult> Edit(int id, Special_Tags st)
{
if (id != st.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (orm == 1)
{
db.upSpecialTag(st);
}
else
{
_db.Update(st);
await _db.SaveChangesAsync();
}
TempData["edit"] = 1;
return(RedirectToAction(nameof(Index)));
}
return(View(st));
}
