private void Form1_Load(object sender, EventArgs e) { DBconnection ob = new DBconnection(); ob.priceList(); if (!ob.checkUserName("admin")) { byte[] bytes = Encoding.ASCII.GetBytes("0x53797374656D2E427974655B5D"); employee ox = new employee("admin", "admin", "1997/06/02", "admin", 123, "Admin", "admin", "admin", bytes); ob.addEmployees(ox); } else { return; } }
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 button1_Click(object sender, EventArgs e) { if (notifi.Text.Trim() == string.Empty || nType.Text.Trim() == string.Empty || about.Text.Trim() == string.Empty) { MessageBox.Show("Empty Fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string selected = this.nType.GetItemText(this.nType.SelectedItem); showNotification(notifi.Text, selected); DBconnection ob = new DBconnection(); string messageId = primaryKey.RandomString(6); Message ox = new Message(messageId, notifi.Text, nType.Text); ob.messageDatebase(ox); clear(); } }
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); } }
private void guna2Button1_Click(object sender, EventArgs e) { try { String name = txtName.Text; double price = Convert.ToDouble(txtPrice.Text); DBconnection ob = new DBconnection(); ob.updatePriceList(name, price); clear(); displayPriceList(); } catch (Exception ex) { MessageBox.Show("Error Update! \n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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); } }
private void guna2Button4_Click(object sender, EventArgs e) { try { if (nic.Text.Trim() != string.Empty && test.Text.Trim() != string.Empty) { using (OpenFileDialog dig = new OpenFileDialog { Filter = "PDF Documents(*.pdf) | *.pdf", ValidateNames = true }) { if (dig.ShowDialog() == DialogResult.OK) { DialogResult dialog = MessageBox.Show("Are you sure want to upload?", "File Upload", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.Yes) { string finishedDate = DateTime.Today.ToString(); string filename = dig.FileName; DBconnection ob = new DBconnection(); ob.uploadReport(filename, reportNumber, patientNic, finishedDate); } } } clear(); displayAvailableReports(); } else { MessageBox.Show("Empty Fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("Error upload file:\n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Console.WriteLine("upload: \n" + ex); } displayAvailableReports(); }
private void guna2Button1_Click(object sender, EventArgs e) { //int logCount = 0; bool permission = false; if (uName.Text.Trim() != string.Empty && pWord.Text.Trim() != string.Empty) { try { login ob = new login(uName.Text, pWord.Text); DBconnection ox = new DBconnection(); permission = ox.adminLogin(ob); if (permission == true) { thread = new Thread(openFront); thread.SetApartmentState(ApartmentState.STA); thread.Start(); Dispose(); } else { MessageBox.Show("Invalid User Name or Password!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("Error\n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Empty Fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void guna2Button3_Click(object sender, EventArgs e) { DBconnection ui = new DBconnection(); string type = empType.Text; if (name.Text.Trim() == string.Empty) { MessageBox.Show("Empty Name Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (nic.Text.Trim() == string.Empty) { MessageBox.Show("Empty NIC Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (dob.Text.Trim() == string.Empty) { MessageBox.Show("Empty DOB Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (email.Text.Trim() == string.Empty) { MessageBox.Show("Empty Email Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (empType.Text.Trim() == string.Empty) { MessageBox.Show("Enter Designation!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //!type.Equals("MLT") || !type.Equals("Cashier") || !type.Equals("Admin") || !type.Equals("Other") else if (empType.Text.Trim() != string.Empty) { if (type.Equals("MLT")) { } else if (type.Equals("Casheir")) { } else if (type.Equals("Admin")) { } else if (type.Equals("Other")) { if (other.Text.Trim() == string.Empty) { MessageBox.Show("Empty Other Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { MessageBox.Show("Enter valid Designation!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else if (phone.Text.Trim() == string.Empty) { MessageBox.Show("Empty Phone Number Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { return; } if (user.Checked) { if (userName.Text.Trim() == string.Empty) { MessageBox.Show("Empty UserName Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (password.Text.Trim() == string.Empty) { MessageBox.Show("Empty Password Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (cPassword.Text.Trim() == string.Empty) { MessageBox.Show("Empty Confirm Password Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (password.Text != cPassword.Text) { MessageBox.Show("Password does not match!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (ui.checkUserName(userName.Text)) { MessageBox.Show("Username Already Taken!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } DialogResult answer; answer = MessageBox.Show("Are you sure want to add Employee?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); //*************database********************** if (answer == DialogResult.Yes || answer == DialogResult.OK) { try { MemoryStream ms = new MemoryStream(); byte[] img = ms.ToArray(); if (pictureBox1.Image == null) { MessageBox.Show("Empty Image!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat); } string Enic = "E" + nic.Text; string Ename = name.Text; string date = dob.Value.ToShortDateString(); string Eemail = email.Text; int Ephone = Convert.ToInt32(phone.Text); string eType = empType.Text; string Eusername = userName.Text; string Epassword = password.Text; byte[] Photo = img; employee ox = new employee(Enic, Ename, date, Eemail, Ephone, eType, Eusername, Epassword, Photo); ui.addEmployees(ox); } catch (Exception ex) { MessageBox.Show("erro: \n" + ex); Console.WriteLine("erro: \n" + ex); } clearFileds(); } }
private void button1_Click(object sender, EventArgs e) { if (core.Text.Trim() == string.Empty) { MessageBox.Show("Empty Chemical or ID Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (name.Text.Trim() == string.Empty) { MessageBox.Show("Empty Name Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (price.Text.Trim() == string.Empty) { MessageBox.Show("Empty Price Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (quantity.Text.Trim() == string.Empty) { MessageBox.Show("Empty Quantity Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { DialogResult answer; answer = MessageBox.Show("Are you sure want to add Employee?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (answer == DialogResult.Yes) { //******database connect ****** try { string date1 = date.Value.ToString(); if (core.Text.Equals("Chemical") || core.Text.Equals("Equipment")) { //float cPrice = float.Parse(price.Text); string cPrice = price.Text; string cQuantity = quantity.Text + cmbQuantity.Text; string cReference = reference.Text; string cName = name.Text; DBconnection dbconnection = new DBconnection(); if (dbconnection.findChemicalEquipment(cName)) { string currentQuantity = dbconnection.getCurrentQuantity(name.Text); int q = Convert.ToInt32(currentQuantity) + Convert.ToInt32(cQuantity); string newQuantity = q.ToString(); dbconnection.updateChemicalAndEquipment(cName, newQuantity); } else { chemicalsAndEquipments chemicalsAndequipments = new chemicalsAndEquipments(date1, cName, cPrice, cQuantity, global.UserID, cReference); dbconnection.addChemicalsAndEquipments(chemicalsAndequipments); } availableEquipmentsAndChemicals(); clearFileds(); } else { MessageBox.Show("Enter valid Type(Chemical or Equipment)", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception ex) { MessageBox.Show("Error:\n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Console.WriteLine("Error: \n" + ex); } } } }
private void guna2ImageButton6_Click_1(object sender, EventArgs e) { DBconnection ui = new DBconnection(); ui.showNotificationTimeToTime(); }
public Front() { InitializeComponent(); DBconnection ox = new DBconnection(); //Console.WriteLine("me me: " + global.UserID); }
private void guna2Button4_Click(object sender, EventArgs e) { if (name.Text.Trim() == string.Empty) { MessageBox.Show("Empty UserName Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (nic.Text.Trim() == string.Empty) { MessageBox.Show("Empty NIC Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (contact.Text.Trim() == string.Empty) { MessageBox.Show("Empty Contact Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (address.Text.Trim() == string.Empty) { MessageBox.Show("Empty Address Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (!male.Checked && !female.Checked && !other.Checked) { MessageBox.Show("Select Gender!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (paidAmount.Text.Trim() == string.Empty) { MessageBox.Show("Empty Paid Amount Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { DialogResult answer; answer = MessageBox.Show("Are you sure want to Confirm Payment?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (answer == DialogResult.Yes) { try { //******patient database*****// DBconnection connection = new DBconnection(); string selectedGender = ""; if (male.Checked) { selectedGender = "Male"; } else if (female.Checked) { selectedGender = "Female"; } else { selectedGender = "Other"; } var dateOf = dob.Value; bill patientDetails = new bill(nic.Text, name.Text, dateOf.Date.ToString(), selectedGender, address.Text, Convert.ToInt32(contact.Text)); if (!connection.searchPatient(nic.Text)) { connection.addPatient(patientDetails); } //******bill database******// string billNumber = "B" + DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fff", CultureInfo.InvariantCulture); string date = DateTime.UtcNow.Date.ToString(); string requiredDate = rDate.Value.ToShortDateString(); double total1 = Convert.ToDouble(total.Text); bill billDetails = new bill(billNumber, date, requiredDate, global.UserID, nic.Text, total1, des.Text); connection.addInvoice(billDetails); //******report database******// foreach (global.reportStruct i in reportList) { report patientReport = new report(nic.Text, i.stReportNumber, i.stTest, i.stRequiredDate); DBconnection connection1 = new DBconnection(); connection1.Report(patientReport); } displayAvailableReports(); reportList.Clear(); clear(); } catch (Exception ex) { MessageBox.Show("Error:\n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Console.WriteLine("Error:\n" + ex); } } } }
private void guna2Button1_Click(object sender, EventArgs e) { try { string patientNic = nic.Text; DBconnection connection2 = new DBconnection(); if (connection2.searchPatient(patientNic)) { int counter = 0; ArrayList patientDetailsArray = new ArrayList(); //MessageBox.Show("Patient Found?", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); patientDetailsArray = connection2.getPatientDetails(patientNic); foreach (string i in patientDetailsArray) { Console.WriteLine("\n console: " + i + " counter: " + counter); if (counter == 0) { name.Text = i; } if (counter == 1) { dob.Value = DateTime.Parse(i); } //if (counter == 0) //{ // name.Text = i; //} if (counter == 2) { if (i.Equals("Male")) { male.Checked = true; } else if (i.Equals("Female")) { female.Checked = true; } else { other.Checked = true; } } if (counter == 4) { contact.Text = i; } else { address.Text = i; } counter++; } } else { MessageBox.Show("No Patient Found?", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("No Patient Found ?", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Console.WriteLine("error search: " + ex); } }
public void cashInHand() { DBconnection connection5 = new DBconnection(); cash.Text = connection5.displayCashInHand(date); }