/// <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="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="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="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="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="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="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="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="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="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="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="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="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> /// <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> /// <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="id"></param> /// <returns></returns> public Category SelectById(int id) { const string sqlStatement = "SELECT Id, Name, CreatedOn, CreatedBy, ChangedOn, ChangedBy " + "FROM Category WHERE Id=@Id "; Category category = 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()) { category = LoadCategory(dr); } } } return(category); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public Rating SelectById(int id) { const string sqlStatement = "SELECT [Id], [ClientId], [ProductId], [Stars], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] " + "FROM dbo.Rating WHERE [Id]=@Id "; Rating rating = 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()) { rating = LoadRating(dr); } } } return(rating); }
/// <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); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public CartItem SelectById(int id) { const string sqlStatement = "SELECT [Id], [CartId], [ProductId], [Price], [Quantity], [CreatedOn], [CreatedBy], [ChangedOn], [ChangedBy] " + "FROM dbo.CartItem WHERE [Id]=@Id "; CartItem cartitem = 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()) { cartitem = LoadCartItem(dr); } } } return(cartitem); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public Product SelectById(int id) { const string sqlStatement = "SELECT Id, Title, Description, DealerId, Image, Price, QuantitySold, " + "AvgStars, Rowid, CreatedOn, CreatedBy, ChangedOn, ChangedBy FROM Product WHERE Id = @Id;"; Product product = 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()) { product = LoadProduct(dr); } } } return(product); }
/// <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); }