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