public Dispatch()
 {
     InitializeComponent();
     //Binding orders to grid
     BindDataGrid();
     //Binding drivers
     BindInDrivers();
     connStr = _objdal.constring();
 }
        string connStr = "";//"Data Source=SAIKRISHNA;Initial Catalog=ankapur;Persist Security Info=True;User ID=ankapuruser1;Password=user123";

        public ViewOrdersPage()
        {
            InitializeComponent();
            connStr = _objdal.constring().ToString();
            fillRest();
            fillOrderStatus();

            dtpicker.Text = System.DateTime.Now.ToString();
        }
Ejemplo n.º 3
0
        //_objdal.connstring();
        //ConfigurationManager.ConnectionStrings["connstring"].ToString();

        public ShowOrderOnMap()
        {
            InitializeComponent();


            connStr = _objdal.constring().ToString();

            AddPins();
        }
        public SearchResults()
        {
            InitializeComponent();
            connStr = _objdal.constring();



            sc.myMap.Children.Clear();
            if (lstCustomerResult.Items.Count > 0)
            {
                lstCustomerResult.ItemsSource = null;
            }
            string cust = Application.Current.Properties["newCust"].ToString();

            if (cust != string.Empty)
            {
                cs.CustomerFName = cust;
            }
            else
            {
                cs.CustomerFName = null;
            }
            cs.CustPhoneNumber = cust;
            //   @ Indu--->> Search Customer Move this code into DAL
            DataTable dt = new DataTable();

            dt = _objBal.getCustomer(cs);
            clear();
            if (dt.Rows.Count > 0)
            {
                //sc.expandRes.IsExpanded = true;

                if ((dt.Rows[0][0].ToString() != "Customer Does not Exists"))
                {
                    lstCustomerResult.ItemsSource    = dt.DefaultView;
                    stkListView.Visibility           = Visibility.Visible;
                    sc.stkNewCustomer.Visibility     = Visibility.Visible;
                    lstCustomerResult.ItemsSource    = dt.DefaultView;
                    sc.btnSaveNewCustomer.Visibility = Visibility.Hidden;
                    sc.btnEditCustomer.Visibility    = Visibility.Visible;
                    // CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(lstCustomerResult.ItemsSource);
                    //   PropertyGroupDescription groupDescription = new PropertyGroupDescription("CustPhoneNumber");
                    //      view.GroupDescriptions.Add(groupDescription);
                }

                else
                {
                    stkListView.Visibility           = Visibility.Hidden;
                    sc.stkNewCustomer.Visibility     = Visibility.Visible;
                    sc.btnEditCustomer.Visibility    = Visibility.Hidden;
                    sc.btnSaveNewCustomer.Visibility = Visibility.Visible;
                    MessageBox.Show("Customer not Found!!!", "Customer", MessageBoxButton.OK, MessageBoxImage.Information);
                }
            }
        }
Ejemplo n.º 5
0
        //       // string localizedMessage = (string)Application.Current.FindResource("restCode");
        //       Application.Current.Properties["orderId"] = lblOrderID.Content.ToString();

        //  Application.Current.Properties["custPhone"] = lblOrderID.Content.ToString();
        //Application.Current.Properties["EmpCode"] = lblOrderID.Content.ToString();
        //Application.Current.Properties["UserType"] = lblOrderID.Content.ToString();

        //Application.Current.Properties["orderId"] = "".ToString();
        //Application.Current.Properties["restcode"] = dt.Rows[0][8].ToString();
        ////Application.Current.Properties["custPhone"] = lblOrderID.Content.ToString();
        //Application.Current.Properties["EmpCode"] = dt.Rows[0][3].ToString();
        //Application.Current.Properties["UserType"] = dt.Rows[0][6].ToString();

        public NewOrder()
        {
            InitializeComponent();
            connStr = _objdal.constring().ToString();
            // fillNotAvailable();
            fillRestNames();
            fillCustomer();
            fillEmployee();
            lblCustAddr.Focus();
            FillAgentOrders();
            dtDelivery.Value = DateTime.Now;

            Bindchanneldtls(Cbochannel);
            svitems.ScrollToHome();
        }
        private void fillNewOrders()
        {
            string orderID;

            if (Application.Current.Properties["orderId"].ToString() == null)
            {
                orderID = "HN2312-1";
            }
            else
            {
                orderID = Application.Current.Properties["orderId"].ToString();
            }//"BW1212-11";// (string)
            string connStr = _objdal.constring();
            // string connStr = "Data Source=XSILOKESH;Initial Catalog=Ankapur DB;Integrated Security=True";
            // string connStr = "Data Source=183.82.97.220;Initial Catalog=ankapur;Persist Security Info=True;User ID=test1;Password=123test";
            SqlConnection connection;

            connection = new SqlConnection(connStr);
            if (connection.State.ToString() == "open")
            {
                connection.Close();
            }
            connection.Open();
            SqlCommand cmd = new SqlCommand("[PrintorderStatusByOrderId]", connection);

            cmd.Parameters.Add(new SqlParameter("OrderId", orderID));
            cmd.CommandType = CommandType.StoredProcedure;

            //  @Categorytype = N'Break Fast'

            SqlDataAdapter dAd = new SqlDataAdapter(cmd);

            dAd.Fill(dSet);
            // sda.Fill(dt);

            int ItemsCount = 0;

            lvOrders.Items.Clear();
            if (dSet.Rows.Count > 0)
            {
                lvOrders.ItemsSource = dSet.DefaultView;
                lblOrderID.Content   = dSet.Rows[0][0].ToString().PadRight(5);
                lblCustName.Content  = dSet.Rows[0][2].ToString() + " " + dSet.Rows[0][3].ToString().PadRight(5);
                lblAddress.Content   = dSet.Rows[0][4].ToString();
                lblCustPhone.Content = dSet.Rows[0][1].ToString().PadRight(5);
                lblOrderDate.Content = dSet.Rows[0]["OrderDate"].ToString().Substring(0, 10);
                lblOrderTime.Content = dSet.Rows[0]["OrderTime"].ToString();
                ItemsCount           = int.Parse(dSet.Rows.Count.ToString());
                int sum  = Convert.ToInt32(dSet.Compute("SUM(Total)", string.Empty));
                int sum1 = Convert.ToInt32(dSet.Rows[0]["Deliverycharges"]);
                int sum2 = sum + sum1;
                //     decimal cgstcharges = decimal.Parse(dSet.Rows[0]["CGSTcharges"].ToString());
                //    decimal sgstcharges = decimal.Parse(dSet.Rows[0]["SGSTcharges"].ToString());
                //decimal endamount = (int)Math.Round(sum2 + cgstcharges + sgstcharges);
                decimal endamount = (sum2);
                lblItems.Content      = ItemsCount;
                lbldelcharges.Content = sum1.ToString();//dSet.Rows[0]["Deliverycharges"].ToString();
                lblGrandTotal.Content = endamount.ToString();
                lblStatus.Content     = dSet.Rows[0]["StatusDescription"].ToString();
                //    lblcgst.Content = cgstcharges.ToString();
                //    lblsgst.Content = sgstcharges.ToString();
                lblactamount.Content = sum.ToString();
            }

            if (connection.State.ToString() == "open")
            {
                connection.Close();
            }
        }
Ejemplo n.º 7
0
 public DishesNotAvailable()
 {
     InitializeComponent();
     connStr = _objdal.constring();
     fillNotAvailable();
 }
Ejemplo n.º 8
0
 public DashBoard()
 {
     InitializeComponent();
     showColumnChart();
     connStr = objdal.constring();
 }
 public ProductAailabilityPage()
 {
     InitializeComponent();
     connStr = _objdal.constring().ToString();
     GetProdDetails();
 }