public List <delRes> deleteUser([FromBody] delParam info) { var model = new BorgWarnerMisSQLContext(); var testData = model.Database.SqlQuery <delRes>($"EXECUTE dbo.QforDeleteUser @username='******',@token='{info.token}' ").ToList(); return(testData); }
public async Task <IHttpActionResult> Delete([FromBody] delParam param) { try { db0 = getDB0(); r = new ResultInfo <Product>(); item = await db0.Product.FindAsync(param.id); if (db0.PurchaseDetail.Any(x => x.product_id == item.product_id)) { r.result = false; r.message = Resources.Res.Log_Err_Delete_Used; return(Ok(r)); } if (item != null) { db0.Product.Remove(item); db0.ProductDetail.RemoveRange(item.ProductDetail); await db0.SaveChangesAsync(); r.result = true; return(Ok(r)); } else { r.result = false; r.message = Resources.Res.Log_Err_Delete_NotFind; return(Ok(r)); } } catch (DbUpdateException ex) { r.result = false; if (ex.InnerException != null) { r.message = Resources.Res.Log_Err_Delete_DetailExist + "\r\n" + getErrorMessage(ex); } else { r.message = ex.Message; } return(Ok(r)); } catch (Exception ex) { r.result = false; r.message = ex.Message; return(Ok(r)); } finally { db0.Dispose(); } }