/// <summary> /// InsertproductImage - them thông tin productImage /// </summary> /// <param name="productImage"></param> /// <returns></returns> public bool InsertProductImages(ProductImage productImage) { SqlParameter[] paramList = new SqlParameter[4]; paramList[0] = new SqlParameter("@ProductId", SqlDbType.Int); paramList[0].Value = productImage.ProductId; paramList[1] = new SqlParameter("@ImageName", SqlDbType.NVarChar, 256); paramList[1].Value = productImage.ImageName; paramList[2] = new SqlParameter("@ImageUrl", SqlDbType.NVarChar, 256); paramList[2].Value = productImage.ImageUrl; paramList[3] = new SqlParameter("@ImageIndex", SqlDbType.Int); paramList[3].Value = productImage.ImageIndex; if (db.executeUpdate("InsertProductImages", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// Insertcontact - them thông tin contact /// </summary> /// <param name="contact"></param> /// <returns></returns> public bool InsertTblContact(TblContact contact) { SqlParameter[] paramList = new SqlParameter[6]; paramList[0] = new SqlParameter("@Creator", SqlDbType.NVarChar, 256); paramList[0].Value = contact.Creator; paramList[1] = new SqlParameter("@Email", SqlDbType.NVarChar, 256); paramList[1].Value = contact.Email; paramList[2] = new SqlParameter("@Phone", SqlDbType.NVarChar, 256); paramList[2].Value = contact.Phone; paramList[3] = new SqlParameter("@Company", SqlDbType.NVarChar, 256); paramList[3].Value = contact.Company; paramList[4] = new SqlParameter("@ContactContent", SqlDbType.NVarChar); paramList[4].Value = contact.ContactContent; paramList[5] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[5].Value = contact.StatusId; if (db.executeUpdate("InsertTblContact", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertSubsubCategory - them thông tin subCategory /// </summary> /// <param name="subCategory"></param> /// <returns></returns> public bool InsertSubsubCategory(SubCategory subCategory) { SqlParameter[] paramList = new SqlParameter[6]; paramList[0] = new SqlParameter("@CategoryId", SqlDbType.Int); paramList[0].Value = subCategory.SubCategoryId; paramList[1] = new SqlParameter("@SubCategoryName", SqlDbType.NVarChar, 256); paramList[1].Value = subCategory.Description; paramList[2] = new SqlParameter("@SubCategoryImage", SqlDbType.NVarChar, 256); paramList[2].Value = subCategory.Description; paramList[3] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[3].Value = subCategory.StatusId; paramList[4] = new SqlParameter("@Description", SqlDbType.NVarChar, 2048); paramList[4].Value = subCategory.Description; paramList[5] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[5].Value = subCategory.StatusId; if (db.executeUpdate("InsertSubCategory", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertAdvertise - them thông tin advertise /// </summary> /// <param name="advertise"></param> /// <returns></returns> public bool InsertAdvertise(Advertise advertise) { SqlParameter[] paramList = new SqlParameter[5]; paramList[0] = new SqlParameter("@AdvertiseName", SqlDbType.NVarChar, 256); paramList[0].Value = advertise.AdvertiseName; paramList[1] = new SqlParameter("@AdvertiseLink", SqlDbType.NVarChar, 256); paramList[1].Value = advertise.AdvertiseLink; paramList[2] = new SqlParameter("@ImageURL", SqlDbType.NVarChar, 256); paramList[2].Value = advertise.ImageURL; paramList[3] = new SqlParameter("@AdvertisePostion", SqlDbType.Int); paramList[3].Value = advertise.AdvertisePostion; paramList[4] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[4].Value = advertise.StatusId; if (db.executeUpdate("InsertAdvertise", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertSupplier - them thông tin Supplier /// </summary> /// <param name="Supplier"></param> /// <returns></returns> public bool InsertSupplier(Supplier Supplier) { SqlParameter[] paramList = new SqlParameter[4]; paramList[0] = new SqlParameter("@SupplierName", SqlDbType.NVarChar, 256); paramList[0].Value = Supplier.SupplierName; paramList[1] = new SqlParameter("@SupplierLink", SqlDbType.NVarChar, 256); paramList[1].Value = Supplier.SupplierLink; paramList[2] = new SqlParameter("@SupplierImage", SqlDbType.NVarChar, 256); paramList[2].Value = Supplier.SupplierImage; paramList[3] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[3].Value = Supplier.StatusId; if (db.executeUpdate("InsertSupplier", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertPartner - them thông tin partner /// </summary> /// <param name="partner"></param> /// <returns></returns> public bool InsertPartner(Partner partner) { SqlParameter[] paramList = new SqlParameter[7]; paramList[0] = new SqlParameter("@PartnerName", SqlDbType.NVarChar, 256); paramList[0].Value = partner.PartnerName; paramList[1] = new SqlParameter("@Address", SqlDbType.NVarChar, 256); paramList[1].Value = partner.Address; paramList[2] = new SqlParameter("@City", SqlDbType.NVarChar, 256); paramList[2].Value = partner.City; paramList[3] = new SqlParameter("@Phone", SqlDbType.NVarChar, 50); paramList[3].Value = partner.Phone; paramList[4] = new SqlParameter("@Link", SqlDbType.NVarChar, 256); paramList[4].Value = partner.Link; paramList[5] = new SqlParameter("@Email", SqlDbType.NVarChar, 256); paramList[5].Value = partner.Email; paramList[6] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[6].Value = partner.StatusId; if (db.executeUpdate("InsertPartner", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertquoteProduct - them thông tin quoteProduct /// </summary> /// <param name="quoteProduct"></param> /// <returns></returns> public bool InsertQuoteProduct(QuoteProduct quoteProduct) { SqlParameter[] paramList = new SqlParameter[4]; paramList[0] = new SqlParameter("@QuoteProductName", SqlDbType.NVarChar, 256); paramList[0].Value = quoteProduct.QuoteProductName; paramList[1] = new SqlParameter("@QuoteLink", SqlDbType.NVarChar, 256); paramList[1].Value = quoteProduct.QuoteLink; paramList[2] = new SqlParameter("@Description", SqlDbType.NVarChar, 512); paramList[2].Value = quoteProduct.Description; paramList[3] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[3].Value = quoteProduct.StatusId; if (db.executeUpdate("InsertQuoteProduct", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InserttblInterface - them thông tin tblInterface /// </summary> /// <param name="tblInterface"></param> /// <returns></returns> public bool InsertTblInterface(TblInterface tblInterface) { SqlParameter[] paramList = new SqlParameter[5]; paramList[0] = new SqlParameter("@TypeId", SqlDbType.NVarChar, 256); paramList[0].Value = tblInterface.TypeId; paramList[1] = new SqlParameter("@InterfaceLink", SqlDbType.NVarChar, 256); paramList[1].Value = tblInterface.InterfaceLink; paramList[2] = new SqlParameter("@ImageURL", SqlDbType.NVarChar, 256); paramList[2].Value = tblInterface.ImageURL; paramList[3] = new SqlParameter("@InterfaceContent", SqlDbType.NVarChar, 512); paramList[3].Value = tblInterface.InterfaceContent; paramList[4] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[4].Value = tblInterface.StatusId; if (db.executeUpdate("InsertTblInterface", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InserttblService - them thông tin tblService /// </summary> /// <param name="tblService"></param> /// <returns></returns> public bool InsertTblService(TblService tblService) { SqlParameter[] paramList = new SqlParameter[4]; paramList[0] = new SqlParameter("@ServiceName", SqlDbType.NVarChar, 256); paramList[0].Value = tblService.ServiceName; paramList[1] = new SqlParameter("@ServiceLink", SqlDbType.NVarChar, 256); paramList[1].Value = tblService.ServiceLink; paramList[2] = new SqlParameter("@Description", SqlDbType.NVarChar, 512); paramList[2].Value = tblService.Description; paramList[3] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[3].Value = tblService.StatusId; if (db.executeUpdate("InsertTblService", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// Insertcomment - them thông tin comment /// </summary> /// <param name="comment"></param> /// <returns></returns> public bool InsertComment(Comment comment) { SqlParameter[] paramList = new SqlParameter[6]; paramList[0] = new SqlParameter("@ProductId", SqlDbType.Int); paramList[0].Value = comment.ProductId; paramList[1] = new SqlParameter("@CommentName", SqlDbType.NVarChar, 512); paramList[1].Value = comment.CommentName; paramList[2] = new SqlParameter("@Email", SqlDbType.NVarChar, 256); paramList[2].Value = comment.Email; paramList[3] = new SqlParameter("@CommentContent", SqlDbType.NVarChar, 256); paramList[3].Value = comment.CommentContent; paramList[4] = new SqlParameter("@Rate", SqlDbType.Float); paramList[4].Value = comment.Rate; paramList[5] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[5].Value = comment.StatusId; if (db.executeUpdate("InsertComment", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertfAQs - them thông tin fAQs /// </summary> /// <param name="fAQs"></param> /// <returns></returns> public bool InsertFAQs(FAQs fAQs) { SqlParameter[] paramList = new SqlParameter[4]; paramList[0] = new SqlParameter("@Question", SqlDbType.NVarChar, 512); paramList[0].Value = fAQs.Question; paramList[1] = new SqlParameter("@Answer", SqlDbType.NVarChar, 512); paramList[1].Value = fAQs.Answer; paramList[2] = new SqlParameter("@FaqIndex", SqlDbType.Int); paramList[2].Value = fAQs.FaqIndex; paramList[3] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[3].Value = fAQs.StatusId; if (db.executeUpdate("InsertFAQs", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertInterfaceType - them thông tin interfaceType /// </summary> /// <param name="interfaceType"></param> /// <returns></returns> public bool InsertInterfaceType(InterfaceType interfaceType) { SqlParameter[] paramList = new SqlParameter[2]; paramList[0] = new SqlParameter("@TypeId", SqlDbType.NVarChar, 256); paramList[0].Value = interfaceType.TypeId; paramList[1] = new SqlParameter("@TypeName", SqlDbType.NVarChar, 256); paramList[1].Value = interfaceType.TypeName; if (db.executeUpdate("InsertInterfaceType", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertBill - them thông tin bill /// </summary> /// <param name="bill"></param> /// <returns></returns> public bool InsertBill(Bill bill) { SqlParameter[] paramList = new SqlParameter[9]; paramList[0] = new SqlParameter("@UserId", SqlDbType.Int); paramList[0].Value = bill.UserId; paramList[1] = new SqlParameter("@ReceiverName", SqlDbType.NVarChar, 256); paramList[1].Value = bill.ReceiverName; paramList[2] = new SqlParameter("@DeliveryTime", SqlDbType.DateTime); paramList[2].Value = bill.DeliveryTime; paramList[3] = new SqlParameter("@DeliveryAddress", SqlDbType.NVarChar, 512); paramList[3].Value = bill.DeliveryAddress; paramList[4] = new SqlParameter("@ReceiverEmail", SqlDbType.NVarChar, 256); paramList[4].Value = bill.ReceiverEmail; paramList[5] = new SqlParameter("@ReceiverTel", SqlDbType.NVarChar, 50); paramList[5].Value = bill.ReceiverTel; paramList[6] = new SqlParameter("@ReceiverFax", SqlDbType.NVarChar, 256); paramList[6].Value = bill.ReceiverFax; paramList[7] = new SqlParameter("@Note", SqlDbType.NVarChar, 512); paramList[7].Value = bill.DeliveryAddress; paramList[8] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[8].Value = bill.StatusId; if (db.executeUpdate("InsertBill", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertLog - them thông tin log /// </summary> /// <param name="emp"></param> /// <returns></returns> public bool InsertLog(LogSystem logSystem) { SqlParameter[] paramList = new SqlParameter[3]; paramList[0] = new SqlParameter("@LogName", SqlDbType.NVarChar, 256); paramList[0].Value = logSystem.LogName; paramList[1] = new SqlParameter("@LogForTable", SqlDbType.VarChar, 256); paramList[1].Value = logSystem.LogForTable; paramList[2] = new SqlParameter("@LogContent", SqlDbType.NVarChar, 2048); paramList[2].Value = logSystem.LogContent; if (db.executeUpdate("InsertLog", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertUser - thêm user /// </summary> /// <param name="tblUser"></param> /// <returns></returns> public int InsertUser(TblUser tblUser) { SqlParameter[] paramList = new SqlParameter[11]; paramList[0] = new SqlParameter("@GroupId", SqlDbType.NVarChar, 256); paramList[0].Value = tblUser.GroupId; paramList[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 256); paramList[1].Value = tblUser.UserName; paramList[2] = new SqlParameter("@Password", SqlDbType.NVarChar, 256); paramList[2].Value = tblUser.FullName; paramList[3] = new SqlParameter("@FullName", SqlDbType.NVarChar, 256); paramList[3].Value = tblUser.Password; paramList[4] = new SqlParameter("@DateOfBirth", SqlDbType.DateTime); paramList[4].Value = tblUser.DateOfBirth; paramList[5] = new SqlParameter("@Gender", SqlDbType.Bit); paramList[5].Value = tblUser.Gender; paramList[6] = new SqlParameter("@Email", SqlDbType.NVarChar, 256); paramList[6].Value = tblUser.Email; paramList[7] = new SqlParameter("@Address", SqlDbType.NVarChar, 256); paramList[7].Value = tblUser.Address; paramList[8] = new SqlParameter("@Phone", SqlDbType.VarChar, 50); paramList[8].Value = tblUser.Phone; paramList[9] = new SqlParameter("@RegisterCode", SqlDbType.NVarChar, 256); paramList[9].Value = tblUser.RegisterCode; paramList[10] = new SqlParameter("@StatusId", SqlDbType.Int); paramList[10].Value = tblUser.StatusId; return(db.executeUpdate("InsertUser", paramList)); }
/// <summary> /// InsertbillDetail - them thông tin billDetail /// </summary> /// <param name="billDetail"></param> /// <returns></returns> public bool InsertBillDetail(BillDetail billDetail) { SqlParameter[] paramList = new SqlParameter[3]; paramList[0] = new SqlParameter("@BillId", SqlDbType.Int); paramList[0].Value = billDetail.BillId; paramList[1] = new SqlParameter("@ProductId", SqlDbType.Int); paramList[1].Value = billDetail.ProductId; paramList[2] = new SqlParameter("@Quantity", SqlDbType.Int); paramList[2].Value = billDetail.Quantity; if (db.executeUpdate("InsertBillDetail", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// Insertpolicy - them thông tin policy /// </summary> /// <param name="policy"></param> /// <returns></returns> public bool InsertPolicy(Policy policy) { SqlParameter[] paramList = new SqlParameter[3]; paramList[0] = new SqlParameter("@PolicyType", SqlDbType.NVarChar, 256); paramList[0].Value = policy.PolicyType; paramList[1] = new SqlParameter("@PolicyContent", SqlDbType.NVarChar); paramList[1].Value = policy.PolicyContent; paramList[2] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[2].Value = policy.StatusId; if (db.executeUpdate("InsertPolicy", paramList) == 0) { return(false); } else { return(true); } }
/// <summary> /// InsertProduct - them thông tin product /// </summary> /// <param name="product"></param> /// <returns></returns> public bool InsertProduct(Product product) { SqlParameter[] paramList = new SqlParameter[16]; paramList[0] = new SqlParameter("@ProductName", SqlDbType.NVarChar, 256); paramList[0].Value = product.ProductName; paramList[1] = new SqlParameter("@SubCategoryId", SqlDbType.Int); paramList[1].Value = product.SubCategoryId; paramList[2] = new SqlParameter("@ViewQuantity", SqlDbType.Int); paramList[2].Value = product.ViewQuantity; paramList[3] = new SqlParameter("@Thumbnails", SqlDbType.NVarChar, 256); paramList[3].Value = product.Thumbnails; paramList[4] = new SqlParameter("@Price", SqlDbType.Float); paramList[4].Value = product.Price; paramList[5] = new SqlParameter("@Promotion", SqlDbType.Float); paramList[5].Value = product.Promotion; paramList[6] = new SqlParameter("@Quantity", SqlDbType.Int); paramList[6].Value = product.Quantity; paramList[7] = new SqlParameter("@Quality", SqlDbType.NVarChar, 256); paramList[7].Value = product.Quality; paramList[8] = new SqlParameter("@MadeBy", SqlDbType.NVarChar, 256); paramList[8].Value = product.MadeBy; paramList[9] = new SqlParameter("@VatTax", SqlDbType.Float); paramList[9].Value = product.VatTax; paramList[10] = new SqlParameter("@Warranty", SqlDbType.Float); paramList[10].Value = product.Warranty; paramList[11] = new SqlParameter("@TransportCost", SqlDbType.Float); paramList[11].Value = product.TransportCost; paramList[12] = new SqlParameter("@ViewOption", SqlDbType.NVarChar, 256); paramList[12].Value = product.ViewOption; paramList[13] = new SqlParameter("@SubDescription", SqlDbType.NVarChar, 256); paramList[13].Value = product.SubDescription; paramList[14] = new SqlParameter("@Description", SqlDbType.NVarChar, 2048); paramList[14].Value = product.Description; paramList[15] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[15].Value = product.StatusId; if (db.executeUpdate("InsertProduct", paramList) == 0) { return(false); } else { return(true); } }