public Equipment()
{
currentLocation = new Logistics();
groups = new List<Group>();
po = new PurchaseOrder();
licenses = new List<License>();
warranties = new List<Warranty>();
}
public Computer()
{
monitors = new List<Monitor>();
po = new PurchaseOrder();
groups = new List<Group>();
logistics = new List<Logistics>();
currentLocation = new Logistics();
licenses = new List<License>();
warranties = new List<Warranty>();
transfer = new Transfer();
}
protected void btnApplyLogisticsUpdates_Click(object sender, EventArgs e)
{
List<int> ids = new List<int>();
ids = getIDs();
Logistics logs = new Logistics();
logs.Building = ddlBuilding.Text;
logs.Room = txtBoxRoomNumber.Text;
logs.PrimaryUser = txtBoxPrimaryUser.Text;
logs.Name = txtBoxName.Text;
lblLogisticsMessage.Text = Logistics.massUpdateLogisticsEquipment(ids, logs);
lblLogisticsMessage.Visible = true;
btnClearLogistics.Visible = true;
}
public static string massUpdateLogisticsComputer(List<int> ids, Logistics logs)
{
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;
dbCmd.Connection = dbConn;
for (int i = 0; i < ids.Count; i++)
{
int invID = ids[i];
Computer comp = new Computer();
comp = ComputerDA.getComputer(dbCmd, invID);
LogisticsDA.removeLogistics(dbCmd, invID);
try
{
string sqlCommand = "INSERT INTO Logistics (InvID, Building, Room, PrimaryUser, Name, StartDate, Status) VALUES " +
"(@InvID, @Building, @Room, @PrimaryUser, @Name, @StartDate, @Status)";
dbCmd.CommandText = sqlCommand;
if (logs.Building == "")
{
dbCmd.Parameters.AddWithValue("Building", comp.CurrentLocation.Building);
}
else
{
dbCmd.Parameters.AddWithValue("Building", logs.Building);
}
if (logs.Room == "")
{
dbCmd.Parameters.AddWithValue("Room", comp.CurrentLocation.Room);
}
else
{
dbCmd.Parameters.AddWithValue("Room", logs.Room);
}
if (logs.PrimaryUser == "")
{
dbCmd.Parameters.AddWithValue("PrimaryUser", comp.CurrentLocation.PrimaryUser);
}
else
{
dbCmd.Parameters.AddWithValue("PrimaryUser", logs.PrimaryUser);
}
if (logs.Name == "")
{
dbCmd.Parameters.AddWithValue("Name", comp.CurrentLocation.Name);
}
else
{
dbCmd.Parameters.AddWithValue("Name", logs.Name);
}
dbCmd.Parameters.AddWithValue("InvID", invID);
dbCmd.Parameters.AddWithValue("StartDate", DateTime.Now.ToShortDateString());
dbCmd.Parameters.AddWithValue("Status", "Active");
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
message.Append("Logistics uppdated successfully for computer with serial number " + comp.SerialNo + "!<bR>");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString());
transaction.Rollback();
}
}
transaction.Commit();
dbConn.Close();
return message.ToString();
}
public static string massUpdateLogisticsEquipment(List<int> ids, Logistics logs)
{
return LogisticsDA.massUpdateLogisticsEquipment(ids, logs);
}
public static string massUpdateLogisticsComputer(List<int> ids, Logistics logs)
{
return LogisticsDA.massUpdateLogisticsComputer(ids, logs);
}
