public bool Edit(int id, VendorsDto vendor)
{
using (var db = GetConnection())
{
db.Open();
var edited = db.Execute(@"Update [dbo].[Vendor]
SET [Name] = @VendorName
,[PhoneNumber] = @PhoneNumber
,[ContactName] = @ContactName
,[FieldOfWork] = @FieldOfWork
,[VendorTypeId] = @VendorTypeId
WHERE [Id] = @Id", new
{
vendor.VendorName,
vendor.PhoneNumber,
vendor.ContactName,
vendor.FieldOfWork,
vendor.VendorTypeId,
vendor.VendorTypeName,
id
});
return(edited == 1);
}
}
public HttpResponseMessage EditVendor(int Id, VendorsDto vendor)
{
var repository = new VendorsRepository();
var result = repository.Edit(Id, vendor);
if (result)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Vendor could not be updated"));
}
public HttpResponseMessage AddNewVendor(VendorsDto vendor)
{
var repository = new VendorsRepository();
var result = repository.Create(vendor);
if (result)
{
return(Request.CreateResponse(HttpStatusCode.Created));
}
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Vendor could not be added"));
}
public bool Create(VendorsDto vendor)
{
using (var db = GetConnection())
{
db.Open();
var records = db.Execute(@"INSERT INTO [dbo].[Vendor]
([Name]
,[PhoneNumber]
,[ContactName]
,[FieldOfWork]
,[VendorTypeId])
VALUES
(@Name
,@PhoneNumber
,@ContactName
,@FieldOfWork
,@VendorTypeId)", vendor);
return(records == 1);
}
}
