//void CheckedSelectedItems() //{ // foreach (RepeaterItem item in rep.Items) // { // CheckBox chk = (CheckBox)item.FindControl("chk"); // HiddenField hidProductID = (HiddenField)item.FindControl("hidProductID"); // if (chk.Checked) // { // if (!pgc.SelectedIDs.Contains(int.Parse(hidProductID.Value))) // { // pgc.SelectedIDs.Add(int.Parse(hidProductID.Value)); // //ProductMachineItems.Add(prepareCartRecord(item)); // } // } // else // { // if (pgc.SelectedIDs.Contains(int.Parse(hidProductID.Value))) // { // pgc.SelectedIDs.Remove(int.Parse(hidProductID.Value)); // //ProductMachineItems.Remove(prepareCartRecord(item)); // } // } // } //} void PopulateGrid() { ListData res = new ListData(1, 1, 1); dsProduct.ProductDataTable tbl = da.Product_Search(txtSearchCode.Text, txtSearchName.Text, (int.Parse(rdRecon.SelectedValue) == 1 ? 0 : 1), DateTime.Now, (rdIsPromotion.SelectedValue == "1" ? true : false), out res, pgc.CurrentPage); pgc.Populate(res); byte[] ls = new byte[tbl.Rows.Count]; rep.DataSource = ls; rep.DataBind(); for (int i = 0; i <= ls.Length - 1; i++) { dsProduct.ProductRow drProduct = (dsProduct.ProductRow)tbl.Rows[i]; RepeaterItem item = (RepeaterItem)rep.Items[i]; HtmlTableRow tr = (HtmlTableRow)item.FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "gridData" : "gridDataAlt"); HiddenField hidProductID = (HiddenField)item.FindControl("hidProductID"); hidProductID.Value = drProduct.ID.ToString(); CheckBox chk = (CheckBox)item.FindControl("chk"); LinkButton lnkDetails = (LinkButton)item.FindControl("lnkDetails"); lnkDetails.Text = drProduct.Name; lnkDetails.CommandArgument = drProduct.ID.ToString(); Literal litCode = (Literal)item.FindControl("litCode"); litCode.Text = drProduct.Code; Button btnAddToCart = (Button)item.FindControl("btnAddToCart"); btnAddToCart.CommandArgument = i.ToString(); int quantity = 1; string price = "0.00 (Unknown Tier)"; dsPOProductItem _dsPOProductItem = new dsPOProductItem(); dsPOProductItem.POProductItemRow drPOProductItem = da.POProductItem_GetPOQuantity(WebLib.LoggedInUser.DealerUserID, new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1), DateTime.Now); if (drPOProductItem != null && drPOProductItem.Quantity > 0) quantity = drPOProductItem.Quantity + 1; dsProductPriceTier _dsProductPriceTier = new dsProductPriceTier(); dsProductPriceTier.ProductPriceTierRow drProductPriceTier = da.ProductPriceTier_Get(drProduct.ID, quantity); if (drProductPriceTier != null) { switch (drProductPriceTier.TierName) { case "Tier1": //price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Tier 1)"; price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; case "Tier2": //price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Tier 2)"; price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; case "Tier3": //price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Tier 3)"; price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; case "NoTier": //price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (No Tier)"; price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; } } Label lblPrice = (Label)item.FindControl("lblPrice"); lblPrice.Text = price; TextBox txtPrice = (TextBox)item.FindControl("txtPrice"); txtPrice.Text = "0.00"; RadioButtonList rdOrderType = (RadioButtonList)item.FindControl("rdOrderType"); rdOrderType.Attributes.Add("onClick", "javascript:CheckedOrderType('" + rdOrderType.ClientID + "','" + lblPrice.ClientID + "','" + txtPrice.ClientID + "');"); //if (pgc.SelectedIDs.Contains(drProduct.ID)) //{ // chk.Checked = true; //} //else //{ // chk.Checked = false; //} } }
private void BindDataMachine() { dsCart.ViewProductCartDataTable tblCart = da.Cart_DisplayMachine(WebLib.LoggedInUser.DealerUserID, true); byte[] ls = new byte[tblCart.Rows.Count]; repMachine.DataSource = ls; repMachine.DataBind(); int totalQuantityMachineItem = da.Cart_TotalMachine(WebLib.LoggedInUser.DealerUserID); for (int i = 0; i <= ls.Length - 1; i++) { dsCart.ViewProductCartRow drProductCart = (dsCart.ViewProductCartRow)tblCart.Rows[i]; RepeaterItem item = (RepeaterItem)repMachine.Items[i]; totalQuantityMachine += drProductCart.Quantity; } for (int i = 0; i <= ls.Length - 1; i++) { dsCart.ViewProductCartRow drProductCart = (dsCart.ViewProductCartRow)tblCart.Rows[i]; RepeaterItem item = (RepeaterItem)repMachine.Items[i]; HtmlTableRow tr = (HtmlTableRow)item.FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); Literal litNo = (Literal)item.FindControl("litNo"); litNo.Text = (i + 1).ToString() + "."; Literal litEDPCode = (Literal)item.FindControl("litEDPCode"); litEDPCode.Text = drProductCart.Code; Literal litName = (Literal)item.FindControl("litName"); litName.Text = drProductCart.Name +(drProductCart.IsPromotion ? " <b>[Promotion]</b>" : ""); Literal litUnitPrice = (Literal)item.FindControl("litUnitPrice"); litUnitPrice.Text = (drProductCart.UnitPrice).ToString(WebLib.CurrencyFormat); TextBox txtQuantity = (TextBox)item.FindControl("txtQuantity"); txtQuantity.Text = drProductCart.Quantity.ToString(); LinkButton lnkUpdateCart = (LinkButton)item.FindControl("lnkUpdateCart"); lnkUpdateCart.CommandArgument = drProductCart.ID.ToString(); LinkButton lnkRemove = (LinkButton)item.FindControl("lnkRemove"); lnkRemove.CommandArgument = drProductCart.ID.ToString(); Repeater repService = (Repeater)item.FindControl("repService"); decimal totalOptionalItemPrice = 0; if (drProductCart.ItemTypeEnum == (short)ItemType.Accessory) { Literal litTotalPrice = (Literal)item.FindControl("litTotalPrice"); litTotalPrice.Text = ((drProductCart.UnitPrice * drProductCart.Quantity)).ToString(WebLib.CurrencyFormat); totalPriceMachine += Decimal.Round((drProductCart.UnitPrice * drProductCart.Quantity), 2); } else { string tempOptionals = ""; #region Machine Item Repeater repMachineItem = (Repeater)item.FindControl("repMachineItem"); dsMachineItem.MachineItemDataTable tblItem = da.MachineItem_Search(drProductCart.CartItemID, (int)ProductItemType.Machine, true); if (tblItem.Rows.Count > 0) { repMachineItem.DataSource = new byte[tblItem.Rows.Count]; repMachineItem.DataBind(); tr = (HtmlTableRow)repMachineItem.Controls[0].Controls[0].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); int machineCount = 0; //tempOptionals += "<br /><b><u>Service</u></b>"; foreach (dsMachineItem.MachineItemRow drItem in tblItem.Rows) { tr = (HtmlTableRow)repMachineItem.Items[machineCount].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); Literal litMachineEDPCode = (Literal)repMachineItem.Items[machineCount].FindControl("litMachineEDPCode"); litMachineEDPCode.Text = drItem.Code; Literal litMachineName = (Literal)repMachineItem.Items[machineCount].FindControl("litMachineName"); litMachineName.Text = drItem.Name; //tempOptionals += drItem.Name + "<br />"; machineCount++; } } #endregion tblItem = da.MachineItem_Search(drProductCart.CartItemID, (int)ProductItemType.Service, true); if (tblItem.Rows.Count > 0) { repService.DataSource = new byte[tblItem.Rows.Count]; repService.DataBind(); tr = (HtmlTableRow)repService.Controls[0].Controls[0].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); int serviceCount = 0; //tempOptionals += "<br /><b><u>Service</u></b>"; foreach (dsMachineItem.MachineItemRow drItem in tblItem.Rows) { tr = (HtmlTableRow)repService.Items[serviceCount].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); Literal litServiceEDPCode = (Literal)repService.Items[serviceCount].FindControl("litServiceEDPCode"); litServiceEDPCode.Text = drItem.Code; Literal litServiceName = (Literal)repService.Items[serviceCount].FindControl("litServiceName"); litServiceName.Text = drItem.Name; //tempOptionals += drItem.Name + "<br />"; serviceCount++; } } else repService.Visible = false; Repeater repConfig = (Repeater)item.FindControl("repConfig"); tblItem = da.MachineItem_Search(drProductCart.CartItemID, (int)ProductItemType.Config, true); if (tblItem.Rows.Count > 0) { repConfig.DataSource = new byte[tblItem.Rows.Count]; repConfig.DataBind(); int configCount = 0; tr = (HtmlTableRow)repConfig.Controls[0].Controls[0].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); //tempOptionals += "<br /><b><u>Config</u></b>"; foreach (dsMachineItem.MachineItemRow drItem in tblItem.Rows) { tr = (HtmlTableRow)repConfig.Items[configCount].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); Literal litConfigEDPCode = (Literal)repConfig.Items[configCount].FindControl("litConfigEDPCode"); litConfigEDPCode.Text = drItem.Code; Literal litConfigName = (Literal)repConfig.Items[configCount].FindControl("litConfigName"); litConfigName.Text = drItem.Name; //tempOptionals += "<br />" + drItem.Name; configCount++; } } Repeater repOthers = (Repeater)item.FindControl("repOthers"); tblItem = da.MachineItem_Search(drProductCart.CartItemID, (int)ProductItemType.OthersPromotionItems, true); if (tblItem.Rows.Count > 0) { repOthers.DataSource = new byte[tblItem.Rows.Count]; repOthers.DataBind(); int othersCount = 0; tr = (HtmlTableRow)repOthers.Controls[0].Controls[0].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); //tempOptionals += "<br /><b><u>Config</u></b>"; foreach (dsMachineItem.MachineItemRow drItem in tblItem.Rows) { tr = (HtmlTableRow)repOthers.Items[othersCount].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); Literal litOthersEDPCode = (Literal)repOthers.Items[othersCount].FindControl("litOthersEDPCode"); litOthersEDPCode.Text = drItem.Code; Literal litOthersName = (Literal)repOthers.Items[othersCount].FindControl("litOthersName"); litOthersName.Text = drItem.Name; othersCount++; } } Repeater repOptional = (Repeater)item.FindControl("repOptional"); dsCartOptionalItem.ViewCartOptionalItemDataTable tblViewCartOptionalItem = da.CartOptionalItem_Display(drProductCart.ID); if (tblViewCartOptionalItem.Rows.Count > 0) { repOptional.DataSource = new byte[tblViewCartOptionalItem.Rows.Count]; repOptional.DataBind(); tr = (HtmlTableRow)repOptional.Controls[0].Controls[0].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); //litEDPCode.Text += "<br />"; //tempOptionals += "<br /><b><u>Optional</u></b>"; } int optCount = 0; foreach (dsCartOptionalItem.ViewCartOptionalItemRow row in tblViewCartOptionalItem) { tr = (HtmlTableRow)repOptional.Items[optCount].FindControl("trRow"); tr.Attributes.Add("class", (i % 2 == 0) ? "GridRow2" : "GridRowAlt2"); Literal litOptionalEDPCode = (Literal)repOptional.Items[optCount].FindControl("litOptionalEDPCode"); litOptionalEDPCode.Text = row.Code; Literal litOptionalName = (Literal)repOptional.Items[optCount].FindControl("litOptionalName"); litOptionalName.Text = row.Name; Literal litOptionalUnitPrice = (Literal)repOptional.Items[optCount].FindControl("litOptionalUnitPrice"); litOptionalUnitPrice.Text = row.Price.ToString(WebLib.CurrencyFormat); TextBox txtOptionalQuantity = (TextBox)repOptional.Items[optCount].FindControl("txtOptionalQuantity"); txtOptionalQuantity.Text = row.Quantity.ToString(); HiddenField hidOptionalItemID = (HiddenField)repOptional.Items[optCount].FindControl("hidOptionalItemID"); hidOptionalItemID.Value = row.ID.ToString(); //litEDPCode.Text += "<br />" + row.Code; //tempOptionals += "<br />" + row.Name; totalOptionalItemPrice += row.UnitPrice * row.Quantity; optCount++; } //litName.Text += "<br /><br />"; //if (tempOptionals != "") // litEDPCode.Text += "<br />"; HiddenField hidIsNoTier = (HiddenField)item.FindControl("hidIsNoTier"); if (drProductCart.OrderTypeEnum == (short)OrderType.Normal) { int quantity = 0; dsPOProductItem.POProductItemRow drPOProductItem = da.POProductItem_GetPOQuantity(WebLib.LoggedInUser.DealerUserID, new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1), DateTime.Now); if (drPOProductItem != null && drPOProductItem.Quantity > 0) quantity = drPOProductItem.Quantity;// +1; string price = ""; dsProductPriceTier _dsProductPriceTier = new dsProductPriceTier(); dsProductPriceTier.ProductPriceTierRow drProductPriceTier = da.ProductPriceTier_Get(drProductCart.CartItemID, (quantity + totalQuantityMachineItem)); if (drProductPriceTier != null) { switch (drProductPriceTier.TierName) { case "Tier1": price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; case "Tier2": price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; case "Tier3": price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; case "NoTier": price = drProductPriceTier.Price.ToString(WebLib.CurrencyFormat) + " (Normal)"; break; } litUnitPrice.Text = price; Literal litTotalPrice = (Literal)item.FindControl("litTotalPrice"); litTotalPrice.Text = (((drProductPriceTier != null ? drProductPriceTier.Price : drProductCart.UnitPrice) * drProductCart.Quantity) + totalOptionalItemPrice).ToString(WebLib.CurrencyFormat); totalPriceMachine += Decimal.Round((((drProductPriceTier != null ? drProductPriceTier.Price : drProductCart.UnitPrice) * drProductCart.Quantity) + totalOptionalItemPrice), 2); } } else { litUnitPrice.Text = (drProductCart.UnitPrice).ToString(WebLib.CurrencyFormat); Literal litTotalPrice = (Literal)item.FindControl("litTotalPrice"); litTotalPrice.Text = ((drProductCart.UnitPrice * drProductCart.Quantity) + totalOptionalItemPrice).ToString(WebLib.CurrencyFormat); totalPriceMachine += Decimal.Round((drProductCart.UnitPrice * drProductCart.Quantity) + totalOptionalItemPrice, 2); } } } litMachineTotalQuantity.Text = totalQuantityMachine.ToString(); litMachineTotalPrice.Text = "RM " + totalPriceMachine.ToString(WebLib.CurrencyFormat); }