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);
}
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);
}
public List <SaleRepotingModel> SearchValue(SaleRepotingModel saleRepotingModel)
{
return(_saleRepotingRepository.SearchValue(saleRepotingModel));
}
