private void updateHourIsPaid(String isPaid)
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("update tblEmployeeHours set isPaid = " + isPaid +
" where EventID = (select EventId from tblEvent" +
" where EventDate between '" + dtpFormDate.Value.Date.ToShortDateString() +
"' and '" + dtpToDate.Value.Date.ToShortDateString() + "'); ", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
// MessageBox.Show("del->" + ex.Message);
}
finally
{
dbConnection.Close();
}
}
private void DelExpenses(string expId)
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("Delete from [tblMiscellaneousExpense] where " +
" ExpenseID=" + expId, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("del" + ex.Message);
}
finally
{
dbConnection.Close();
}
}
private void DelPayroll(string id)
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand(" Delete from tblPayroll where EmployeeId=" + id +
"and PaymentDate='" + payDate + "'", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dbConnection.Close();
}
updateHourIsPaid("0");
}
private void DelSaleProduct(string eventProductId, string salQuantity)
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("Delete from tblSaleProducts where EventProductId=" + eventProductId +
" and SaleID=" + SaleID, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("del" + ex.Message);
}
finally
{
dbConnection.Close();
}
///
dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
command = new SqlCommand(" Update [tblEventProduct] set Quantity= Quantity+ " + salQuantity + "," +
" soldQuantity= soldQuantity-" + salQuantity + " where EventProductID=" + eventProductId, dbConnection);
adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("update" + ex.Message);
}
finally
{
dbConnection.Close();
}
fillSaleGrid();
}
private void FillGridStock(string sql)
{
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "Stock_query");
connection.Close();
grdStock.DataSource = ds;
grdStock.DataMember = "Stock_query";
}
private void FillPayGrid(string sql)
{
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "FullPayroll");
connection.Close();
grdPayroll.DataSource = ds;
grdPayroll.DataMember = "FullPayroll";
}
private void GetPaymentDate()
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("SELECT DISTINCT PaymentDate AS Expr1 FROM [tblFullTimePayroll]", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("No previous payroll are registered", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
radNew.Checked = true;
radExists.Checked = false;
}
else
{
cmbPaymentDate.Enabled = true;
cmbPaymentDate.Focus();
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
DateTime date = DateTime.Parse(row[0].ToString());
AuntRosieApplication.Classes.ListItem itm = new AuntRosieApplication.Classes.ListItem();
itm.name = date.Date.ToShortDateString();
itm.id = date.Date.ToShortDateString();
cmbPaymentDate.Items.Add((Object)itm);
}
}
}
catch (Exception ex)
{
}
finally
{
dbConnection.Close();
}
}
private void btnClear_Click(object sender, EventArgs e)
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("Delete from tblSaleProducts where SaleID=" + SaleID, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("del" + ex.Message);
}
finally
{
dbConnection.Close();
}
dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
command = new SqlCommand("Delete from tblSale where SaleID=" + SaleID, dbConnection);
adapter = new SqlDataAdapter(command);
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("del" + ex.Message);
}
finally
{
dbConnection.Close();
}
fillSaleGrid();
clearData();
}
private void btnDestroy_Click(object sender, EventArgs e)
{
string updateSQLText = "Update [tblIngredientInventory] Set tblIngredientInventory.Quantity=0 " +
"where (tblIngredientInventory.Quantity > 0) " + expierdWhere;
if (InventoryIngredient.RidOutExpierd(DBMethod.GetConnectionString(), updateSQLText))
{
MessageBox.Show("Selected expired items have been rid out", "Confirmation"
, MessageBoxButtons.OK, MessageBoxIcon.Information);
chkExpierd_CheckedChanged(sender, e);
}
else
{
MessageBox.Show("Sorry! An internal error has happened", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void calcRevenue()
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
string sql = "SELECT SUM(tblEventProduct.soldQuantity * tblProductItem.Price) AS SalesPrice " +
" FROM tblEventProduct INNER JOIN " +
" tblProduction ON tblEventProduct.ProductionID = tblProduction.ProductionID INNER JOIN " +
" tblProductItem ON tblProduction.ProductItemID = tblProductItem.ProductItemID INNER JOIN " +
" tblEvent ON tblEventProduct.EventID = tblEvent.EventID";
if (!chkAlltime.Checked)
{
sql = sql + " WHERE(tblEvent.EventDate BETWEEN'" + dtpFormDate.Value.Date.ToShortDateString() + "' AND '" + dtpToDate.Value.Date.ToShortDateString() + "')";
}
SqlCommand command = new SqlCommand(sql, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
lblITotRevenue.Text = "$0.00";
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
lblITotRevenue.Text = double.Parse(row[0].ToString()).ToString("C");
}
}
}
catch (Exception ex)
{
}
}
private void calcExp()
{
string sql = "SELECT SUM(Amount) AS Expr1 FROM (SELECT PaymentDate, Amount FROM tblFullTimePayroll " +
" UNION ALL SELECT PaymentDate, Amount FROM tblPayroll " +
" UNION ALL SELECT ExpensePayDate, ExpenseValue FROM tblMiscellaneousExpense " +
" UNION ALL SELECT PurchaseDate, Cost FROM tblIngredientInventory) AS derivedtbl_1 ";
if (!chkAlltime.Checked)
{
sql += " WHERE(PaymentDate BETWEEN'" + dtpFormDate.Value.Date.ToShortDateString() + "' AND '" + dtpToDate.Value.Date.ToShortDateString() + "')";
}
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand(sql, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
lblITotExpenses.Text = "$0.00";
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
lblITotExpenses.Text = double.Parse(row[0].ToString()).ToString("C");
}
}
}
catch (Exception ex)
{
}
}
private void GetQuantityType()
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("SELECT SUM(tblIngredientInventory.Quantity) AS Expr1, tblIngredient.Unit, tblIngredientType.IngredientTypeID" +
" FROM tblIngredientInventory INNER JOIN " +
" tblIngredient ON tblIngredientInventory.IngredientID = tblIngredient.IngredientID INNER JOIN " +
" tblIngredientType ON tblIngredient.IngredientTypeID = tblIngredientType.IngredientTypeID " +
"GROUP BY tblIngredient.Unit, tblIngredientType.IngredientTypeID" +
" HAVING(tblIngredientType.IngredientTypeID = " + DBMethod.GetSelectedItemID(cmbType) + ") ", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
lblQuantityType.Text = "0.00";
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
lblQuantityType.Text = row[0].ToString() + " " + row[1].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dbConnection.Close();
}
}
private void FillPayGridPart()
{
string sql = " SELECT tblPayroll.PaymentDate, tblPayroll.Amount, tblEmployee.EmployeeID, tblPayroll.FromDate, tblPayroll.ToDate," +
" CASE WHEN PaymentMethod = 'r' THEN 'Credit' ELSE CASE WHEN PaymentMethod = 'c' THEN 'Cash' ELSE CASE WHEN PaymentMethod = 'd' THEN 'Debit' END END END AS PaymentMethod" +
" FROM tblEmployee INNER JOIN " +
" tblPayroll ON tblEmployee.EmployeeID = tblPayroll.EmployeeID WHERE tblPayroll.EmployeeID = " + DBMethod.GetSelectedItemID(cmbEmployeeName);;
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "PayrollPart");
connection.Close();
grdPayrollPart.DataSource = ds;
grdPayrollPart.DataMember = "PayrollPart";
}
private void calcSales()
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("SELECT SUM(tblEventProduct.Quantity* tblProductItem.Price) AS SalesPrice, tblEventProduct.EventID" +
" FROM tblEventProduct INNER JOIN " +
" tblProduction ON tblEventProduct.ProductionID = tblProduction.ProductionID INNER JOIN " +
" tblProductItem ON tblProduction.ProductItemID = tblProductItem.ProductItemID " +
" GROUP BY tblEventProduct.EventID " +
" HAVING(tblEventProduct.EventID = " + DBMethod.GetSelectedItemID(cmbEventName) + ")", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
lblRevenue.Text = "$0.00";
lblIngrdeintCost.Text = "$0.00";
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
lblRevenue.Text = double.Parse(row[0].ToString()).ToString("C");
lblIngrdeintCost.Text = (double.Parse(row[0].ToString()) * 0.28).ToString("C");
}
}
}
catch (Exception ex)
{
}
}
private void FillPayGridFull()
{
string sql = "SELECT EmployeeID, PaymentDate, Month, Amount, Year, " +
" CASE WHEN tblFullTimePayroll.PaymentMethod = 'r' THEN 'Credit' ELSE CASE WHEN tblFullTimePayroll.PaymentMethod = 'c' THEN 'Cash' ELSE CASE WHEN tblFullTimePayroll.PaymentMethod = 'd' THEN 'debit' END END END," +
" CASE WHEN BiWeekNo = 1 THEN 'First 2 weeks' ELSE CASE WHEN BiWeekNo = 2 THEN 'Last 2 Weeks' END END" +
" AS BiWeekNo FROM tblFullTimePayroll where EmployeeID = " + DBMethod.GetSelectedItemID(cmbEmployeeName);
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "PayrollFull");
connection.Close();
grdPayrollFull.DataSource = ds;
grdPayrollFull.DataMember = "PayrollFull";
}
private void fillExpenseGrid()
{
String sql = "SELECT ExpenseID, ExpensePayDate, ExpenseValue, ExpenseNote, " +
" CASE WHEN PaymentMethod = 'r' THEN 'Credit' ELSE CASE WHEN PaymentMethod = 'c' THEN 'Cash' ELSE CASE WHEN PaymentMethod = 'd' THEN 'Debit' END END END AS PaymentMethod, " +
" CASE WHEN ExpenseType = 'T' THEN 'Tansportation' ELSE CASE WHEN ExpenseType = 'U' THEN 'Utility Bill' ELSE CASE WHEN ExpenseType = 'M' THEN 'Maintenance Fee' ELSE CASE WHEN ExpenseType = 'O' THEN 'Maintenance Fee' " +
" END END END END AS ExpenseType " +
" FROM tblMiscellaneousExpense" +
" WHERE(ExpensePayDate = '" + dtpFormDate.Value.Date.ToShortDateString() + "')";
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "ExpensDet");
connection.Close();
grdExpenses.DataSource = ds;
grdExpenses.DataMember = "ExpensDet";
}
private void fillSaleGrid()
{
String sql = "SELECT tblSale.SaleID, tblSaleProducts.SaleQuantity, tblSaleProducts.SalePrice, tblSaleProducts.SaleQuantity * tblSaleProducts.SalePrice AS itemCost, tblCustomer.CustomerFirstName, tblCustomer.CustomerLastName," +
" tblSale.SaleDateTime, tblSale.PaymentMethod, tblProductSize.SizeName, tblProduct.ProductName, tblSaleProducts.EventProductID " +
" FROM tblSaleProducts INNER JOIN " +
" tblSale ON tblSaleProducts.SaleID = tblSale.SaleID INNER JOIN " +
" tblCustomer ON tblSale.CustomerID = tblCustomer.CustomerID INNER JOIN " +
" tblEventProduct ON tblSaleProducts.EventProductID = tblEventProduct.EventProductID INNER JOIN " +
" tblProduction ON tblEventProduct.ProductionID = tblProduction.ProductionID INNER JOIN " +
" tblProductItem ON tblProduction.ProductItemID = tblProductItem.ProductItemID INNER JOIN " +
" tblProductSize ON tblProductItem.SizeID = tblProductSize.SizeID INNER JOIN " +
" tblProduct ON tblProductItem.ProductID = tblProduct.ProductID " +
" WHERE(tblSale.SaleID = " + SaleID.ToString() + ")";
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "SaleDet");
connection.Close();
grdSale.DataSource = ds;
grdSale.DataMember = "SaleDet";
if (grdSale.Rows.Count > 0)
{
btnClear.Enabled = true;
btnSave.Enabled = true;
calcBill();
}
else
{
btnClear.Enabled = false;
btnSave.Enabled = false;
}
}
private void FillHours()
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("SELECT SUM(Hours) AS exp1 " +
" FROM(SELECT tblEmployeeHours.EmployeeID, tblEmployeeHours.EventID, tblEmployeeHours.Hours," +
" tblEmployeeHours.IsPaid, tblEvent.EventID AS Expr1, tblEvent.EventName, tblEvent.LocationID, tblEvent.EventDate, " +
" tblEvent.EventType FROM tblEmployeeHours INNER JOIN tblEvent ON tblEmployeeHours.EventID = tblEvent.EventID " +
" WHERE(tblEvent.EventID =" + DBMethod.GetSelectedItemID(cmbEventName) + ")) AS derivedtbl_1" +
" GROUP BY EventID HAVING(EventID = " + DBMethod.GetSelectedItemID(cmbEventName) + ")", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
lblHour.Text = "0.0";
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
lblHour.Text = (double.Parse(row[0].ToString()) * HoursWages).ToString("C");
}
}
}
catch (Exception ex)
{
}
}
private void FillProduct(String eventID)
{
string sqlEventText = "SELECT tblEventProduct.EventProductID, tblProduct.ProductName, tblProduct.ProductType " +
"FROM tblEventProduct INNER JOIN " +
"tblProduction ON tblEventProduct.ProductionID = tblProduction.ProductionID INNER JOIN " +
"tblProductItem ON tblProduction.ProductItemID = tblProductItem.ProductItemID INNER JOIN " +
"tblProductSize ON tblProductItem.SizeID = tblProductSize.SizeID INNER JOIN " +
"tblProduct ON tblProductItem.ProductID = tblProduct.ProductID " +
" WHERE tblEventProduct.EventID = " + eventID + " and tblEventProduct.Quantity > tblEventProduct.soldQuantity";
// Declare the connection
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand(sqlEventText, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable productTable = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(productTable);
cmbProduct.Items.Clear();
DBMethod.FillCombBoxPerson(productTable, cmbProduct);
}
catch (Exception ex)
{
}
finally
{
dbConnection.Close();
}
// Return the populated DataTable
}
private void DelPayroll(string id, string year, string month, string biweek)
{
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
if (biweek == "First 2 weeks")
{
biweek = "1";
}
else
{
biweek = "2";
}
// Create new SQL command
SqlCommand command = new SqlCommand(" Delete from [tblFullTimePayroll] where EmployeeId=" + id +
" and Month=" + month + " and Year=" + year + " and BiweekNo=" + biweek, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dbConnection.Close();
}
}
private void fillGrid()
{
string sql = "";
if (chkAlltime.Checked)
{
if (chkExpenType.Checked)
{
sql = sqltext + " " + sqlOrder;
if (!chkPay.Checked)
{
sql = sqltext + " where " + sqlWherePayMethod + " " + sqlOrder;
}
}
else
{
sql = sqltext + " where" + sqlWhereType + " " + sqlOrder;
if (!chkPay.Checked)
{
sql = sqltext + " where " + sqlWhereType + " and " + sqlWherePayMethod + " " + sqlOrder;
}
}
}
else
{
if (chkExpenType.Checked)
{
sql = sqltext + " where" + sqlWhereTime + " " + sqlOrder;
if (!chkPay.Checked)
{
sql = sqltext + " where" + sqlWhereTime + " and " + sqlWherePayMethod + " " + sqlOrder;
}
}
else
{
sql = sqltext + " where" + sqlWhereType + " and " + sqlWhereTime + " " + sqlOrder;
if (!chkPay.Checked)
{
sql = sqltext + " where" + sqlWhereType + " and " + sqlWhereTime + " and " + sqlWherePayMethod + " " + sqlOrder;
}
}
}
string connectionString = DBMethod.GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "ExpenCost");
connection.Close();
grdCost.DataSource = ds;
grdCost.DataMember = "ExpenCost";
if (grdCost.Rows.Count == 0)
{
MessageBox.Show("No reults are founded", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
calcTotal();
}
private void cmbPartEmp_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbPartEmp.SelectedItem != null)
{
txtwage.Text = "";
lblHour.Text = "";
lblPartAmount.Text = "";
if (lblDays.Text.Length > 0)
{
txtwage.Focus();
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand("SELECT SUM(Hours) AS exp1 " +
" FROM(SELECT tblEmployeeHours.EmployeeID, tblEmployeeHours.EventID, tblEmployeeHours.Hours," +
" tblEmployeeHours.IsPaid, tblEvent.EventID AS Expr1, tblEvent.EventName, tblEvent.LocationID, tblEvent.EventDate, " +
" tblEvent.EventType FROM tblEmployeeHours INNER JOIN tblEvent ON tblEmployeeHours.EventID = tblEvent.EventID " +
" WHERE(tblEvent.EventDate BETWEEN '" + dtpFormDate.Value.Date.ToShortDateString() + "' AND '" +
dtpToDate.Value.Date.ToShortDateString() + "' )) AS derivedtbl_1" +
" GROUP BY EmployeeID HAVING(EmployeeID = " + DBMethod.GetSelectedItemID(cmbPartEmp) + ")", dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable dt = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(dt);
btnAddPart.Enabled = true;
if (dt.Rows.Count == 0)
{
btnAddPart.Enabled = false;
lblHour.Text = "0.0";
}
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
lblHour.Text = String.Format("{0:0.0}", row[0].ToString());
}
}
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message);
}
finally
{
dbConnection.Close();
}
}
else
{
MessageBox.Show("From Date should be before To Date ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (lblHour.Text.Trim() == "0")
{
pnlPartAddPayroll.Enabled = false;
}
else
{
pnlPartAddPayroll.Enabled = true;
}
}
}
