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
{
}
}
