private void approveButton_Click(object sender, RoutedEventArgs e) { if (purchaseID != "") { string query = "UPDATE sparepart_purchase SET om_approved='1',date_purchased='" + DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss") + "' WHERE id='" + purchaseID + "'"; if (DBManager.UpdateDatabaseQuery(query)) { valuesC.Rows.Add(values.Rows[myGridSelectedIndex].ItemArray); myMessageBox mm = new myMessageBox("Approved Successfully", "Success", "OK", 0); mm.ShowDialog(); // MessageBox.Show("Approved Succefully", "Success", MessageBoxButton.OK, MessageBoxImage.Information); values = DBManager.selectForPurchaseApproval(); approve_sparepart_purchase.ItemsSource = values.AsDataView(); purchaseID = ""; } else { myMessageBox mm = new myMessageBox("Error Occured", "Error", "OK", 1); mm.ShowDialog(); // MessageBox.Show("Error Occured", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void approveButton_Click(object sender, RoutedEventArgs e) { if (maintainanceID != "") { string query = "UPDATE maintainance_request SET om_approved='1' WHERE maintainance_id='" + maintainanceID + "'"; if (DBManager.UpdateDatabaseQuery(query)) { valuesC.Rows.Add(values.Rows[myGridSelectedIndex].ItemArray); myMessageBox mm = new myMessageBox("Approved Succesfully", "Success", "OK", 0); mm.ShowDialog(); //MessageBox.Show("Approved Succefully", "Success", MessageBoxButton.OK, MessageBoxImage.Information); values = DBManager.selectForMaintainanceApproval(); approve_maintainance_request.ItemsSource = values.AsDataView(); maintainanceID = ""; } else { myMessageBox mm = new myMessageBox("Error Occured", "Error", "OK", 1); mm.ShowDialog(); // MessageBox.Show("Error Occured", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void cancelRequest_Click(object sender, RoutedEventArgs e) { try { if (selected_allocation_id != "") { string query = "UPDATE `allocation_request` SET `request_status`='4' WHERE id='" + selected_allocation_id + "'"; DBManager.UpdateDatabaseQuery(query); } } catch (Exception ex) { } }
private void addWorkorder_Click(object sender, RoutedEventArgs e) { try { if (sparePartBox.Text != null) { sparePart = sparePartBox.Text; } if (laboreBox.Text != null) { laborC = laboreBox.Text; } if (PriorityBox.SelectedValue != null) { priorityV = PriorityBox.SelectedValue.ToString(); } if (StatusBox.SelectedValue != null) { statuM = StatusBox.SelectedValue.ToString(); } if (completionDateBox.SelectedDate != null) { completionD = completionDateBox.SelectedDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); } string query = "UPDATE maintainance_request SET request_status='2',em_approved='1', work_order_Id='" + workOrderID + "',maintainance_sparepart_cost='" + sparePart + "',maintainance_labor_cost='" + laborC + "',maintainance_priority='" + priorityV + "',maintainance_status='" + statuM + "',maintainance_completion_date='" + completionD + "' WHERE maintainance_id='" + maintainanceID + "'"; if (DBManager.UpdateDatabaseQuery(query)) { query = ""; if (StatusBox.SelectedValue.ToString() == "3") { query = "UPDATE equipment_list SET equipment_list.current_status = '2' WHERE equipment_list.equipment_id = '" + equipmentID + "'"; } else { query = "UPDATE equipment_list SET equipment_list.current_status = '3' WHERE equipment_list.equipment_id = '" + equipmentID + "'"; } if (DBManager.UpdateDatabaseQuery(query)) { myMessageBox mm = new myMessageBox("Successfully updated", "Success", "OK", 0); mm.ShowDialog(); // MessageBox.Show("Succesfully Updated", "Success", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } } catch { } }
private void insertButton_Click(object sender, RoutedEventArgs e) { int i = 0; string datas = ""; string updateQueries = ""; try { foreach (DataRow row in values.Rows) { if (i == 0) { datas = "('" + row[0].ToString() + "','" + Convert.ToDateTime(row[1].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[2].ToString() + "')"; } else { datas = datas + ",('" + row[0].ToString() + "','" + Convert.ToDateTime(row[1].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[2].ToString() + "')"; } updateQueries += "UPDATE equipment_list SET equipment_list.current_status = '7' WHERE equipment_list.equipment_id = '" + row[0].ToString() + "';\n"; i++; } string res = DBManager.InsertIntoServiceRequest(datas); if (!res.Contains("Success")) { myMessageBox mm = new myMessageBox("Invalid Data Found. Check your Data!", "Error", "OK", 1); mm.ShowDialog(); // MessageBox.Show("Invalid Data Type Found. Check your data again", "Error Occured", MessageBoxButton.OK, MessageBoxImage.Error); } else { DBManager.UpdateDatabaseQuery(updateQueries); myMessageBox mm = new myMessageBox("Data Added Succefully", "Success", "OK", 0); mm.ShowDialog(); // MessageBox.Show("Data Added Succesfully", "Successfully Added", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } catch (Exception ex) { // } }
private void update_button_Click(object sender, RoutedEventArgs e) { try { string query = "UPDATE equipment_list SET depreciated_cost='" + depreciated_value_box.Text + "' WHERE equipment_id='" + equipmentID_box.Text + "'"; if (DBManager.UpdateDatabaseQuery(query)) { myMessageBox mm = new myMessageBox("Updated Succefully", "Success", "Ok", 0); mm.ShowDialog(); } else { myMessageBox mm = new myMessageBox("Error Occured When Updating. The supplied equipment id doesnt Exist", "Error", "Ok", 1); mm.ShowDialog(); } } catch (Exception ex) { } }
private void approveButton_Click(object sender, RoutedEventArgs e) { try { if ((equipmentID != "") && (allocationID != "") && allocateToID != "") { string query = "UPDATE allocate_item SET allocation_date='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',om_approved='1' WHERE id='" + allocationID + "'"; string query2 = "UPDATE equipment_list SET current_Location='" + allocateToID + "' WHERE equipment_id='" + equipmentID + "'"; int allocatedNo = Convert.ToInt32(DBManager.selectAllocatedNumber(requestID).Rows[0][0].ToString()); string query3 = "UPDATE allocation_request SET allocated_item_no=" + (allocatedNo + 1) + " WHERE id='" + requestID + "'"; if (DBManager.UpdateDatabaseQuery(query) && DBManager.UpdateDatabaseQuery(query2) && DBManager.UpdateDatabaseQuery(query3)) { valuesC.Rows.Add(values.Rows[myGridSelectedIndex].ItemArray); //approved_Items.Columns.Add(approve_allocation_request.) myMessageBox mm = new myMessageBox("Approved Successfully", "Success", "OK", 0); mm.ShowDialog(); // MessageBox.Show("Approved Succefully", "Success", MessageBoxButton.OK, MessageBoxImage.Information); values = DBManager.selectForAllocationApproval(); approve_allocation_request.ItemsSource = values.AsDataView(); allocationID = ""; allocateToID = ""; equipmentID = ""; } else { myMessageBox mm = new myMessageBox("Error Occured", "Error", "OK", 1); mm.ShowDialog(); // MessageBox.Show("Error Occured", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } } catch { } }