public override string ToString() { StringBuilder result = new StringBuilder(); if (IsSetTitle()) { result.Append("Title: "); result.AppendLine(Title); } if (IsSetASIN()) { result.Append("ASIN: "); result.AppendLine(ASIN); } if (IsSetSellerSKU()) { result.Append("SKU: "); result.AppendLine(SellerSKU); } if (IsSetItemPrice()) { result.Append("Price: "); result.AppendLine(ItemPrice.ToString()); } if (IsSetItemTax()) { result.Append("Item Tax: "); result.AppendLine(ItemTax.ToString()); } if (IsSetPromotionDiscount()) { result.Append("Promotions Discount: "); result.AppendLine(PromotionDiscount.ToString()); } if (IsSetPromotionIds()) { if (PromotionIds.PromotionId != null) { foreach (string promotionId in PromotionIds.PromotionId) { result.Append("\tPromotion Id: "); result.AppendLine(promotionId); } } } if (IsSetShippingDiscount()) { result.Append("Shipping Discount: "); result.AppendLine(ShippingDiscount.ToString()); } if (IsSetQuantityOrdered()) { result.Append("Quantity: "); result.AppendLine(QuantityOrdered.ToString()); } if (IsSetQuantityShipped()) { result.Append("Quantity Shipped: "); result.AppendLine(QuantityShipped.ToString()); } if (IsSetCODFee()) { result.Append("COD Fee: "); result.AppendLine(CODFee.ToString()); } if (IsSetCODFeeDiscount()) { result.Append("COD Fee Discount: "); result.AppendLine(CODFeeDiscount.ToString()); } if (IsSetGiftMessageText()) { result.Append("Gift Message Text: "); result.AppendLine(GiftMessageText); } if (IsSetGiftWrapPrice()) { result.Append("Gift Wrap Price: "); result.AppendLine(GiftWrapPrice.ToString()); } if (IsSetGiftWrapLevel()) { result.Append("Gift Wrap Level: "); result.AppendLine(GiftWrapLevel.ToString()); } return(result.ToString()); }
public override string ToString() { return(string.Concat(DeliveryPaymentButtonId, " ", DisplayText, " ", ItemPrice.ToString("0.00 €", System.Globalization.CultureInfo.CurrentUICulture.NumberFormat))); }
protected void GVKitMaterial_RowCommand(object sender, GridViewCommandEventArgs e) { try { int recordId = Convert.ToInt32(e.CommandArgument); Session["RecordId"] = recordId; #region For Edit Record if (e.CommandName == "EditRecord") { SqlParameter[] arrParam = new SqlParameter[2]; arrParam[0] = new SqlParameter("@Action", "SELECT_ByID"); arrParam[1] = new SqlParameter("@ID", recordId); DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParam); DataTable DTRecords = DSRecords.Tables[0]; if (DTRecords.Rows.Count > 0) { MVMatrialKit.ActiveViewIndex = 1; TBName.Text = DTRecords.Rows[0]["Name"].ToString(); TBBarcode.Text = DTRecords.Rows[0]["Barcode"].ToString(); TBProductCode.Text = DTRecords.Rows[0]["ProductCode"].ToString(); TBHSN.Text = DTRecords.Rows[0]["HSNCode"].ToString(); TBUOM.Text = DTRecords.Rows[0]["UOM"].ToString(); TBCategory.Text = DTRecords.Rows[0]["Category"].ToString(); TBDescription.Text = DTRecords.Rows[0]["Description"].ToString(); lblTotalQty.Text = DTRecords.Rows[0]["TotalQty"].ToString(); lblTotalValue.Text = DTRecords.Rows[0]["TotalValue"].ToString(); ImgLogo.ImageUrl = DTRecords.Rows[0]["Image"].ToString(); BindRowItemList(); SqlParameter[] arrParam2 = new SqlParameter[2]; arrParam2[0] = new SqlParameter("@Action", "SELECT_ByMID"); arrParam2[1] = new SqlParameter("@MID", recordId); DataSet DSInner = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_KitDetails_CRUD", arrParam2); // Bind Table CreateDTTable(); TempDT = ViewState["DTTable"] as DataTable; for (int i = 0; i < DSInner.Tables[0].Rows.Count; i++) { string SelQuery = "SELECT * FROM RawMaterial Where ID='" + DSInner.Tables[0].Rows[i]["PID"] + "'"; DataTable DTProduct = clsConnectionSql.filldt(SelQuery); double ItemPrice, Quantity, GTotal; Quantity = Convert.ToDouble(DSInner.Tables[0].Rows[i]["Qty"].ToString()); ItemPrice = Convert.ToDouble(DTProduct.Rows[0]["PurPrice"].ToString()); GTotal = ItemPrice * Quantity; TempDT.Rows.Add(DTProduct.Rows[0]["ID"], DTProduct.Rows[0]["Name"].ToString(), DTProduct.Rows[0]["Barcode"].ToString(), Quantity.ToString("0.00"), ItemPrice.ToString("0.00"), GTotal.ToString("0.00")); } GVInner.DataSource = TempDT; GVInner.DataBind(); ViewState["DTTable"] = TempDT; btnSubmit.Text = "Update"; } } #endregion #region For Delete Record if (e.CommandName == "DeleteRecord") { // Delete Image From Folder SqlParameter[] arrParamDel = new SqlParameter[2]; arrParamDel[0] = new SqlParameter("@Action", "SELECT_ByID"); arrParamDel[1] = new SqlParameter("@ID", recordId); DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParamDel); if (DSRecords.Tables[0].Rows[0]["Image"].ToString() != "" && DSRecords.Tables[0].Rows[0]["Image"].ToString() != "~/AdminImages/noimg.png") { File.Delete(Server.MapPath(DSRecords.Tables[0].Rows[0]["Image"].ToString())); } SqlParameter[] arrParam = new SqlParameter[2]; arrParam[0] = new SqlParameter("@Action", "DELETE"); arrParam[1] = new SqlParameter("@ID", recordId); int Result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParam); } #endregion #region For Change Status if (e.CommandName == "ChangeStatus") { SqlParameter[] arrParam = new SqlParameter[2]; arrParam[0] = new SqlParameter("@Action", "SELECT_ByID"); arrParam[1] = new SqlParameter("@ID", recordId); DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParam); DataTable DTRecords = DSRecords.Tables[0]; if (DTRecords.Rows.Count > 0) { #region Change Status True To False if (DTRecords.Rows[0]["Status"].ToString() == "True") { SqlParameter[] arrParam2 = new SqlParameter[3]; arrParam2[0] = new SqlParameter("@Action", "UPDATE_Status"); arrParam2[1] = new SqlParameter("@Status", false); arrParam2[2] = new SqlParameter("@ID", recordId); int Result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParam2); } #endregion #region Change Status False TO True if (DTRecords.Rows[0]["Status"].ToString() == "False") { SqlParameter[] arrParam2 = new SqlParameter[3]; arrParam2[0] = new SqlParameter("@Action", "UPDATE_Status"); arrParam2[1] = new SqlParameter("@Status", true); arrParam2[2] = new SqlParameter("@ID", recordId); int Result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParam2); } #endregion } } #endregion BindGVKitMaterial(); } catch (Exception ex) { ShowMessage(ex.Message, MessageType.Error); } }
protected void GVItemDetail_RowCommand(object sender, GridViewCommandEventArgs e) { try { int recordId = Convert.ToInt32(e.CommandArgument); Session["RecordID"] = recordId; if (e.CommandName == "EditRecord") { SqlParameter[] arr = new SqlParameter[2]; arr[0] = new SqlParameter("@Action", "SELECT_ByID"); arr[1] = new SqlParameter("@ID", recordId); DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_ItemRequestMaster_CRUD", arr); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { MVRequest.ActiveViewIndex = 1; LBLReqNo.Text = dt.Rows[0]["ReqNo"].ToString(); LBLTOtQut.Text = dt.Rows[0]["TotalQty"].ToString(); DDLComLoc.SelectedValue = dt.Rows[0]["ComId"].ToString(); BindComForRequest(); LBLTotVal.Text = dt.Rows[0]["TotalValue"].ToString(); LBReqDate.Text = dt.Rows[0]["ReqDate"].ToString(); txtDelDate.Text = dt.Rows[0]["DeliverDate"].ToString(); BindDDLNGO(DDLComLoc.SelectedValue); DDLNgoLoc.ClearSelection(); DDLNgoLoc.SelectedValue = dt.Rows[0]["NgoId"].ToString(); DDLItemType.ClearSelection(); DDLItemList.ClearSelection(); txtRemarks.Text = dt.Rows[0]["Remark"].ToString(); txtTermCon.Text = dt.Rows[0]["TermAndCondition"].ToString(); BindDDLGodown(DDLComLoc.SelectedValue); DDLDelTo.SelectedValue = dt.Rows[0]["DeliverTo"].ToString(); DDLItemType.SelectedValue = dt.Rows[0]["ItemType"].ToString(); switch (DDLItemType.SelectedValue) { case "1": BindItemKitTypeList(); break; case "2": BindItemFinishTypeList(); break; default: break; } btnSubmit.Text = "Update"; SqlParameter[] arrParam2 = new SqlParameter[2]; arrParam2[0] = new SqlParameter("@Action", "Select_ByReqId"); arrParam2[1] = new SqlParameter("@ReqId", recordId); DataSet DSInner = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_ItemRequestDetail_CRUD", arrParam2); // Bind Table CreateDTTable(); TempDT = ViewState["DTTable"] as DataTable; for (int i = 0; i < DSInner.Tables[0].Rows.Count; i++) { string SelQuery = "SELECT * FROM KitMaterial Where ID='" + DSInner.Tables[0].Rows[i]["ItemId"] + "'"; DataTable DTProduct = clsConnectionSql.filldt(SelQuery); double ItemPrice, Quantity, GTotal; Quantity = Convert.ToDouble(DSInner.Tables[0].Rows[i]["Qty"].ToString()); ItemPrice = Convert.ToDouble(DTProduct.Rows[0]["TotalValue"].ToString()); GTotal = ItemPrice * Quantity; TempDT.Rows.Add(DTProduct.Rows[0]["ID"], DTProduct.Rows[0]["Image"].ToString(), DTProduct.Rows[0]["Name"].ToString(), DTProduct.Rows[0]["ProductCode"].ToString(), DTProduct.Rows[0]["HSNCode"].ToString(), DTProduct.Rows[0]["BarCode"].ToString(), DTProduct.Rows[0]["UOM"].ToString(), Quantity.ToString("0.00"), ItemPrice.ToString("0.00"), GTotal.ToString("0.00")); } GVInner.DataSource = TempDT; GVInner.DataBind(); ViewState["DTTable"] = TempDT; } BindInnerGV(); } else if (e.CommandName == "DeleteRecord") { SqlParameter[] arr = new SqlParameter[2]; arr[0] = new SqlParameter("@Action", "DELETE"); arr[1] = new SqlParameter("@ID", recordId); DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_ItemRequestMaster_CRUD", arr); } if (e.CommandName == "CheckStatus") { SqlParameter[] arr = new SqlParameter[2]; arr[0] = new SqlParameter("@Action", "SELECT_ByID"); arr[1] = new SqlParameter("@ID", recordId); DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_ItemRequestMaster_CRUD", arr); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["ReqStatus"].ToString() == "True") { SqlParameter[] arr1 = new SqlParameter[3]; arr1[0] = new SqlParameter("@Action", "UPDATE_Status"); arr1[1] = new SqlParameter("@ReqStatus", false); arr1[2] = new SqlParameter("@ID", recordId); int result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_ItemRequestMaster_CRUD", arr1); } if (dt.Rows[0]["ReqStatus"].ToString() == "False") { SqlParameter[] arr1 = new SqlParameter[3]; arr1[0] = new SqlParameter("@Action", "UPDATE_Status"); arr1[1] = new SqlParameter("@ReqStatus", true); arr1[2] = new SqlParameter("@ID", recordId); int result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_ItemRequestMaster_CRUD", arr1); } } } BindGVDetail(); } catch (Exception ex) { ShowMessage(ex.Message, MessageType.Error); } }