public async Task InsertAsync(ModelPCB model) { object[] param = { new SqlParameter() { ParameterName = "@ModelID", Value = model.ModelID, SqlDbType = SqlDbType.VarChar}, new SqlParameter() { ParameterName = "@ModelName", Value = model.ModelName, SqlDbType = SqlDbType.VarChar}, new SqlParameter() { ParameterName = "@CreatedBy", Value = model.CreatedBy, SqlDbType = SqlDbType.VarChar}, new SqlParameter() { ParameterName = "@DateCreated", Value = model.DateCreated, SqlDbType = SqlDbType.DateTime}, new SqlParameter() { ParameterName = "@Quantity", Value = model.Quantity, SqlDbType = SqlDbType.Int}, new SqlParameter() { ParameterName = "@SerialNo", Value = model.SerialNo, SqlDbType = SqlDbType.VarChar}, new SqlParameter() { ParameterName = "@CustomerName", Value = model.CustomerName, SqlDbType = SqlDbType.VarChar}, new SqlParameter("@Out_Parameter", SqlDbType.Int) { Direction = ParameterDirection.Output } }; try { _context.Database.ExecuteSqlCommand("EXEC [sp_InsertModel] @ModelID, @ModelName, @CreatedBy, @DateCreated, @Quantity, @SerialNo, @CustomerName", param); await _context.SaveChangesAsync(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task<ActionResult> Create(ModelPCB modelView) { if (ModelState.IsValid) { ModelPCB model = new ModelPCB { ModelID = Guid.NewGuid().ToString(), ModelName = modelView.ModelName, CreatedBy = User.Identity.Name, DateCreated = DateTime.Now, Quantity = modelView.Quantity, SerialNo = modelView.SerialNo, CustomerName = modelView.CustomerName, }; try { await modelService.InsertAsync(model); } catch (Exception ex) { ModelState.AddModelError("ModelName", ex.Message); } return RedirectToAction("Index"); } return PartialView(); }
public async Task<ActionResult> Edit(ModelPCB modelView) { if (ModelState.IsValid) { try { modelView.CreatedBy = User.Identity.Name; modelView.DateCreated = DateTime.Now; await modelService.UpdateAsync(modelView); } catch (Exception ex) { ModelState.AddModelError("ModelName", ex.Message); } return RedirectToAction("Index"); } return View(); }