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