public static string addMassMaintenanceComputer(List<int> ids, Maintenance maint)
{
SqlConnection dbConn;
string sConnection;
SqlCommand dbCmd;
SqlTransaction transaction;
StringBuilder message = new StringBuilder();
sConnection = GlobalVars.ConnectionString;
dbConn = new SqlConnection(sConnection);
dbConn.Open();
dbCmd = dbConn.CreateCommand();
transaction = dbConn.BeginTransaction("Transaction");
dbCmd.Transaction = transaction;
try
{
for (int i = 0; i < ids.Count; i++)
{
int invID = ids[i];
string sqlCommand = "INSERT INTO Maintenance (InvID, Date, Maintenance) " +
"VALUES (@InvID, @Date, @Maintenance)";
dbCmd.CommandText = sqlCommand;
dbCmd.Parameters.AddWithValue("InvID", invID);
dbCmd.Parameters.AddWithValue("Date", maint.Date);
dbCmd.Parameters.AddWithValue("Maintenance", maint.Description);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
}
transaction.Commit();
dbConn.Close();
message.Append("Maintenance added successfully!<bR>");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString() + "<bR>");
transaction.Rollback();
}
return message.ToString();
}
protected void btnInsertMaintenance_Click(object sender, EventArgs e)
{
List<int> ids = new List<int>();
ids = getIDs();
List<Maintenance> newMaintenance = new List<Maintenance>();
Maintenance maint = new Maintenance();
maint.Date = txtboxDate.Text;
maint.Description = txtBoxMaintenance.Text;
lblMaintenanceMessage.Visible = true;
lblMaintenanceMessage.Text = Maintenance.addMassMaintenanceEquipment(ids, maint);
btnMaintenanceMessage_ModalPopupExtender.Show();
}
public static string addMassMaintenanceEquipment(List<int> ids, Maintenance maint)
{
return MaintenanceDA.addMassMaintenanceEquipment(ids, maint);
}
public static string addMassMaintenanceComputer(List<int> ids, Maintenance maint)
{
return MaintenanceDA.addMassMaintenanceComputer(ids, maint);
}
public static string addMaintenance(Maintenance maint)
{
return MaintenanceDA.addMaintenance(maint);
}
protected void btnInsertMaintenance_Click(object sender, EventArgs e)
{
Maintenance maint = new Maintenance();
maint.InvID = Convert.ToInt32(Session["CurrentEquipment"]);
maint.Date = txtBoxMaintDate.Text;
maint.Description = txtBoxMaintDescription.Text;
lblMaintenanceMessage.Text = Maintenance.addMaintenance(maint);
if (lblMaintenanceMessage.Text == "Maintenance added successfully<bR>")
{
GridView2.Visible = true;
panelAddMaintenance.Visible = false;
btnAddMaintenance.Visible = true;
GridView2.DataBind();
}
}
