private void dataGrid_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.dataGrid.Rows[e.RowIndex];
empId = row.Cells["EmployeeNic"].Value.ToString();
name.Text = row.Cells["Name"].Value.ToString();
phone.Text = row.Cells["Phone"].Value.ToString();
email.Text = row.Cells["Email"].Value.ToString();
nic.Text = row.Cells["EmployeeNic"].Value.ToString();
empType.Text = row.Cells["EmployeeType"].Value.ToString();
dob.Value = DateTime.Parse(row.Cells["Dob"].Value.ToString());
DBconnection connection = new DBconnection();
//connection.getImage(empId);
try
{
SqlCommand command1 = new SqlCommand("select Photo from [dbo].[Employee] where EmployeeNic=@param", connection.getConnection());
SqlParameter myparam = command1.Parameters.Add("@param", SqlDbType.NVarChar, 30);
myparam.Value = empId;
byte[] img = (byte[])command1.ExecuteScalar();
MemoryStream str = new MemoryStream();
str.Write(img, 0, img.Length);
Bitmap bit = new Bitmap(str);
connection.getConnection().Close();
}
catch (Exception ex)
{
Console.WriteLine("photo error: " + ex);
}
}
}
public void displayEmployees()
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.displayRegistredEmployees());
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
private void availableEquipmentsAndChemicals()
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.displayAvailableChemicalsAndEquipments());
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
private void displayPriceList()
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.diplayPriceList());
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
private void displayAvailableReports()
{
try
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.displayMLTAvailableReports());
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
catch (Exception ex)
{
MessageBox.Show("Error in display Reports:\n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void displayAvailableReports()
{
try
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.displayAvailableReports());
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
catch (Exception ex)
{
MessageBox.Show("Error in Displaying Reports:\n" + ex, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Console.WriteLine("Error: \n" + ex);
}
}
public void PatientReports()
{
//string timestamp = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fff",CultureInfo.InvariantCulture)+ primaryKey.RandomString(5);
//MessageBox.Show("time: " + timestamp);
try
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.displayAllPatientsReports());
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
catch (Exception ex)
{
MessageBox.Show("Error in Displaying: \n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Console.WriteLine("Error:\n" + ex);
}
}
private void guna2Button1_Click(object sender, EventArgs e)
{
string date1 = dateOne.ToString();
string date2 = dateTwo.ToString();
try
{
DBconnection connection5 = new DBconnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(connection5.displayReportBetweentwodays(date1, date2));
da.Fill(dt);
dataGrid.DataSource = dt;
connection5.getConnection().Close();
}
catch (Exception ex)
{
MessageBox.Show("Error in Displaying Reports:\n" + ex, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Console.WriteLine("Error: \n" + ex);
}
}
