public async Task <IHttpActionResult> PostTRN_SchemeAuditChild(TRN_SchemeAuditChild tRN_SchemeAuditChild) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } else { string _imagePath = string.Empty; SaveImages saveImages = new SaveImages(); _imagePath = saveImages.isImageSaved(tRN_SchemeAuditChild); var ImageLocation = db.TRN_SchemeAuditChild.Where(x => x.ImageLocation == _imagePath).Select(x => x.ImageLocation); if (ImageLocation.Count() > 0) { return(BadRequest("Data Allready added")); } else { if (_imagePath.Length != 0) { tRN_SchemeAuditChild.ImageLocation = string.Empty; tRN_SchemeAuditChild.ImageLocation = _imagePath; db.TRN_SchemeAuditChild.Add(tRN_SchemeAuditChild); await db.SaveChangesAsync(); } } return(CreatedAtRoute("DefaultApi", new { id = tRN_SchemeAuditChild.Id }, tRN_SchemeAuditChild)); } }
public IHttpActionResult PutTRN_SchemeAuditChild(int id, TRN_SchemeAuditChild tRN_SchemeAuditChild) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tRN_SchemeAuditChild.Id) { return(BadRequest()); } db.Entry(tRN_SchemeAuditChild).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TRN_SchemeAuditChildExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public string Post(TRN_SchemeAuditChild _TRN_SchemeAuditChild, string transactionType) { string ret = string.Empty; try { Parameters[] colparameters = new Parameters[5] { new Parameters("@paramId", _TRN_SchemeAuditChild.Id, DbType.Int32, ParameterDirection.Input), new Parameters("@paramNumber", _TRN_SchemeAuditChild.Number, DbType.String, ParameterDirection.Input), new Parameters("@paramImageLocation", _TRN_SchemeAuditChild.ImageLocation, DbType.String, ParameterDirection.Input), new Parameters("@paramIsSignature", _TRN_SchemeAuditChild.IsSignature, DbType.Int16, ParameterDirection.Input), new Parameters("@paramTransactionType", transactionType, DbType.String, ParameterDirection.Input) }; dbExecutor.ManageTransaction(TransactionType.Open); ret = dbExecutor.ExecuteScalarString(true, CommandType.StoredProcedure, "wsp_TRN_SchemeAuditChild_Post", colparameters, true); dbExecutor.ManageTransaction(TransactionType.Commit); } catch (DBConcurrencyException except) { dbExecutor.ManageTransaction(TransactionType.Rollback); throw except; } catch (Exception ex) { dbExecutor.ManageTransaction(TransactionType.Rollback); throw ex; } return(ret); }
public IHttpActionResult GetTRN_SchemeAuditChild(int id) { TRN_SchemeAuditChild tRN_SchemeAuditChild = db.TRN_SchemeAuditChild.Find(id); if (tRN_SchemeAuditChild == null) { return(NotFound()); } return(Ok(tRN_SchemeAuditChild)); }
public IHttpActionResult DeleteTRN_SchemeAuditChild(int id) { TRN_SchemeAuditChild tRN_SchemeAuditChild = db.TRN_SchemeAuditChild.Find(id); if (tRN_SchemeAuditChild == null) { return(NotFound()); } db.TRN_SchemeAuditChild.Remove(tRN_SchemeAuditChild); db.SaveChanges(); return(Ok(tRN_SchemeAuditChild)); }