public Task <int> Update(Vehiculos vehiculo)
{
var dbPara = new DynamicParameters();
dbPara.Add("id", vehiculo.ID);
dbPara.Add("Marca", vehiculo.Marca, DbType.String);
dbPara.Add("Modelo", vehiculo.Modelo, DbType.String);
dbPara.Add("Año", vehiculo.Año, DbType.String);
dbPara.Add("Color", vehiculo.Color, DbType.String);
dbPara.Add("Precio_Dia", vehiculo.Precio_Dia, DbType.Double);
dbPara.Add("Tipo", vehiculo.Tipo, DbType.String);
dbPara.Add("Capacidad_Carga", vehiculo.Capacidad_Carga, DbType.Double);
dbPara.Add("Pasajeros", vehiculo.Pasajeros, DbType.Int32);
dbPara.Add("Matricula", vehiculo.Matricula, DbType.String);
dbPara.Add("NO_Seguro", vehiculo.No_Seguro, DbType.String);
dbPara.Add("Foto", vehiculo.Foto, DbType.String);
dbPara.Add("Latitud", vehiculo.Latitud, DbType.Double);
dbPara.Add("Longitud", vehiculo.Longitud, DbType.Double);
var updateVehiculos = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Vehiculos]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateVehiculos);
}
public Task <int> Update(Store store)
{
var dbPara = new DynamicParameters();
dbPara.Add("ID", store.ID, DbType.Int32);
dbPara.Add("StoreName", store.StoreName, DbType.String);
dbPara.Add("StoreAddress", store.StoreAddress, DbType.String);
dbPara.Add("StoreAddress2", store.StoreAddress2, DbType.String);
dbPara.Add("StoreAddress3", store.StoreAddress3, DbType.String);
dbPara.Add("StoreLocalPhone", store.StoreLocalPhone, DbType.String);
dbPara.Add("StoreMobilePhone", store.StoreMobilePhone, DbType.String);
dbPara.Add("StoreFax", store.StoreFax, DbType.String);
dbPara.Add("StoreBANKAC1", store.StoreBANKAC1, DbType.String);
dbPara.Add("StoreBANKAC2", store.StoreBANKAC2, DbType.String);
dbPara.Add("StoreBANKAC3", store.StoreBANKAC3, DbType.String);
dbPara.Add("StoreEmail", store.StoreEmail, DbType.String);
dbPara.Add("StoreUnit", store.StoreUnit, DbType.Int32);
dbPara.Add("StoreItemPerPage", store.StoreItemPerPage, DbType.Int32);
dbPara.Add("StoreLanguage", store.StoreLanguage, DbType.Int32);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Store3]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task<int> Update(c_order c_Order)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", c_Order.id);
dbPara.Add("Name", c_Order.name, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update<int>("c_order",
dbPara,
commandType: CommandType.StoredProcedure));
return updateArticle;
}
//Metodo para actualziar los campos de la tabla 'Clientes' de la base de datos
public Task <int> Update(Clientes cliente)
{
var dbPara = new DynamicParameters();
dbPara.Add("id", cliente.ID);
dbPara.Add("Cedula", cliente.Cedula, DbType.String);
dbPara.Add("Nombre", cliente.Nombre, DbType.String);
dbPara.Add("Apellido", cliente.Apellido, DbType.String);
dbPara.Add("Correo", cliente.Correo, DbType.String);
dbPara.Add("Licencia", cliente.Licencia, DbType.String);
dbPara.Add("Nacionalidad", cliente.Nacionalidad, DbType.String);
dbPara.Add("Tipo_Sangre", cliente.Tipo_Sangre, DbType.String);
dbPara.Add("Foto_Persona", cliente.Foto_Persona, DbType.String);
dbPara.Add("Foto_Licencia", cliente.Foto_Licencia, DbType.String);
var updateClientes = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Clientes]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateClientes);
}
public Task <int> AltualizarPago(string id, double pago)
{
var dbPara = new DynamicParameters();
dbPara.Add("id", id);
dbPara.Add("Monto_pagar", pago, DbType.Double);
var updateClienteEstado = Task.FromResult(_dapperManager.Update <int>("[dbo].[Update_Pago_Factur]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateClienteEstado);
}
public Task <int> Update(Article article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", article.ID);
dbPara.Add("Title", article.Title, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Article]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(ClientCategores article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", article.ClientCategoryId);
dbPara.Add("CategoryName", article.CategoryName, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_ClientCategores]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(BookGenres article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", article.BookGenreId);
dbPara.Add("BookGenreName", article.BookGenreName, DbType.String);
dbPara.Add("MoreLikeBookGenreId", article.MoreLikeBookGenreId, DbType.Int32);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_BookGenres]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(FeatureValue featureValue)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", featureValue.ID);
dbPara.Add("Name", featureValue.Name, DbType.String);
dbPara.Add("Value", featureValue.Value, DbType.String);
var updateFeatureValue = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_FeatureValue]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateFeatureValue);
}
public Task <int> Update(Stock stock)
{
var dbPara = new DynamicParameters();
dbPara.Add("ProductID", stock.ProductID, DbType.Int32);
dbPara.Add("StockCost", stock.StockCost, DbType.Double);
dbPara.Add("StockQty", stock.StockQty, DbType.Double);
dbPara.Add("UpdatedDateTime", stock.UpdatedDateTime, DbType.DateTime);
dbPara.Add("UpdatedBy", stock.UpdatedBy, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Article]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(Customer customer)
{
var dbPara = new DynamicParameters();
dbPara.Add("ID", customer.ID, DbType.Int32);
dbPara.Add("CustomerPhone", customer.CustomerPhone, DbType.Int32);
dbPara.Add("CustomerName", customer.CustomerName, DbType.String);
dbPara.Add("CustomerCompany", customer.CustomerCompany, DbType.String);
dbPara.Add("CustomerEmail", customer.CustomerEmail, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Customer]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(User user)
{
var dbPara = new DynamicParameters();
/*dbPara.Add("ProductID", order.ProductID, DbType.Int32);
* dbPara.Add("StockCost", order.StockCost, DbType.Double);
* dbPara.Add("StockQty", order.StockQty, DbType.Double);
* dbPara.Add("StockDate", order.StockDate, DbType.DateTime);
* dbPara.Add("LastUpdateDate", order.LastUpdateDate, DbType.DateTime);
* dbPara.Add("LastUpdateUser", order.LastUpdateUser, DbType.String);
*/
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Article]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(Article article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", article.ID);
dbPara.Add("Title", article.Title, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>($"UPDATE Article SET Title = ('{article.Title}') WHERE ID= {article.ID}", null,
commandType: CommandType.Text));
//var updateArticle = Task.FromResult(_dapperManager.Update<int>("[dbo].[SP_Update_Article]",
// dbPara,
// commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(Product product, Boolean isDelete)
{
var dbPara = new DynamicParameters();
dbPara.Add("ID", product.ID, DbType.Int32);
dbPara.Add("ProductName", product.ProductName, DbType.String);
dbPara.Add("ProductDetails", product.ProductDetails, DbType.String);
dbPara.Add("ProductOrigin", product.ProductOrigin, DbType.String);
dbPara.Add("ProductPrice", product.ProductPrice, DbType.Double);
dbPara.Add("DELETED", isDelete, DbType.Boolean);
dbPara.Add("UpdatedDateTime", System.DateTime.Now, DbType.DateTime);
dbPara.Add("UpdatedBy", "abc", DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_Product_2]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(SaleTxn saleTxn)
{
var dbPara = new DynamicParameters();
dbPara.Add("ID", saleTxn.ID, DbType.Int32);
dbPara.Add("SaleTxnStatus", saleTxn.SaleTxnStatus, DbType.Int32);
dbPara.Add("SaleTxnProductID", saleTxn.SaleTxnProductID, DbType.Int32);
dbPara.Add("SaleTxnQty", saleTxn.SaleTxnQty, DbType.Double);
dbPara.Add("SaleTxnSubTotal", saleTxn.SaleSubTotal, DbType.Double);
dbPara.Add("SaleReceivedQty", saleTxn.SaleReceivedQty, DbType.Double);
dbPara.Add("DELETED", false, DbType.Boolean);
dbPara.Add("UpdatedDateTime", System.DateTime.Now, DbType.DateTime);
dbPara.Add("UpdatedBy", "abc", DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_SaleTxn]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
public Task <int> Update(Books article)
{
return(Task.Run(() =>
{
var dbPara = new DynamicParameters();
dbPara.Add("BookId", article.BookId);
dbPara.Add("BookName", article.BookName, DbType.String);
dbPara.Add("BookSize", article.BookSize, DbType.Int32);
var updateArticle = _dapperManager.Update <int>("[dbo].[SP_Update_Books]",
dbPara,
commandType: CommandType.StoredProcedure);
_dapperManager.Execute($"Delete AuthorBook where BookId = {article.BookId}", null,
commandType: CommandType.Text);
_dapperManager.Execute($"Delete BookBookGenres where BookId = {article.BookId}", null,
commandType: CommandType.Text);
var articleId = article.BookId;
foreach (var author in article.AuthorList)
{
dbPara = new DynamicParameters();
dbPara.Add("AuthorId", author.AuthorId, DbType.Int32);
dbPara.Add("BookId", articleId, DbType.Int32);
_dapperManager.Insert <int>("[dbo].[SP_Add_AuthorBook]",
dbPara,
commandType: CommandType.StoredProcedure);
}
foreach (var author in article.BookGenreList)
{
dbPara = new DynamicParameters();
dbPara.Add("BookGenreId", author.BookGenreId, DbType.Int32);
dbPara.Add("BookId", articleId, DbType.Int32);
_dapperManager.Insert <int>("[dbo].[SP_Add_BookBookGenrese]",
dbPara,
commandType: CommandType.StoredProcedure);
}
return updateArticle;
}));
}
public async Task <IActionResult> Put([FromBody] City city)
{
await manager.Update(city);
return(Ok());
}
public async Task <IActionResult> Put([FromBody] Branch Branch)
{
await manager.Update(Branch);
return(Ok());
}
public async Task <IActionResult> Put([FromBody] Class Class)
{
await manager.Update(Class);
return(Ok());
}
