private void searchButton_Click(object sender, EventArgs e)
{
//showdataGridView.DataSource = null;
PurchaseRepotingModel purchaserepotingModel = new PurchaseRepotingModel();
if (startDateTimePicker.Text == " ")
{
MessageBox.Show("please insert start date");
return;
}
if (endDateTimePicker.Text == " ")
{
MessageBox.Show("please insert end date");
return;
}
purchaserepotingModel.Date = startDateTimePicker.Text;
purchaserepotingModel.Date2 = endDateTimePicker.Text;
bool ishas = !_purchaserepotingManager.SearchValue(purchaserepotingModel).Any();
if (ishas)
{
MessageBox.Show("no data");
return;
}
else
{
showdataGridView.DataSource = _purchaserepotingManager.SearchValue(purchaserepotingModel);
}
}
private void searchiconButton_Click(object sender, EventArgs e)
{
PurchaseRepotingModel purchaserepotingModel = new PurchaseRepotingModel();
if (nameTextBox.Text == " ")
{
MessageBox.Show("please insert name");
return;
}
purchaserepotingModel.Name = nameTextBox.Text;
bool ishas = !_purchaserepotingManager.SearchValueByName(purchaserepotingModel).Any();
if (ishas)
{
MessageBox.Show("no data");
return;
}
else
{
showdataGridView.DataSource = _purchaserepotingManager.SearchValueByName(purchaserepotingModel);
}
}
public List <PurchaseRepotingModel> SearchValueByName(PurchaseRepotingModel purchaseRepotingModel)
{
string connectionString = @"Server=DESKTOP-077IM0O;DataBase=Project1DB;Integrated Security=true";
SqlConnection sqlConnection = new SqlConnection(connectionString);
string CommandString = @"SELECT * FROM PurchaseReport WHERE ProductName='" + purchaseRepotingModel.Name + "' ";
SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);
sqlConnection.Open();
List <PurchaseRepotingModel> purchaseRepotingModels = new List <PurchaseRepotingModel>();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
PurchaseRepotingModel _purchaseRepotingModel = new PurchaseRepotingModel();
_purchaseRepotingModel.Code = Convert.ToString(sqlDataReader["Code"]);
_purchaseRepotingModel.Product = Convert.ToString(sqlDataReader["ProductName"]);
_purchaseRepotingModel.Category = Convert.ToString(sqlDataReader["CategoryName"]);
_purchaseRepotingModel.Quantity = Convert.ToDouble(sqlDataReader["Quantity"]);
_purchaseRepotingModel.UnitPrice = Convert.ToDouble(sqlDataReader["TotalPrice"]);
_purchaseRepotingModel.MRP = Convert.ToDouble(sqlDataReader["TotalMRP"]);
_purchaseRepotingModel.Profit = Convert.ToDouble(sqlDataReader["Profit"]);
purchaseRepotingModels.Add(_purchaseRepotingModel);
}
sqlConnection.Close();
return(purchaseRepotingModels);
}
public List <PurchaseRepotingModel> SearchValue(PurchaseRepotingModel purchaseRepotingModel)
{
string connectionString = @"Server=NANDITA\SQLEXPRESS;DataBase=Project1DB;Integrated Security=true";
SqlConnection sqlConnection = new SqlConnection(connectionString);
string CommandString = @"SELECT * FROM [Purchase Report] WHERE Date BETWEEN '" + purchaseRepotingModel.Date + "'AND '" + purchaseRepotingModel.Date2 + "' ";
SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);
sqlConnection.Open();
List <PurchaseRepotingModel> purchaseRepotingModels = new List <PurchaseRepotingModel>();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
PurchaseRepotingModel _purchaseRepotingModel = new PurchaseRepotingModel();
_purchaseRepotingModel.Code = Convert.ToString(sqlDataReader["Code"]);
_purchaseRepotingModel.Name = Convert.ToString(sqlDataReader["Name"]);
_purchaseRepotingModel.Category = Convert.ToString(sqlDataReader["Category"]);
_purchaseRepotingModel.Quantity = Convert.ToDouble(sqlDataReader["Quantity"]);
_purchaseRepotingModel.CP = Convert.ToDouble(sqlDataReader["CP"]);
_purchaseRepotingModel.MRP = Convert.ToDouble(sqlDataReader["MRP"]);
_purchaseRepotingModel.Profit = Convert.ToDouble(sqlDataReader["Profit"]);
purchaseRepotingModels.Add(_purchaseRepotingModel);
}
sqlConnection.Close();
return(purchaseRepotingModels);
}
private void Srarch_Click(object sender, EventArgs e)
{
showDataGridView.DataSource = null;
PurchaseRepotingModel purchaserepotingModel = new PurchaseRepotingModel();
if (startDateTimePicker.Text == " " && startDateTimePicker.Text == " ")
{
MessageBox.Show("please insert date");
return;
}
purchaserepotingModel.Date = startDateTimePicker.Text;
purchaserepotingModel.Date2 = endDateTimePicker.Text;
// List<PurchaseRepotingModel> purchaseRepotingModels = new List<PurchaseRepotingModel>();
// purchaseRepotingModels = _purchaseRepotingManager.SearchValue(purchaserepotingModel);
bool ishas = !_purchaseRepotingManager.SearchValue(purchaserepotingModel).Any();
if (ishas)
{
MessageBox.Show("no data");
return;
}
else
{
showDataGridView.DataSource = _purchaseRepotingManager.SearchValue(purchaserepotingModel);
}
}
public List <PurchaseRepotingModel> SearchValue(PurchaseRepotingModel purchaseRepotingModel)
{
return(_purchaseRepotingRepository.SearchValue(purchaseRepotingModel));
}
