protected void SearchButton_Click(object sender, EventArgs e) { if (IdentificationTaxNumberTextBox.Text.Trim().Equals("")) { LabelWarning.Text = "Abone Bulunamadı!"; return; } var Subscriber = WebServiceHelpers.GetUserSubscriber(new SubscriberRequest() { IdentificationTaxNumber = IdentificationTaxNumberTextBox.Text.Trim() }); SubscriberId = Subscriber.SubscriberId; if (SubscriberId > 0) { FillGrid(); } else { GridViewInvoice.DataSource = null; GridViewInvoice.DataBind(); LabelWarning.Text = "Aktif Abone Bulunamadı!"; } }
private void BindVoiceItem(string VoiceCode, string incode) { string sql = "select GI_MATCODE,GI_NAME,GI_GUIGE,GI_UNIT,cast(SUM(GI_NUM) as float) AS GI_NUM,cast(round(AVG(GI_UNITPRICE),4) as float) AS GI_UNITPRICE,cast(round(SUM(GI_AMTMNY),2) as float) AS GI_AMTMNY,GI_TAXRATE,cast(round(AVG(GI_CTAXUPRICE),4) as float) AS GI_CTAXUPRICE,cast(round(SUM(GI_CTAMTMNY),2) as float) AS GI_CTAMTMNY from TBFM_GHINVOICEDETAIL where GI_CODE='" + VoiceCode + "' and GI_UNICODE like '" + incode.Split('S')[0] + "%' group by GI_MATCODE,GI_NAME,GI_GUIGE,GI_UNIT,GI_TAXRATE"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); GridViewInvoice.DataSource = dt; GridViewInvoice.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { SqlDataSourceInvoice.InsertParameters["Shipment_Id"].DefaultValue = dropShipmentId.SelectedValue; SqlDataSourceInvoice.InsertParameters["Sorder_Number"].DefaultValue = dropSorderNumber.SelectedValue; SqlDataSourceInvoice.InsertParameters["Product_Id"].DefaultValue = dropProductId.SelectedValue; SqlDataSourceInvoice.InsertParameters["Payment_Id"].DefaultValue = dropPaymentId.SelectedValue; SqlDataSourceInvoice.Insert(); GridViewInvoice.DataBind(); panelAddInvoice.Visible = false; panelSaveInvoice.Visible = true; dropShipmentId.SelectedIndex = 0; dropSorderNumber.SelectedIndex = 0; dropPaymentId.SelectedIndex = 0; dropProductId.SelectedIndex = 0; }
public void FillGrid() { SubscriberCheckResponse UserInfo = (SubscriberCheckResponse)Session["UserInfo"]; var InvoiceAllUnpaidList = WebServiceHelpers.GetInvoicePaid(UserInfo.SubscriberId).ToList(); if (InvoiceAllUnpaidList.Count > 0) { GridViewInvoice.DataSource = InvoiceAllUnpaidList; GridViewInvoice.DataBind(); } else { GridViewInvoice.DataSource = null; GridViewInvoice.DataBind(); } }
public void FillGrid() { LabelWarning.Text = ""; var InvoiceAllUnpaidList = WebServiceHelpers.GetInvoiceAllUnpaid(SubscriberId).ToList(); if (InvoiceAllUnpaidList.Count > 0) { GridViewInvoice.DataSource = InvoiceAllUnpaidList; GridViewInvoice.DataBind(); } else { GridViewInvoice.DataSource = null; GridViewInvoice.DataBind(); LabelWarning.Text = "Ödenmemiş Fatura Bulunamadı!"; } }
protected void BindData() { //Admin ViewState["dtInvoice"] = oLNCT_Service.getData("I"); //ViewState["dtSearch"] = (DataTable)ViewState["dtInvoice"]; dtCustomerGroup = customerGroupService.customerGroupData(); dtCustomer = customerService.customerData(); dtCustomerDepartment = customerDepartmentService.customerDepartmentData(); dtCustomerShipping = customerShippingService.customerShippingData(); dtItem = itemService.itemData("'I'"); dtPrice = priceService.priceData(); dtSale = saleService.saleData(); dtDeliveryRoute = deliveryRouteService.deliveryRouteData(); dtWarehouse = warehouseService.warehouseData(); //Bind Data to GridViewInvoice GridViewInvoice.DataSource = (DataTable)ViewState["dtInvoice"]; GridViewInvoice.DataBind(); }
protected void BindData(string id) { DataTable reqData = oSALE_ORDER_Service.getDataById(id); ViewState["reqData"] = reqData; lblDetailId.Text = reqData.Rows[0]["SALE_ORDER_ID"].ToString(); lblDetailCustomerGroup.Text = reqData.Rows[0]["Cus_Group_Name"].ToString(); lblDetailCustomer.Text = reqData.Rows[0]["Cus_Name"].ToString(); lblDetailSaleOrderType.Text = reqData.Rows[0]["SALE_ORDER_TYPE"].ToString(); lblDetailVenderName.Text = reqData.Rows[0]["VENDER_NAME"].ToString(); lblDetailSaleOrderNumber.Text = reqData.Rows[0]["SALE_ORDER_Number"].ToString(); lblDetailSaleOrderBalance.Text = reqData.Rows[0]["SALE_ORDER_Balance"].ToString(); lblDetailPONumber.Text = reqData.Rows[0]["PO_Number"].ToString(); lblDetailSaleOrderShippingDate.Text = reqData.Rows[0]["SALE_ORDER_Shipping_Date"].ToString(); double amount = Double.Parse(reqData.Rows[0]["SALE_ORDER_Amount"].ToString()); lblDetailSaleOrderAmount.Text = string.Format("{0:C2}", amount); double balance = Double.Parse(reqData.Rows[0]["SALE_ORDER_Balance"].ToString()); lblDetailSaleOrderBalance.Text = string.Format("{0:C2}", balance); lblDetailSale.Text = reqData.Rows[0]["Sale_Name"].ToString(); lblDetailCostCenter.Text = reqData.Rows[0]["COST_CENTER_NAME"].ToString(); txtEditRemark.Text = reqData.Rows[0]["SALE_ORDER_Remark"].ToString(); RdWarehouseStatus.SelectedValue = reqData.Rows[0]["SALE_ORDER_Status"].ToString(); DataTable reqDataDetail = oSALE_ORDER_Service.getDataDetail(id); ViewState["reqDataDetail"] = reqDataDetail; GridView.DataSource = reqDataDetail; GridView.DataBind(); ViewState["reqDataInvoice"] = oINVENTORY_Service.getDataBySaleOrder(lblDetailSaleOrderNumber.Text); GridViewInvoice.DataSource = (DataTable)ViewState["reqDataInvoice"]; GridViewInvoice.DataBind(); ViewState["reqDataCreditNote"] = oCREDITNOTE_Service.getDataBySaleOrder(lblDetailSaleOrderNumber.Text); GridViewCreditNote.DataSource = (DataTable)ViewState["reqDataCreditNote"]; GridViewCreditNote.DataBind(); ViewState["reqDataComment"] = oSALE_ORDER_Service.getDataCommentById(id); GridViewComment.DataSource = (DataTable)ViewState["reqDataComment"]; GridViewComment.DataBind(); }