public List <SaleRepotingModel> SearchValue(SaleRepotingModel saleRepotingModel)
        {
            string        connectionString = @"Server=NANDITA\SQLEXPRESS;DataBase=Project1DB;Integrated Security=true";
            SqlConnection sqlConnection    = new SqlConnection(connectionString);

            string CommandString = @"SELECT * FROM [Purchase Report] WHERE Date BETWEEN '" + saleRepotingModel.Date + "'AND '" + saleRepotingModel.Date2 + "' ";

            SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);

            sqlConnection.Open();

            List <SaleRepotingModel> saleRepotingModels = new List <SaleRepotingModel>();

            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            while (sqlDataReader.Read())
            {
                SaleRepotingModel _saleRepotingModel = new SaleRepotingModel();

                _saleRepotingModel.Code     = Convert.ToString(sqlDataReader["Code"]);
                _saleRepotingModel.Name     = Convert.ToString(sqlDataReader["Name"]);
                _saleRepotingModel.Category = Convert.ToString(sqlDataReader["Category"]);
                _saleRepotingModel.Quantity = Convert.ToDouble(sqlDataReader["Quantity"]);
                _saleRepotingModel.CP       = Convert.ToDouble(sqlDataReader["CP"]);
                // _saleRepotingModel.MRP = Convert.ToDouble(sqlDataReader["MRP"]);
                _saleRepotingModel.Profit = Convert.ToDouble(sqlDataReader["Profit"]);

                saleRepotingModels.Add(_saleRepotingModel);
            }

            sqlConnection.Close();

            return(saleRepotingModels);
        }
        public List <SaleRepotingModel> SearchValueByName(SaleRepotingModel saleRepotingModel)
        {
            string        connectionString = @"Server=DESKTOP-077IM0O;DataBase=Project1DB;Integrated Security=true";
            SqlConnection sqlConnection    = new SqlConnection(connectionString);

            string CommandString = @"SELECT * FROM SalesRepoting WHERE Name='" + saleRepotingModel.Name + "'";

            SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);

            sqlConnection.Open();

            List <SaleRepotingModel> saleRepotingModels = new List <SaleRepotingModel>();

            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            while (sqlDataReader.Read())
            {
                SaleRepotingModel _saleRepotingModel = new SaleRepotingModel();

                _saleRepotingModel.Product  = Convert.ToString(sqlDataReader["Name"]);
                _saleRepotingModel.Category = Convert.ToString(sqlDataReader["Category"]);

                _saleRepotingModel.Quantity = Convert.ToDouble(sqlDataReader["Quantity"]);

                _saleRepotingModel.UnitPrice = Convert.ToDouble(sqlDataReader["totalUnitPrice"]);
                _saleRepotingModel.MRP       = Convert.ToDouble(sqlDataReader["TotalMRP"]);
                _saleRepotingModel.Profit    = Convert.ToDouble(sqlDataReader["Profit"]);

                saleRepotingModels.Add(_saleRepotingModel);
            }

            sqlConnection.Close();

            return(saleRepotingModels);
        }
예제 #3
0
        private void datesearchButton_Click(object sender, EventArgs e)
        {
            showDataGridView.DataSource = null;
            SaleRepotingModel salerepotingModel = new SaleRepotingModel();

            if (startDateTimePicker.Text == " " && startDateTimePicker.Text == " ")
            {
                MessageBox.Show("please insert date");
                return;
            }
            salerepotingModel.Date  = startDateTimePicker.Text;
            salerepotingModel.Date2 = enddateTimePicker.Text;
            // List<PurchaseRepotingModel> purchaseRepotingModels = new List<PurchaseRepotingModel>();
            // purchaseRepotingModels = _purchaseRepotingManager.SearchValue(purchaserepotingModel);
            bool ishas = !_saleRepotingManager.SearchValue(salerepotingModel).Any();

            if (ishas)
            {
                MessageBox.Show("no data");
                return;
            }
            else
            {
                showDataGridView.DataSource = _saleRepotingManager.SearchValue(salerepotingModel);
            }
        }
        private void namesearchButton_Click(object sender, EventArgs e)
        {
            SaleRepotingModel salerepotingModel = new SaleRepotingModel();

            if (nameTextBox.Text == " ")
            {
                MessageBox.Show("please insert name");
                return;
            }

            salerepotingModel.Name = nameTextBox.Text;


            bool ishas = !_salerepotingManager.SearchValueByName(salerepotingModel).Any();

            if (ishas)
            {
                MessageBox.Show("no data");
                return;
            }
            else
            {
                showdataGridView.DataSource = _salerepotingManager.SearchValueByName(salerepotingModel);
            }
        }
        public List <SaleRepotingModel> SearchValue(SaleRepotingModel saleRepotingModel)
        {
            string        connectionString = _connectionRepository.GetConnectionString();
            SqlConnection sqlConnection    = new SqlConnection(connectionString);

            string CommandString = @"SELECT * FROM SalesRepoting WHERE Date BETWEEN '" + saleRepotingModel.Date + "' AND '" + saleRepotingModel.Date2 + "'";

            SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);

            sqlConnection.Open();

            List <SaleRepotingModel> saleRepotingModels = new List <SaleRepotingModel>();

            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            while (sqlDataReader.Read())
            {
                SaleRepotingModel _saleRepotingModel = new SaleRepotingModel();

                _saleRepotingModel.Product  = Convert.ToString(sqlDataReader["Name"]);
                _saleRepotingModel.Category = Convert.ToString(sqlDataReader["Category"]);

                _saleRepotingModel.Quantity = Convert.ToDouble(sqlDataReader["Quantity"]);

                _saleRepotingModel.UnitPrice = Convert.ToDouble(sqlDataReader["totalUnitPrice"]);
                _saleRepotingModel.MRP       = Convert.ToDouble(sqlDataReader["TotalMRP"]);
                _saleRepotingModel.Profit    = Convert.ToDouble(sqlDataReader["Profit"]);

                saleRepotingModels.Add(_saleRepotingModel);
            }

            sqlConnection.Close();

            return(saleRepotingModels);
        }
예제 #6
0
 public List <SaleRepotingModel> SearchValue(SaleRepotingModel saleRepotingModel)
 {
     return(_saleRepotingRepository.SearchValue(saleRepotingModel));
 }