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