/// <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);
}
}
