public Task <FeatureValue> GetById(int id)
{
var featureValue = Task.FromResult(_dapperManager.Get <FeatureValue>($"select * from [FeatureValue] where ID = {id}", null,
commandType: CommandType.Text));
return(featureValue);
}
public Task <int> Count(string search)
{
var totArticle = Task.FromResult(_dapperManager.Get <int>($"select COUNT(*) from [Books] WHERE BookName like '%{search}%'", null,
commandType: CommandType.Text));
return(totArticle);
}
public Task <ClientCategores> GetById(int id)
{
var article = Task.FromResult(_dapperManager.Get <ClientCategores>($"select * from [ClientCategores] where ClientCategoryId = {id}", null,
commandType: CommandType.Text));
return(article);
}
//ESTE OBTINE EL ID DEL LOGIN
public Task <string> getloginID(string UserID, string passID)
{
var article = Task.FromResult(_dapperManager.Get <string>($"select ID_login from [login] where UserID = '{UserID}' and passID = '{passID}' ", null,
commandType: CommandType.Text));
return(article);
}
public Task <BookGenres> GetById(int id)
{
var article = Task.FromResult(_dapperManager.Get <BookGenres>($"select * from [BookGenres] where BookGenreId = {id}", null,
commandType: CommandType.Text));
return(article);
}
public Task <int> Create(Customer customer)
{
var productId = Task.FromResult(_dapperManager.Get <int>($"INSERT INTO [Customer](CustomerName,CustomerPhone,CustomerEmail,CustomerCompany,DELETED,UpdatedDateTime,UpdatedBy) OUTPUT Inserted.ID VALUES('{customer.CustomerName}','{customer.CustomerPhone}','{customer.CustomerEmail}','{customer.CustomerCompany}','{false}',CONVERT(datetime,'{customer.UpdatedDateTime}',103),'{customer.UpdatedBy}')", null,
commandType: CommandType.Text));
return(productId);
}
public Task <Authors> GetById(int id)
{
var article = Task.FromResult(_dapperManager.Get <Authors>($"select * from [Authors] where AuthorId = {id}", null,
commandType: CommandType.Text));
return(article);
}
public Task <int> Create(Stock stock)
{
var productId = Task.FromResult(_dapperManager.Get <int>($"INSERT INTO [Stock](ProductID,StockCost,StockQty,DELETED,UpdatedDateTime,UpdatedBy) OUTPUT Inserted.ID VALUES('{stock.ProductID}','{stock.StockCost}','{stock.StockQty}','{false}',CONVERT(datetime,'{stock.UpdatedDateTime}',103),'{stock.UpdatedBy}')", null,
commandType: CommandType.Text));
return(productId);
}
public Task <c_order> GetById(int id)
{
var article = Task.FromResult(_dapperManager.Get <c_order>($"select * from c_order where ID = {id}", null,
commandType: CommandType.Text));
return(article);
}
public Task <int> Create(SaleTxn saleTxn)
{
var dbPara = new DynamicParameters();
var articleId = Task.FromResult(_dapperManager.Get <int>(
$"INSERT INTO [SaleTxn](SaleTxnStatus, SaleTxnQty, SaleTxnSubTotal, SaleReceivedQty, SaleTxnProductID, SaleTxnOrderID ,DELETED, UpdatedDateTime, UpdatedBy) OUTPUT Inserted.ID VALUES('{saleTxn.SaleTxnStatus}','{saleTxn.SaleTxnQty}','{saleTxn.SaleSubTotal}', '{saleTxn.SaleReceivedQty}','{saleTxn.SaleProduct.ID}','{saleTxn.SaleTxnOrderID}' ,'{false}', CONVERT(datetime,'{saleTxn.UpdatedDateTime}',103), '{saleTxn.UpdatedBy}')",
null,
commandType: CommandType.Text));
return(articleId);
}
public Task <int> Create(Article article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Title", article.Title, DbType.String);
var articleId = Task.FromResult(_dapperManager.Get <int>($"INSERT INTO Article(Title) OUTPUT Inserted.ID VALUES('{article.Title}')", null,
commandType: CommandType.Text));
return(articleId);
}
public Task <int> GetVtype(string vtype)
{
var dbPara = new DynamicParameters();
dbPara.Add("@Vtype", vtype, DbType.String);
var Vouchertype = Task.FromResult(_dapperManager.Get <int>($"SELECT ID FROM VTypeTran WHERE VType=@Vtype", dbPara, commandType: CommandType.Text));
return(Vouchertype);
//($"SELECT * FROM [Article] WHERE Title like '%{search}%' ORDER BY {orderBy} {direction} OFFSET {skip} ROWS FETCH NEXT {take} ROWS ONLY; ", null, commandType: CommandType.Text));
// return (int)idbopn.GetScalar("SELECT ID FROM VTypeTran WHERE VType='Sales POS'");
}
public Task <Clients> GetById(int id)
{
return(Task.Run(() =>
{
var article = _dapperManager.Get <Clients>($"select * from [Clients] where ClientId = {id}", null,
commandType: CommandType.Text);
article.BookList = _dapperManager.GetAll <Books>($"select b.* From Books as b Inner join ClientBook as c on c.BookId = b.BookId where c.ClientId = {id}", null,
commandType: CommandType.Text);
return article;
}));
}
public Task <int> Create(Product product)
{
var dictionary = new Dictionary <string, object>
{
{ "@UpdatedDateTime", 1 }
};
var parameters = new DynamicParameters(dictionary);
var productId = Task.FromResult(_dapperManager.Get <int>($"INSERT INTO [Product](ProductName,ProductDetails,ProductOrigin,ProductPrice,DELETED,UpdatedDateTime,UpdatedBy) OUTPUT Inserted.ID VALUES('{product.ProductName}','{product.ProductDetails}','{product.ProductOrigin}','{product.ProductPrice}','{false}',@UpdatedDateTime,'{product.UpdatedBy}')", parameters,
commandType: CommandType.Text));
return(productId);
}
//public Task<int> GetLoginToken(User user)
//{
// throw new System.NotImplementedException();
//}
public bool Verify(User user)
{
var dbPara = new DynamicParameters();
//TODO: encrypt password
dbPara.Add("@UserName", user.UserName, DbType.String);
dbPara.Add("@PasswordHash", user.PasswordHash, DbType.String);
var verified = Task.FromResult(_dapperManager.Get <int>
($"SELECT ID FROM [AuthUsers] WHERE UserName = @UserName and PasswordHash = @PasswordHash;", dbPara, commandType: CommandType.Text));
return(verified != null?true:false);
}
//Metodo que obtiene el ID de un cliente determinado
public Task <Clientes> GetById(int id, string Id_institucion)
{
var clientes = Task.FromResult(_dapperManager.Get <Clientes>($"select * from [Clientes] where ID = {id} AND ID_Institucion = '{Id_institucion}'", null,
commandType: CommandType.Text));
return(clientes);
}
public Task <Store> GetById(int Id)
{
var store = Task.FromResult(_dapperManager.Get <Store>($"select * from [Store] where ID = {Id}", null,
commandType: CommandType.Text));
return(store);
}
public Task <Vehiculos> GetById(int id, string Id_institucion)
{
var vehiculos = Task.FromResult(_dapperManager.Get <Vehiculos>($"select * from [Vehiculos] where ID = {id} AND ID_Institucion = '{Id_institucion}'", null,
commandType: CommandType.Text));
return(vehiculos);
}
public Task <int> Count(string search)
{
var totSchool = Task.FromResult(_dapperManager.Get <int>($"select COUNT(*) from [Schools] WHERE SchoolName like '%{search}%'", null,
commandType: CommandType.Text));
return(totSchool);
}
public Task <int> ValidadFecha(string fechaI, string FechaF, string idI, string VID)
{
var article = Task.FromResult(_dapperManager.Get <int>($"SELECT COUNT (*) FROM Reserva WHERE Fecha_inc BETWEEN '{fechaI}' AND '{FechaF}' AND ID_Institucion = '{idI}' AND ID_Vehiculo = '{VID}' OR Fecha_Fin BETWEEN '{fechaI}' AND '{FechaF}' AND ID_Vehiculo = '{VID}' AND ID_Institucion = '{idI}' ", null,
commandType: CommandType.Text));
return(article);
}
public Task <int> Count()
{
var dbPara = new DynamicParameters();
dbPara.Add("VType", 5, DbType.Int32);
dbPara.Add("BranchId", 31, DbType.Int32);
var totArticle = Task.FromResult(_dapperManager.Get <int>($"select COUNT(*) from [voucher] WHERE Vtype=@VType and branchid=@BranchId", dbPara,
commandType: CommandType.Text));
return(totArticle);
}
public async override Task <IResponseMessage <GeneralSettingsVM> > GetById(int?id)
{
var dbParams = new DynamicParameters();
dbParams.Add("@Id", id, DbType.Int32);
string sql = $"select * from [dbo].[GeneralSettings] WHERE Id = @Id";
var Branch = await Task.FromResult(dapperManager.Get <GeneralSettingsVM>(sql, dbParams, CommandType.Text));
return(new ResponseMessageBase <GeneralSettingsVM>()
{
MessageType = MessageTypes.Success, ResponseData = new[] { Branch }
});
}
//public async Task<dtVoucher> GetVoucher(int vid)
public async Task <dtInvVoucher> GetVoucher(long VId)
{
var dbPara = new DynamicParameters();
dbPara.Add("VId", VId, DbType.Int32);
dbPara.Add("Criteria", "Voucher", DbType.String);
//dtInvVoucher voucher = new dtInvVoucher();
var voucher = Task.FromResult(_dapperManager.Get <dtInvVoucher>
("[FINWEB_INVENTORYVoucherSP]", dbPara,
commandType: CommandType.StoredProcedure));
//($"SELECT * FROM [Article] WHERE Title like '%{search}%' ORDER BY {orderBy} {direction} OFFSET {skip} ROWS FETCH NEXT {take} ROWS ONLY; ", null, commandType: CommandType.Text));
return(await voucher);
}