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); }