private void btnUpdate_Click(object sender, EventArgs e)
{
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Category currentCategory = BLCategory.GetCategoryById(APCContext, id);
if (currentCategory != null)
{
currentCategory.Name = tbName.Text;
APCContext.SaveChanges();
MessageBox.Show("Category Details Successfully Updated");
ClearContent();
}
else
{
MessageBox.Show("Category Id not found");
}
}
else
{
MessageBox.Show("Category Id not found");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Category currentCategory = BLCategory.GetCategoryById(APCContext, id);
if (currentCategory != null)
{
APCContext.DeleteObject(currentCategory);
APCContext.SaveChanges();
MessageBox.Show("Delete Successfully");
ClearContent();
}
else
{
MessageBox.Show("Category Id not found");
}
}
else
{
MessageBox.Show("Category Id not found");
}
}
public JsonResult GetSubCategoryByCategory(string categoryId)
{
BLCategory BL = new BLCategory();
IEnumerable <SelectListItem> SubCategory = BL.SubCategoryDDLByCategory(!string.IsNullOrEmpty(categoryId)?Convert.ToInt32(categoryId):0);
return(Json(SubCategory));
}
private void insertInvoice_Product(Invoice invoice)
{
DataTable dt = (DataTable)dgInvoiceProduct.DataSource;
for (int i = 0; i < dt.Rows.Count; i++)
{
int quantity = 0;
decimal price = 0;
decimal totalPrice = 0;
decimal serviceCharge = 0;
bool subCon = false;
string description = dt.Rows[i]["Description"].ToString();
string categoryName = dt.Rows[i]["Name"].ToString();
//Category selectedCategory = BLCategory.GetCategoryById(APCContext, categoryId);
Category selectedCategory = BLCategory.GetCategoryByExactName(APCContext, categoryName);
Kurs selectedKurs = BLKurs.GetKursByExactName(APCContext, dt.Rows[i]["Kurs"].ToString());
int.TryParse(dt.Rows[i]["Quantity"].ToString(), out quantity);
decimal.TryParse(dt.Rows[i]["Price"].ToString(), out price);
decimal.TryParse(dt.Rows[i]["Total"].ToString(), out totalPrice);
decimal.TryParse(dt.Rows[i]["ServiceCharge"].ToString(), out serviceCharge);
bool.TryParse(dt.Rows[i]["SubCon"].ToString(), out subCon);
BLInvoice_Product.insertInvoice_Product(APCContext, invoice, selectedCategory, description, quantity, dt.Rows[i]["Unit"].ToString(), price, selectedKurs, serviceCharge, totalPrice, subCon);
}
}
private void PopulateCarousel()
{
List <BLCategory> categories = BLCategory.RetrieveListFromDB(connectionString);
foreach (BLCategory category in categories)
{
Image image = new Image
{
CssClass = "carousel-image",
ImageUrl = $"ImgHandler.ashx?categoryId={category.Id}"
};
HyperLink link = new HyperLink
{
NavigateUrl = $"/Result.aspx?categoryId={category.Id}"
};
link.Controls.Add(image);
Label captionLabel = new Label
{
Text = $"<h3 style = 'color: #FFFFFF' > {category.Name} </ h3 >"
};
Panel captionPanel = new Panel {
CssClass = "carousel-caption"
};
captionPanel.Controls.Add(captionLabel);
Panel itemPanel = new Panel {
CssClass = "item"
};
itemPanel.Controls.Add(link);
itemPanel.Controls.Add(captionPanel);
categoryCarousel.Controls.Add(itemPanel);
}
}
/// <summary>
/// 表:BLCategory (添加一条数据
/// </summary>
/// <param name="bLCategory">添加的数据</param>
/// <returns>执行成功的行数</returns>
public static int Insert(BLCategory bLCategory)
{
return(DBHelp.ExecuteNonQuery(
"insert into BLCategory values(@BLName)",
new SqlParameter[] {
new SqlParameter("@BLName", bLCategory.BLName)
}));
}
/// <summary>
/// 表:BLCategory (修改数据
/// </summary>
/// <param name="bLCategory">修改的数据</param>
/// <returns>执行成功的行数</returns>
public static int Update(BLCategory bLCategory)
{
return(DBHelp.ExecuteNonQuery(
"update BLCategory set BLName=@BLName where BLID=@BLID",
new SqlParameter[] {
new SqlParameter("@BLName", bLCategory.BLName),
new SqlParameter("@BLID", bLCategory.BLID),
}));
}
private void btnInsert_Click(object sender, EventArgs e)
{
if (BLCategory.insertCategory(APCContext, tbName.Text))
{
MessageBox.Show("Category Successfully Added");
ClearContent();
}
else
{
MessageBox.Show("Please check your input");
}
}
private void btnSearchByName_Click(object sender, EventArgs e)
{
if (tbSearchValue.Text.Trim() != "")
{
List <Category> clientList = BLCategory.GetCategoryByName(APCContext, tbSearchValue.Text);
dgSearchResult.DataSource = clientList;
}
else
{
MessageBox.Show("Category Name not found");
}
}
private void PopulateCategoryDropdown()
{
List <BLCategory> categories = BLCategory.RetrieveListFromDB(connectionString);
foreach (BLCategory category in categories)
{
Label listItem = new Label
{
Text = $"<li><a href='/Result.aspx?categoryId={category.Id}'>{category.Name}</a></li>"
};
categoryDropdownMenu.Controls.Add(listItem);
}
}
private void DisplayCategoryResult()
{
BLCategory category = BLCategory.RetrieveFromDB(connectionString, categoryId);
if (category == null)
{
throw new HttpException(404, $"Result.aspx?categoryId={categoryId} doesn't exist.");
}
resultBLProducts = BLProduct.RetrieveListFromDB(connectionString,
$"CategoryID = {categoryId} AND ID NOT IN (SELECT VariantID FROM ProductVariants)");
ResultTitle.InnerHtml = category.Name;
ResultImage.Src = $"ImgHandler.ashx?categoryId={categoryId}";
ResultDescription.InnerHtml = category.Description;
DisplayProducts();
}
public static List <BLCategory> SelectAll()
{
string sql = "SELECT BLID,BLName FROM BLCategory ";
SqlDataReader dr = DBHelper.MyExecuteReader(sql);
List <BLCategory> list = new List <BLCategory>();
while (dr.Read())
{
BLCategory bl = new BLCategory();
bl.BLID = Convert.ToInt32(dr["BLID"]);
bl.BLName = dr["BLName"].ToString();
list.Add(bl);
}
dr.Close();
return(list);
}
/// <summary>
/// 查询大类节点
/// </summary>
/// <returns></returns>
public static List <BLCategory> getBLCategoryList()
{
List <BLCategory> list = new List <BLCategory>();
String sql = string.Format("select * from BLCategory");
using (SqlDataReader sdr = DBHelp.MyExecuteReader(sql, null))
{
while (sdr.Read())
{
BLCategory bl = new BLCategory();
bl.BLID = Convert.ToInt32(sdr["BLID"]);
bl.BLName = sdr["BLName"].ToString();
list.Add(bl);
}
}
return(list);
}
/// <summary>
/// 表:BLCategory (根据BLID查询
/// </summary>
/// <param name="BLID">所需BLID</param>
/// <returns>查询结果</returns>
public static BLCategory Select_BLID(int BLID)
{
BLCategory bLCategory = null;
using (SqlDataReader dataReader = DBHelp.ExecuteSqlDataReader(
"select * from BLCategory where BLID=@BLID",
new SqlParameter[] {
new SqlParameter("@BLID", BLID)
}))
{
while (dataReader.Read())
{
bLCategory = new BLCategory()
{
BLID = Convert.ToInt32(dataReader["BLID"]),
BLName = Convert.ToString(dataReader["BLName"]),
};
}
return(bLCategory);
}
}
public HomeLayOutModel GetLayOutData()
{
HomeLayOutModel objHomeLayOutModel = new HomeLayOutModel();
BLCategory objBLCategory = new BLCategory();
BLDocument objBLDocument = new BLDocument();
BLSubCategory objBLSubCategory = new BLSubCategory();
ViewCategoryModel objViewCategoryModel = new ViewCategoryModel();
objViewCategoryModel.CurrentPage = 1;
objViewCategoryModel.PageSize = int.MaxValue - 1;
objHomeLayOutModel.objViewCategoryModel = new ViewCategoryModel();
objHomeLayOutModel.objViewCategoryModel = objBLCategory.GetCategoryList(objViewCategoryModel);
if (objHomeLayOutModel != null && objHomeLayOutModel.objViewCategoryModel != null && objHomeLayOutModel.objViewCategoryModel.CategoryList != null && objHomeLayOutModel.objViewCategoryModel.CategoryList.Count > 0)
{
for (int i = 0; i < objHomeLayOutModel.objViewCategoryModel.CategoryList.Count; i++)
{
//string[] DocumentIds = objHomeLayOutModel.objViewCategoryModel.CategoryList[i].QuickLinks.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
//if (DocumentIds != null && DocumentIds.Length > 0)
//{
// objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList = new List<DocumentModel>();
// for (int j = 0; j < DocumentIds.Length; j++)
// {
// objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList.Add(objBLDocument.GetDocumentById(Convert.ToInt32(DocumentIds[j])));
// }
//}
}
}
ViewSubCategoryModel objViewSubCategoryModel = new ViewSubCategoryModel();
objViewSubCategoryModel.CurrentPage = 1;
objViewSubCategoryModel.PageSize = int.MaxValue - 1;
objHomeLayOutModel.objSubViewCategoryModel = new ViewSubCategoryModel();
objHomeLayOutModel.objSubViewCategoryModel = objBLSubCategory.GetSubCategoryList(objViewSubCategoryModel);
return(objHomeLayOutModel);
}
public List <Category> searchById(int id)
{
if (id != 0)
{
List <Category> categoryList = BLCategory.GetCategoryListById(APCContext, id);
if (categoryList != null)
{
tbId.Text = categoryList[0].Id.ToString();
tbName.Text = categoryList[0].Name;
return(categoryList);
}
else
{
MessageBox.Show("Category Id not found");
}
}
else
{
MessageBox.Show("Category Id not found");
}
return(null);
}
private void ClearFields()
{
this.created = DateTime.MinValue;
this.uid = string.Empty;
this.saveInfo = false;
this.creditCard = null;
this.billingAddress = null;
this.shippingAddress = null;
this.shoppingCart = null;
this.category = null;
this.billingAddress = new BLAddress();
this.shippingAddress = new BLAddress();
this.shoppingCart = new BLShoppingCart();
this.creditCard = new BLCreditCard();
this.items = new BLItems();
this.orders = new BLOrders();
this.category = new BLCategory();
this.item = new BLItem();
}
public HomeController()
{
BL = new BLCategory();
}
/// <summary>
/// 表:BLCategory (添加一条数据
/// </summary>
/// <param name="bLCategory">添加的数据</param>
/// <returns>执行成功的行数</returns>
public static int Insert(BLCategory bLCategory)
{
return(Dal_BLCategory.Insert(bLCategory));
}
/// <summary>
/// 表:BLCategory (修改数据
/// </summary>
/// <param name="bLCategory">修改的数据</param>
/// <returns>执行成功的行数</returns>
public static int Update(BLCategory bLCategory)
{
return(Dal_BLCategory.Update(bLCategory));
}
public Categories[] allCategories()
{
return(BLCategory.allCategories());
}
private void rptCategoryList_Bind()
{
dsCategory = BLCategory.GetList(this.categoryID);
if (this.categoryID==0)
{
rptCategoryList.DataSource = dsCategory.Tables["Category"];
rptCategoryList.DataBind();
}
else
{
BLCategory category = new BLCategory();
category.ID = this.categoryID;
category.Retrieve();
dsCategory2 = BLCategory.GetList(category.ParentID);
if (category.ParentID>0 && dsCategory.Tables["Category"].Rows.Count==0)
{
dsCategory = dsCategory2;
BLCategory category2 = new BLCategory();
category2.ID = category.ParentID;
category2.Retrieve();
dsCategory2 = BLCategory.GetList(category2.ParentID);
this.categoryChildID = this.categoryID;
this.categoryID = category.ParentID;
rptCategoryList.DataSource = dsCategory2.Tables["Category"];
rptCategoryList.DataBind();
}
else
{
rptCategoryList.DataSource = dsCategory2.Tables["Category"];
rptCategoryList.DataBind();
}
}
}