/// <summary>
///
/// </summary>
/// <param name="client"></param>
public void UpdateById(Client client)
{
const string sqlStatement = "UPDATE dbo.Client " +
"SET [FirstName]=@FirstName, " +
"[LastName]=@LastName, " +
"[Email]=@Email, " +
"[CountryId]=@CountryId, " +
"[AspNetUsers]=@AspNetUsers, " +
"[City]=@City, " +
"[OrderCount]=@OrderCount, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@FirstName", client.FirstName));
cmd.Parameters.Add(Db.CreateParameter("@LastName", client.LastName));
cmd.Parameters.Add(Db.CreateParameter("@Email", client.Email));
cmd.Parameters.Add(Db.CreateParameter("@CountryId", client.CountryId));
cmd.Parameters.Add(Db.CreateParameter("@AspNetUsers", client.AspNetUsers));
cmd.Parameters.Add(Db.CreateParameter("@City", client.City));
cmd.Parameters.Add(Db.CreateParameter("@OrderCount", client.OrderCount));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", DateTime.Now));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", client.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", client.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public User Create(User User)
{
const string sqlStatement = "INSERT INTO AspNetUsers (Email, EmailConfirmed, PasswordHash, SecurityStamp, " +
"PhoneNumber, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEndDateUtc, LockoutEnabled, AccessFailedCount, " +
"UserName) VALUES(@Email, @EmailConfirmed, @PasswordHash, @SecurityStamp, @PhoneNumber, @PhoneNumberConfirmed, " +
"@TwoFactorEnabled, @LockoutEndDateUtc, @LockoutEnabled, @AccessFailedCount, @UserName); SELECT LAST_INSERT_ID();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Email", User.Email));
cmd.Parameters.Add(Db.CreateParameter("@EmailConfirmed", User.EmailConfirmed));
cmd.Parameters.Add(Db.CreateParameter("@PasswordHash", User.PasswordHash));
cmd.Parameters.Add(Db.CreateParameter("@SecurityStamp", User.SecurityStamp));
cmd.Parameters.Add(Db.CreateParameter("@PhoneNumber", User.PhoneNumber));
cmd.Parameters.Add(Db.CreateParameter("@PhoneNumberConfirmed", User.PhoneNumberConfirmed));
cmd.Parameters.Add(Db.CreateParameter("@TwoFactorEnabled", User.TwoFactorEnabled));
cmd.Parameters.Add(Db.CreateParameter("@LockoutEndDateUtc", User.LockoutEndDateUtc));
cmd.Parameters.Add(Db.CreateParameter("@LockoutEnabled", User.LockoutEnabled));
cmd.Parameters.Add(Db.CreateParameter("@AccessFailedCount", User.AccessFailedCount));
cmd.Parameters.Add(Db.CreateParameter("@UserName", User.UserName));
// Obtener el valor de la primary key.
User.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(User);
}
/// <summary>
///
/// </summary>
/// <param name="product"></param>
public void UpdateById(Product product)
{
const string sqlStatement = "UPDATE Product " +
"SET Title=@Title, " +
"Description=@Description, " +
"DealerId=@DealerId, " +
"Image=@Image, " +
"Price=@Price, " +
"QuantitySold=@QuantitySold, " +
"ChangedOn=@ChangedOn, " +
"ChangedBy=@ChangedBy " +
"WHERE Id=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Title", product.Title));
cmd.Parameters.Add(Db.CreateParameter("@Description", product.Description));
cmd.Parameters.Add(Db.CreateParameter("@DealerId", product.DealerId));
cmd.Parameters.Add(Db.CreateParameter("@Image", product.Image));
cmd.Parameters.Add(Db.CreateParameter("@Price", product.Price));
cmd.Parameters.Add(Db.CreateParameter("@QuantitySold", product.QuantitySold));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", product.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", product.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", product.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="orderDetail"></param>
public void UpdateById(OrderDetail orderD)
{
const string sqlStatement = "UPDATE dbo.OrderDetail " +
"SET [OrderId]=@OrderId, " +
"[ProductId]=@ProductId, " +
"[Price]=@Price, " +
"[Quantity]=@Quantity, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@OrderId", orderD.OrderId));
cmd.Parameters.Add(Db.CreateParameter("@ProductId", orderD.ProductId));
cmd.Parameters.Add(Db.CreateParameter("@Price", orderD.Price));
cmd.Parameters.Add(Db.CreateParameter("@Quantity", orderD.Quantity));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", orderD.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", orderD.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", orderD.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="order"></param>
public void UpdateById(Order order)
{
const string sqlStatement = "UPDATE dbo.Order " +
"SET [ClientId]=@ClientId, " +
"[TotalPrice]=@TotalPrice, " +
"[State]=@State, " +
"[OrderNumber]=@OrderNumber, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@ClientId", order.ClientId));
cmd.Parameters.Add(Db.CreateParameter("@TotalPrice", order.TotalPrice));
cmd.Parameters.Add(Db.CreateParameter("@State", order.State));
cmd.Parameters.Add(Db.CreateParameter("@OrderNumber", order.OrderNumber));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", order.CreatedBy));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", order.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", order.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", order.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public Setting Create(Setting setting)
{
const string sqlStatement = "INSERT INTO dbo.Setting ([Name], [Value], [Description], [WebSiteName], [WebSiteUrl], [PageTitle], [AdminEmailAddress], [SMTP], [SMTPUsername], [SMTPPassword], [SMTPPort], [SMTPEnableSSL], [Theme], [DefaultLanguageId], [CreatedBy]) " +
"VALUES(@Name, @Value, @Description, @WebSiteName, @WebSiteUrl, @PageTitle, @AdminEmailAddress, @SMTP, @SMTPUsername, @SMTPPassword, @SMTPPort, @SMTPEnableSSL, @Theme, @DefaultLanguageId, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", setting.Name));
cmd.Parameters.Add(Db.CreateParameter("@Value", setting.Value));
cmd.Parameters.Add(Db.CreateParameter("@Description", setting.Description));
cmd.Parameters.Add(Db.CreateParameter("@WebSiteName", setting.WebSiteName));
cmd.Parameters.Add(Db.CreateParameter("@WebSiteUrl", setting.WebSiteUrl));
cmd.Parameters.Add(Db.CreateParameter("@PageTitle", setting.PageTitle));
cmd.Parameters.Add(Db.CreateParameter("@AdminEmailAddress", setting.AdminEmailAddress));
cmd.Parameters.Add(Db.CreateParameter("@SMTP", setting.SMTP));
cmd.Parameters.Add(Db.CreateParameter("@SMTPUsername", setting.SMTPUsername));
cmd.Parameters.Add(Db.CreateParameter("@SMTPPassword", setting.SMTPPassword));
cmd.Parameters.Add(Db.CreateParameter("@SMTPPort", setting.SMTPPort));
cmd.Parameters.Add(Db.CreateParameter("@SMTPEnableSSL", setting.SMTPEnableSSL));
cmd.Parameters.Add(Db.CreateParameter("@Theme", setting.Theme));
cmd.Parameters.Add(Db.CreateParameter("@DefaultLanguageId", setting.DefaultLanguageId));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", setting.CreatedBy));
// Obtener el valor de la primary key.
setting.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(setting);
}
/// <summary>
///
/// </summary>
/// <param name="dealer"></param>
public void UpdateById(Dealer dealer)
{
const string sqlStatement = "UPDATE dbo.Dealer " +
"SET [FirstName]=@FirstName, " +
"[LastName]=@LastName, " +
"[CategoryId]=@CategoryId, " +
"[CountryId]=@CountryId, " +
"[Description]=@Description, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@FirstName", dealer.FirstName));
cmd.Parameters.Add(Db.CreateParameter("@LastName", dealer.LastName));
cmd.Parameters.Add(Db.CreateParameter("@CategoryId", dealer.CategoryId));
cmd.Parameters.Add(Db.CreateParameter("@CountryId", dealer.CountryId));
cmd.Parameters.Add(Db.CreateParameter("@Description", dealer.Description));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", dealer.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", dealer.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", dealer.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
public void DeleteById(int id)
{
const string sqlStatement = "DELETE dbo.Setting WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Id", id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="Role"></param>
/// <returns></returns>
public Role Create(Role Role)
{
const string sqlStatement = "INSERT INTO AspNetRoles (Name) VALUES " +
"(@Name); SELECT LAST_INSERT_ID();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", Role.Name));
// Obtener el valor de la primary key.
Role.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(Role);
}
/// <summary>
///
/// </summary>
/// <param name="cart"></param>
/// <returns></returns>
public Cart Create(Cart cart)
{
const string sqlStatement = "INSERT INTO dbo.Cart ([Cookie], [CreatedBy]) " +
"VALUES(@Cookie, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Cookie", cart.Cookie));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", cart.CreatedBy));
cart.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(cart);
}
/// <summary>
///
/// </summary>
/// <param name="orderNumber"></param>
/// <returns></returns>
public OrderNumber Create(OrderNumber orderN)
{
const string sqlStatement = "INSERT INTO dbo.OrderNumber([Number], [CreatedBy]) " +
"VALUES(@Number, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Number", orderN.Number));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", orderN.CreatedBy));
// Obtener el valor de la primary key.
orderN.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(orderN);
}
/// <summary>
///
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public Category Create(Category category)
{
string sqlStatement = "INSERT INTO Category (Name, CreatedOn, CreatedBy) " +
"VALUES(@Name, @CreatedOn, @CreatedBy); " + Db.LastIdFunction();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", category.Name));
cmd.Parameters.Add(Db.CreateParameter("@CreatedOn", DateTime.Now));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", category.CreatedBy));
category.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(category);
}
/// <summary>
///
/// </summary>
/// <param name="product"></param>
public void UpdateById(Setting setting)
{
const string sqlStatement = "UPDATE dbo.Setting " +
"SET [Name]=@Name, " +
"[Value]=@Value, " +
"[Description]=@Description, " +
"[WebSiteName]=@WebSiteName, " +
"[WebSiteUrl]=@WebSiteUrl, " +
"[PageTitle]=@PageTitle, " +
"[AdminEmailAddress]=@AdminEmailAddress, " +
"[SMTP]=@SMTP, " +
"[SMTPUsername]=@SMTPUsername, " +
"[SMTPPassword]=@SMTPPassword, " +
"[SMTPPort]=@SMTPPort, " +
"[SMTPEnableSSL]=@SMTPEnableSSL, " +
"[Theme]=@Theme, " +
"[DefaultLanguageId]=@DefaultLanguageId, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", setting.Name));
cmd.Parameters.Add(Db.CreateParameter("@Value", setting.Value));
cmd.Parameters.Add(Db.CreateParameter("@Description", setting.Description));
cmd.Parameters.Add(Db.CreateParameter("@WebSiteName", setting.WebSiteName));
cmd.Parameters.Add(Db.CreateParameter("@WebSiteUrl", setting.WebSiteUrl));
cmd.Parameters.Add(Db.CreateParameter("@PageTitle", setting.PageTitle));
cmd.Parameters.Add(Db.CreateParameter("@AdminEmailAddress", setting.AdminEmailAddress));
cmd.Parameters.Add(Db.CreateParameter("@SMTP", setting.SMTP));
cmd.Parameters.Add(Db.CreateParameter("@SMTPUsername", setting.SMTPUsername));
cmd.Parameters.Add(Db.CreateParameter("@SMTPPassword", setting.SMTPPassword));
cmd.Parameters.Add(Db.CreateParameter("@SMTPPort", setting.SMTPPort));
cmd.Parameters.Add(Db.CreateParameter("@SMTPEnableSSL", setting.SMTPEnableSSL));
cmd.Parameters.Add(Db.CreateParameter("@Theme", setting.Theme));
cmd.Parameters.Add(Db.CreateParameter("@DefaultLanguageId", setting.DefaultLanguageId));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", setting.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", setting.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", setting.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="Country"></param>
/// <returns></returns>
public Country Create(Country Country)
{
const string sqlStatement = "INSERT INTO dbo.Country ([Name], [CreatedOn], [CreatedBy]) " +
"VALUES(@Name, @CreatedOn, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", Country.Name));
cmd.Parameters.Add(Db.CreateParameter("@CreatedOn", Country.CreatedOn));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", Country.CreatedBy));
// Obtener el valor de la primary key.
Country.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(Country);
}
/// <summary>
///
/// </summary>
/// <param name="cart"></param>
public void UpdateById(Cart cart)
{
const string sqlStatement = "UPDATE dbo.Cart " +
"SET [Cookie]=@Cookie, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Cookie", cart.Cookie));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", cart.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", cart.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", cart.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="orderNumber"></param>
public void UpdateById(OrderNumber orderN)
{
const string sqlStatement = "UPDATE dbo.OrderNumber " +
"SET [Number]=@Number, " +
"[ChangedOn]=@ChangedOn, " +
"[ChangedBy]=@ChangedBy " +
"WHERE [Id]=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Number", orderN.Number));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", orderN.ChangedOn));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", orderN.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", orderN.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="rating"></param>
/// <returns></returns>
public Rating Create(Rating rating)
{
const string sqlStatement = "INSERT INTO dbo.Rating ([ClientId], [ProductId], [Stars], [CreatedBy]) " +
"VALUES(@ClientId, @ProductId, @Stars, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@ClientId", rating.ClientId));
cmd.Parameters.Add(Db.CreateParameter("@ProductId", rating.ProductId));
cmd.Parameters.Add(Db.CreateParameter("@Stars", rating.Stars));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", rating.CreatedBy));
// Obtener el valor de la primary key.
rating.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(rating);
}
/// <summary>
///
/// </summary>
/// <param name="cartitem"></param>
/// <returns></returns>
public CartItem Create(CartItem cartitem)
{
const string sqlStatement = "INSERT INTO dbo.CartItem ([CartId], [ProductId], [Price] , [Quantity], [CreatedBy]) " +
"VALUES(@CartId, @ProductId, @Price, @Quantity, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@CartId", cartitem.CartId));
cmd.Parameters.Add(Db.CreateParameter("@ProductId", cartitem.ProductId));
cmd.Parameters.Add(Db.CreateParameter("@Price", cartitem.Price));
cmd.Parameters.Add(Db.CreateParameter("@Quantity", cartitem.Quantity));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", cartitem.CreatedBy));
// Obtener el valor de la primary key.
cartitem.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(cartitem);
}
/// <summary>
///
/// </summary>
/// <param name="orderDetail"></param>
/// <returns></returns>
public OrderDetail Create(OrderDetail orderD)
{
const string sqlStatement = "INSERT INTO dbo.OrderDetail([OrderId], [ProductId], [Price], [Quantity], [CreatedBy]) " +
"VALUES(@OrderId, @ProductId, @Price, @Quantity, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@OrderId", orderD.OrderId));
cmd.Parameters.Add(Db.CreateParameter("@ProductId", orderD.ProductId));
cmd.Parameters.Add(Db.CreateParameter("@Price", orderD.Price));
cmd.Parameters.Add(Db.CreateParameter("@Quantity", orderD.Quantity));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", orderD.CreatedBy));
// Obtener el valor de la primary key.
orderD.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(orderD);
}
/// <summary>
///
/// </summary>
/// <param name="category"></param>
public void UpdateById(Category category)
{
const string sqlStatement = "UPDATE Category " +
"SET Name=@Name, " +
"ChangedOn=@ChangedOn, " +
"ChangedBy=@ChangedBy " +
"WHERE Id=@Id ";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Name", category.Name));
cmd.Parameters.Add(Db.CreateParameter("@ChangedOn", DateTime.Now));
cmd.Parameters.Add(Db.CreateParameter("@ChangedBy", category.ChangedBy));
cmd.Parameters.Add(Db.CreateParameter("@Id", category.Id));
cmd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Role SelectById(int id)
{
const string sqlStatement = "SELECT * FROM AspNetRoles WHERE Id = @Id;";
Role Role = null;
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Id", id));
using (var dr = cmd.ExecuteReader())
{
if (dr.Read())
{
Role = LoadRole(dr);
}
}
}
return(Role);
}
/// <summary>
///
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public Order Create(Order order)
{
const string sqlStatement = "INSERT INTO dbo.Order ([ClientId], [OrderDate], [TotalPrice], [State], [OrderNumber], [CreatedBy]) " +
"VALUES(@ClientId, @OrderDate, @TotalPrice, @State, @OrderNumber, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@ClientId", order.ClientId));
cmd.Parameters.Add(Db.CreateParameter("@OrderDate", order.OrderDate));
cmd.Parameters.Add(Db.CreateParameter("@TotalPrice", order.TotalPrice));
cmd.Parameters.Add(Db.CreateParameter("@State", order.State));
cmd.Parameters.Add(Db.CreateParameter("@OrderNumber", order.OrderNumber));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", order.CreatedBy));
// Obtener el valor de la primary key.
order.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(order);
}
/// <summary>
///
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public Product Create(Product product)
{
string sqlStatement = "INSERT INTO Product (Title, Description, DealerId, Image, Price, CreatedBy) " +
"VALUES(@Title, @Description, @DealerId, @Image, @Price, @CreatedBy);" + Db.LastIdFunction();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Title", product.Title));
cmd.Parameters.Add(Db.CreateParameter("@Description", product.Description));
cmd.Parameters.Add(Db.CreateParameter("@DealerId", product.DealerId));
cmd.Parameters.Add(Db.CreateParameter("@Image", product.Image));
cmd.Parameters.Add(Db.CreateParameter("@Price", product.Price));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", product.CreatedBy));
// Obtener el valor de la primary key.
product.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(product);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Cart> Select()
{
const string sqlStatement = "SELECT [Id], [Cookie], [CartDate], [ItemCount], [Rowid], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] FROM dbo.Cart ";
var result = new List <Cart>();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var cart = LoadCart(dr); // Mapper
result.Add(cart);
}
}
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name = "dealer" ></ param >
/// < returns ></ returns >
public Dealer Create(Dealer dealer)
{
const string sqlStatement = "INSERT INTO dbo.Dealer ([FirstName], [LastName], [CategoryId], [CountryId], [Description], [CreatedBy]) " +
"VALUES(@FirstName, @LastName, @CategoryId, @CountryId, @Description, @CreatedBy); SELECT SCOPE_IDENTITY();";
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@FirstName", dealer.FirstName));
cmd.Parameters.Add(Db.CreateParameter("@LastName", dealer.LastName));
cmd.Parameters.Add(Db.CreateParameter("@CategoryId", dealer.CategoryId));
cmd.Parameters.Add(Db.CreateParameter("@CountryId", dealer.CountryId));
cmd.Parameters.Add(Db.CreateParameter("@Description", dealer.Description));
cmd.Parameters.Add(Db.CreateParameter("@CreatedBy", dealer.CreatedBy));
// Obtener el valor de la primary key.
dealer.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
return(dealer);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <CartItem> Select()
{
const string sqlStatement = "SELECT [Id], [CartId], [ProductId], [Price] , [Quantity], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] FROM dbo.CartItem ";
var result = new List <CartItem>();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var cartitem = LoadCartItem(dr); // Mapper
result.Add(cartitem);
}
}
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public OrderDetail SelectById(int id)
{
const string sqlStatement = "SELECT [Id], [OrderId], [ProductId], [Price], [Quantity], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] " +
"FROM dbo.OrderDetail WHERE [Id]=@Id ";
OrderDetail orderD = null;
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Id", id));
using (var dr = cmd.ExecuteReader())
{
if (dr.Read())
{
orderD = LoadOrderDetail(dr);
}
}
}
return(orderD);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Setting> Select()
{
// WARNING! Performance
const string sqlStatement = "SELECT [Id], [Name], [Value], [Description], [LastChangeDate], [WebSiteName], [WebSiteUrl], [PageTitle], [AdminEmailAddress], [SMTP], [SMTPUsername], [SMTPPassword], [SMTPPort], [SMTPEnableSSL], [Theme], [DefaultLanguageId], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] FROM dbo.Setting ";
var result = new List <Setting>();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var setting = LoadSetting(dr); // Mapper
result.Add(setting);
}
}
}
return(result);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Role> Select()
{
// WARNING! Performance
const string sqlStatement = "SELECT * FROM AspNetRoles";
var result = new List <Role>();
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var Role = LoadRole(dr); // Mapper
result.Add(Role);
}
}
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Setting SelectById(int id)
{
const string sqlStatement = "SELECT [Id], [Name], [Value], [Description], [LastChangeDate], [WebSiteName], [WebSiteUrl], [PageTitle], [AdminEmailAddress], [SMTP], [SMTPUsername], [SMTPPassword], [SMTPPort], [SMTPEnableSSL], [Theme], [DefaultLanguageId], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] " +
"FROM dbo.Setting WHERE [Id]=@Id ";
Setting setting = null;
var connection = Db.CreateOpenConnection();
using (var cmd = Db.CreateCommand(sqlStatement, connection))
{
cmd.Parameters.Add(Db.CreateParameter("@Id", id));
using (var dr = cmd.ExecuteReader())
{
if (dr.Read())
{
setting = LoadSetting(dr);
}
}
}
return(setting);
}
