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") + "','" + Convert.ToDateTime(row[2].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[3].ToString() + "','" + row[4].ToString() + "')";
}
else
{
datas = datas + ",('" + row[0].ToString() + "','" + Convert.ToDateTime(row[1].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + Convert.ToDateTime(row[2].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "','" + row[3].ToString() + "','" + row[4].ToString() + "')";
}
updateQueries += "UPDATE equipment_list SET equipment_list.current_status = '2' WHERE equipment_list.equipment_id = '" + row[0].ToString() + "';\n";
i++;
}
string res = DBManager.InsertIntoMaintainanceRequest(datas);
if (!res.Contains("Success"))
{
myMessageBox mm = new myMessageBox("Invalid Data Type found. Check your data again.", "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 Successfully", "Success", "OK", 0);
mm.ShowDialog();
//MessageBox.Show("Data Added Succesfully", "Successfully Added", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
}
catch (Exception ex)
{
//
}
}
