public IHttpActionResult UpdateBankVendor(BankDto bankDetails, int siteId)
{
using (var procDb = new Upwork_20171101_LocationValidationEntities())
{
var res = procDb.wsp_AssignVendorToBank(bankDetails.VendorId, siteId, bankDetails.ZoneId, bankDetails.BankNumber);
}
return(Ok());
}
public async Task <IHttpActionResult> DeleteCadVendor(int id)
{
System.Data.Entity.Core.Objects.ObjectParameter op = new System.Data.Entity.Core.Objects.ObjectParameter("VendorId_OUTPUT", typeof(Int32));
using (var procDb = new Upwork_20171101_LocationValidationEntities())
{
var res = procDb.wsp_CadVendor_CRUD("DELETE_DBO_CADVENDOR", id, op, null, null, null);
}
return(Ok());
}
public IHttpActionResult PostCadVendor(CadVendor cadVendor)
{
System.Data.Entity.Core.Objects.ObjectParameter op = new System.Data.Entity.Core.Objects.ObjectParameter("VendorId_OUTPUT", typeof(Int32));
using (var procDb = new Upwork_20171101_LocationValidationEntities())
{
var res = procDb.wsp_CadVendor_CRUD("INSERT_DBO_CADVENDOR", null, op, cadVendor.VendorName, cadVendor.VendorAbbreviation, cadVendor.Description);
}
return(CreatedAtRoute("DefaultApi", new { id = cadVendor.VendorId }, cadVendor));
}
public async Task <IHttpActionResult> PutCadVendor(int id, CadVendor cadVendor)
{
try
{
System.Data.Entity.Core.Objects.ObjectParameter op = new System.Data.Entity.Core.Objects.ObjectParameter("VendorId_OUTPUT", typeof(Int32));
using (var procDb = new Upwork_20171101_LocationValidationEntities())
{
var res = procDb.wsp_CadVendor_CRUD("UPDATE_DBO_CADVENDOR", cadVendor.VendorId, op, cadVendor.VendorName, cadVendor.VendorAbbreviation, cadVendor.Description);
}
}
catch (DbUpdateConcurrencyException)
{
if (!CadVendorExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
