public static void addLogistics(SqlCommand cmd, Equipment equip) { String sqlCommand = "INSERT INTO Logistics (InvID, Building, Room, PrimaryUser, Name, StartDate, Status) " + "VALUES (@InvID, @Building, @Room, @PrimaryUser, @Name, @StartDate, @Status)"; cmd.CommandText = sqlCommand; cmd.Parameters.AddWithValue("InvID", equip.InvID); cmd.Parameters.AddWithValue("Building", equip.CurrentLocation.Building); cmd.Parameters.AddWithValue("Room", equip.CurrentLocation.Room); cmd.Parameters.AddWithValue("PrimaryUser", equip.CurrentLocation.PrimaryUser); cmd.Parameters.AddWithValue("Name", equip.CurrentLocation.Name); cmd.Parameters.AddWithValue("StartDate", DateTime.Now.ToShortDateString()); cmd.Parameters.AddWithValue("Status", "Active"); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); }
public static Boolean equipmentExist(string serialNo) { SqlConnection dbConn; SqlCommand dbCmd; SqlDataReader dbReader; string sConnection; string sql; sConnection = GlobalVars.ConnectionString; dbConn = new SqlConnection(sConnection); dbConn.Open(); sql = "SELECT SerialNo FROM Inventory, Equipment Where Inventory.InvID = Equipment.InvID AND SerialNo = @SerialNo"; dbCmd = new SqlCommand(); dbCmd.CommandText = sql; dbCmd.Parameters.AddWithValue("@SerialNo", serialNo); dbCmd.Connection = dbConn; dbReader = dbCmd.ExecuteReader(); List<Equipment> equipment = new List<Equipment>(); while (dbReader.Read()) { Equipment equip = new Equipment(); equip.SerialNo = dbReader["SerialNo"].ToString(); equipment.Add(equip); } dbReader.Close(); dbCmd.Parameters.Clear(); if (equipment.Count > 0) return true; else return false; }
public static string updateEquipment(Equipment oEquip, Equipment equip) { return EquipmentDA.updateEquipment(oEquip, equip); }
protected void btnUpdateEquipment_Click(object sender, EventArgs e) { List<Equipment> equipment = new List<Equipment>(); for (int i = 0; i < lstBoxSerialNos.Items.Count ; i++) { Equipment equip = new Equipment(); equip.InvID = Convert.ToInt32(lstBoxSerialNos.Items[i].Value); equip.SerialNo = lstBoxSerialNos.Items[i].Text; equip.SMSUtag = txtBoxSMSUTag.Text; equip.Manufacturer = ddlManufacturer.Text; equip.Model = txtBoxModel.Text; equip.EquipmentType = ddlType.Text; equip.Status = ddlStatus.Text; if (txtBoxPurchasePrice.Text != "") equip.PurchasePrice = Convert.ToDouble(txtBoxPurchasePrice.Text); equip.Connectivity = txtBoxConnectivity.Text; equip.NetworkCapable = ddlNetworkCapable.Text; equip.Other = txtBoxOther.Text; equip.Notes = txtBoxNotes.Text; equip.PhysicalAddress = txtBoxPhysicalAddress.Text.ToUpper(); if (ddlPONO.Visible == true) { equip.PO.ID = Convert.ToInt32(ddlPONO.SelectedValue); } else { equip.PO.ID = null; } equipment.Add(equip); } lblMessage.Text = Equipment.updateEquipment(equipment); lblMessage.Visible = true; btnPopUpExtender_ModalPopupExtender.Show(); }
protected void btnSelectGroup_Click(object sender, EventArgs e) { foreach (int i in lstBoxGroups.GetSelectedIndices()) { Group selectedGroup = new Group(); selectedGroup = Group.getGroupEquipment(lstBoxGroups.Items[i].Text); for (int j = 0; j < selectedGroup.Equipment.Count; j++) { Equipment equip = new Equipment(); equip = (Equipment)selectedGroup.Equipment[j]; //txtBoxServiceTags.Text += comp.SerialNo + "\r\n"; bool existsLB = false; for (int k = 0; k < lstBoxSerialNos.Items.Count; k++) { if (lstBoxSerialNos.Items[k].Text == equip.SerialNo.ToUpper()) { existsLB = true; } } if (existsLB == false) { ListItem li = new ListItem(equip.SerialNo.ToUpper(), equip.InvID.ToString()); lstBoxSerialNos.Items.Add(li); lstBoxSerialNos.SelectedValue = li.Value; } } } }
public static string massUpdateLogisticsEquipment(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]; Equipment equip = new Equipment(); equip = EquipmentDA.getEquipment(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", equip.CurrentLocation.Building); } else { dbCmd.Parameters.AddWithValue("Building", logs.Building); } if (logs.Room == "") { dbCmd.Parameters.AddWithValue("Room", equip.CurrentLocation.Room); } else { dbCmd.Parameters.AddWithValue("Room", logs.Room); } if (logs.PrimaryUser == "") { dbCmd.Parameters.AddWithValue("PrimaryUser", equip.CurrentLocation.PrimaryUser); } else { dbCmd.Parameters.AddWithValue("PrimaryUser", logs.PrimaryUser); } if (logs.Name == "") { dbCmd.Parameters.AddWithValue("Name", equip.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 " + equip.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 updateEquipment(List<Equipment> equipment) { 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; try { for (int i = 0; i < equipment.Count; i++) { Equipment equip = new Equipment(); equip = (Equipment)equipment[i]; Equipment oEquip = EquipmentDA.getEquipment(dbCmd, equip.SerialNo); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("UPDATE Inventory SET "); if (equip.SMSUtag != "") { sqlCommand.Append("SMSUtag = @SMSUtag,"); dbCmd.Parameters.AddWithValue("SMSUtag", equip.SMSUtag); } if (equip.Manufacturer != "") { sqlCommand.Append("Manufacturer = @Manufacturer,"); dbCmd.Parameters.AddWithValue("Manufacturer", equip.Manufacturer); } if (equip.Model != "") { sqlCommand.Append("Model = @Model,"); dbCmd.Parameters.AddWithValue("Model", equip.Model); } double? price = equip.PurchasePrice; if (price.HasValue) { sqlCommand.Append("PurchasePrice = @PurchasePrice,"); dbCmd.Parameters.AddWithValue("PurchasePrice", equip.PurchasePrice); } if (equip.Notes != "") { sqlCommand.Append("Notes = @Notes,"); dbCmd.Parameters.AddWithValue("Notes", equip.Notes); } if (equip.PhysicalAddress!= "") { sqlCommand.Append("PhysicalAddress = @PhysicalAddress,"); dbCmd.Parameters.AddWithValue("PhysicalAddress", equip.PhysicalAddress); } if (equip.Status != "") { if (oEquip.Status != "Transferred") { sqlCommand.Append("Status = @Status,"); dbCmd.Parameters.AddWithValue("Status", equip.Status); } } sqlCommand.Remove((sqlCommand.Length - 1), 1); sqlCommand.Append(" WHERE InvID = @InvID"); dbCmd.Parameters.AddWithValue("InvID", oEquip.InvID); dbCmd.CommandText = sqlCommand.ToString(); if (dbCmd.CommandText != "UPDATE Inventory SET WHERE InvID = @InvID") { dbCmd.ExecuteNonQuery(); } dbCmd.Parameters.Clear(); sqlCommand = new StringBuilder(); sqlCommand.Append("UPDATE Equipment SET "); if (equip.EquipmentType != "") { sqlCommand.Append("EquipmentType = @EquipmentType,"); dbCmd.Parameters.AddWithValue("EquipmentType", equip.EquipmentType); } if (equip.Connectivity != "") { sqlCommand.Append("Connectivity = @Connectivity,"); dbCmd.Parameters.AddWithValue("Connectivity", equip.Connectivity); } if (equip.NetworkCapable != "") { sqlCommand.Append("NetworkCapable = @NetworkCapable,"); dbCmd.Parameters.AddWithValue("NetworkCapable", equip.NetworkCapable); } if (equip.Other != "") { sqlCommand.Append("Other = @Other,"); dbCmd.Parameters.AddWithValue("Other", equip.Other); } sqlCommand.Remove((sqlCommand.Length - 1), 1); sqlCommand.Append(" WHERE InvID = @InvID"); dbCmd.Parameters.AddWithValue("InvID", oEquip.InvID); dbCmd.CommandText = sqlCommand.ToString(); if (dbCmd.CommandText != "UPDATE Equipment SET WHERE InvID = @InvID") { dbCmd.ExecuteNonQuery(); } dbCmd.Parameters.Clear(); if (equip.PO.ID != null) { PODA.deleteLink(dbCmd, oEquip.InvID); PODA.addLink(dbCmd, oEquip.InvID, equip.PO.ID); } message.Append("Equipment with Service Tag " + equip.SerialNo + " updated successfully!<bR>"); } transaction.Commit(); dbConn.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); message.Clear(); message.Append(ex.ToString() + "<bR>"); transaction.Rollback(); } return message.ToString(); }
public static string updateEquipment(Equipment oEquip, Equipment equip) { 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; if (oEquip.SerialNo.ToUpper() != equip.SerialNo.ToUpper() && EquipmentDA.equipmentExist(dbCmd, equip.SerialNo)) { message.Append("That serial number is already in use. Please try again.<bR>"); } else { try { String sqlCommand = "UPDATE Inventory SET SMSUTag = @SMSUTag, SerialNo = @SerialNo, Manufacturer = @Manufacturer, Model = @Model, PurchasePrice = @PurchasePrice, " + "Notes = @Notes, Status = @Status, PhysicalAddress = @PhysicalAddress WHERE InvID = @InvID"; dbCmd.CommandText = sqlCommand; dbCmd.Parameters.AddWithValue("SMSUTag", equip.SMSUtag); dbCmd.Parameters.AddWithValue("SerialNo", equip.SerialNo); dbCmd.Parameters.AddWithValue("Manufacturer", equip.Manufacturer); dbCmd.Parameters.AddWithValue("Model", equip.Model); dbCmd.Parameters.AddWithValue("PurchasePrice", equip.PurchasePrice); dbCmd.Parameters.AddWithValue("Notes", equip.Notes); dbCmd.Parameters.AddWithValue("PhysicalAddress", equip.PhysicalAddress); if (oEquip.Status != "Transferred") { dbCmd.Parameters.AddWithValue("Status", equip.Status); } else { dbCmd.Parameters.AddWithValue("Status", oEquip.Status); } dbCmd.Parameters.AddWithValue("InvID", equip.InvID); dbCmd.ExecuteNonQuery(); dbCmd.Parameters.Clear(); sqlCommand = "UPDATE Equipment SET EquipmentType = @EquipmentType, Connectivity = @Connectivity, NetworkCapable = @NetworkCapable, Other = @Other WHERE " + "InvID = @InvID"; dbCmd.Parameters.AddWithValue("InvID", equip.InvID); dbCmd.Parameters.AddWithValue("EquipmentType", equip.EquipmentType); dbCmd.Parameters.AddWithValue("Connectivity", equip.Connectivity); dbCmd.Parameters.AddWithValue("NetworkCapable", equip.NetworkCapable); dbCmd.Parameters.AddWithValue("Other", equip.Other); dbCmd.CommandText = sqlCommand; dbCmd.ExecuteNonQuery(); dbCmd.Parameters.Clear(); if (equip.CurrentLocation.Name == oEquip.CurrentLocation.Name && equip.CurrentLocation.Building == oEquip.CurrentLocation.Building && equip.CurrentLocation.Room == oEquip.CurrentLocation.Room && equip.CurrentLocation.PrimaryUser == oEquip.CurrentLocation.PrimaryUser) { //do nothing } else { LogisticsDA.removeLogistics(dbCmd, equip.InvID); LogisticsDA.addLogistics(dbCmd, equip); } if (oEquip.PO.ID != equip.PO.ID) { PODA.deleteLink(dbCmd, equip.InvID); PODA.addLink(dbCmd, equip.InvID, equip.PO.ID); } transaction.Commit(); dbConn.Close(); message.Append("Update Successful!<bR>"); } catch (Exception ex) { Console.WriteLine(ex.ToString()); message.Append(ex.ToString()); transaction.Rollback(); } } return message.ToString(); }
public static Equipment getEquipment(int invID) { SqlConnection dbConn; string sConnection; SqlCommand dbCmd; SqlTransaction transaction; SqlDataReader dbReader; sConnection = GlobalVars.ConnectionString; dbConn = new SqlConnection(sConnection); dbConn.Open(); dbCmd = dbConn.CreateCommand(); transaction = dbConn.BeginTransaction("Transaction"); dbCmd.Transaction = transaction; dbCmd.Connection = dbConn; try { string sql = "SELECT SMSUtag, SerialNo, Manufacturer, Model, PurchasePrice, Notes, PhysicalAddress, EquipmentType, Connectivity, "+ "NetworkCapable, Other, Inventory.Status, Building, Room, PrimaryUser, Name FROM Inventory, Equipment, Logistics WHERE Inventory.InvID = Equipment.InvID AND " + "Inventory.InvID = Logistics.InvID AND Inventory.InvID = @InvID AND Logistics.Status = @Status"; dbCmd.CommandText = sql; dbCmd.Parameters.AddWithValue("InvID", invID); dbCmd.Parameters.AddWithValue("Status", "Active"); dbReader = dbCmd.ExecuteReader(); Equipment equip = new Equipment(); while (dbReader.Read()) { equip.InvID = Convert.ToInt32(invID); equip.SMSUtag = dbReader["SMSUtag"].ToString(); equip.SerialNo = dbReader["SerialNo"].ToString(); equip.Manufacturer = dbReader["Manufacturer"].ToString(); equip.Model = dbReader["Model"].ToString(); equip.PurchasePrice = Convert.ToDouble(dbReader["PurchasePrice"]); equip.Notes = dbReader["Notes"].ToString(); equip.PhysicalAddress = dbReader["PhysicalAddress"].ToString(); equip.EquipmentType = dbReader["EquipmentType"].ToString(); equip.Connectivity = dbReader["Connectivity"].ToString(); equip.NetworkCapable = dbReader["NetworkCapable"].ToString(); equip.Other = dbReader["Other"].ToString(); equip.Status = dbReader["Status"].ToString(); equip.CurrentLocation.Building = dbReader["Building"].ToString(); equip.CurrentLocation.Room = dbReader["Room"].ToString(); equip.CurrentLocation.PrimaryUser = dbReader["PrimaryUser"].ToString(); equip.CurrentLocation.Name = dbReader["Name"].ToString(); } dbReader.Close(); dbCmd.Parameters.Clear(); if (equip.Status == "Transferred") { equip.Transfer = Transfer.getTransfer(dbCmd, invID); } equip.PO = PODA.getPODetails(dbCmd, equip.InvID); equip.Groups = GroupDA.getGroups(dbCmd, equip.InvID); dbReader.Close(); transaction.Commit(); dbConn.Close(); return equip; } catch (Exception ex) { Console.WriteLine(ex.ToString()); transaction.Rollback(); dbConn.Close(); return null; } }
public static Equipment getEquipment(SqlCommand cmd, int InvID) { SqlDataReader dbReader; string sql = "SELECT SMSUtag, SerialNo, Manufacturer, Model, PurchasePrice, Notes, EquipmentType, Connectivity, NetworkCapable, "+ "Other, Inventory.Status, Building, Room, PrimaryUser, Name FROM Inventory, Equipment, Logistics WHERE Inventory.InvID = Equipment.InvID AND " + "Inventory.InvID = Logistics.InvID AND Inventory.InvID = @InvID AND Logistics.Status = @Status"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("InvID", InvID); cmd.Parameters.AddWithValue("Status", "Active"); dbReader = cmd.ExecuteReader(); Equipment equip = new Equipment(); while (dbReader.Read()) { equip.InvID = InvID; equip.SMSUtag = dbReader["SMSUtag"].ToString(); equip.SerialNo = dbReader["SerialNo"].ToString(); equip.Manufacturer = dbReader["Manufacturer"].ToString(); equip.Model = dbReader["Model"].ToString(); equip.PurchasePrice = Convert.ToDouble(dbReader["PurchasePrice"]); equip.Notes = dbReader["Notes"].ToString(); equip.EquipmentType = dbReader["EquipmentType"].ToString(); equip.Connectivity = dbReader["Connectivity"].ToString(); equip.NetworkCapable = dbReader["NetworkCapable"].ToString(); equip.Other = dbReader["Other"].ToString(); equip.Status = dbReader["Status"].ToString(); equip.CurrentLocation.Building = dbReader["Building"].ToString(); equip.CurrentLocation.Room = dbReader["Room"].ToString(); equip.CurrentLocation.PrimaryUser = dbReader["PrimaryUser"].ToString(); equip.CurrentLocation.Name = dbReader["Name"].ToString(); } dbReader.Close(); cmd.Parameters.Clear(); equip.PO = PODA.getPODetails(cmd, equip.InvID); equip.Groups = GroupDA.getGroups(cmd, equip.InvID); dbReader.Close(); return equip; }
protected void btnAddEquipment_Click(object sender, EventArgs e) { List<Equipment> equipList = new List<Equipment>(); List<Group> groupList = new List<Group>(); for (int i = 0; i < chkBoxListGroups1.Items.Count; i++) { if (chkBoxListGroups1.Items[i].Selected == true) { Group group = new Group(); group.ID = Convert.ToInt32(chkBoxListGroups1.Items[i].Value); group.Name = chkBoxListGroups1.Items[i].Text; groupList.Add(group); } } for (int i = 0; i < chkBoxListGroups2.Items.Count; i++) { if (chkBoxListGroups2.Items[i].Selected == true) { Group group = new Group(); group.ID = Convert.ToInt32(chkBoxListGroups2.Items[i].Value); group.Name = chkBoxListGroups2.Items[i].Text; groupList.Add(group); } } for (int i = 0; i < chkBoxListGroups3.Items.Count; i++) { if (chkBoxListGroups3.Items[i].Selected == true) { Group group = new Group(); group.ID = Convert.ToInt32(chkBoxListGroups3.Items[i].Value); group.Name = chkBoxListGroups3.Items[i].Text; groupList.Add(group); } } for (int i = 0; i < chkBoxListGroups4.Items.Count; i++) { if (chkBoxListGroups4.Items[i].Selected == true) { Group group = new Group(); group.ID = Convert.ToInt32(chkBoxListGroups4.Items[i].Value); group.Name = chkBoxListGroups4.Items[i].Text; groupList.Add(group); } } for (int i = 0; i < lstBoxSerialNos.Items.Count; i++) { Equipment equip = new Equipment(); equip.SerialNo = lstBoxSerialNos.Items[i].Text; equip.SMSUtag = txtBoxSMSUTag.Text; equip.EquipmentType = ddlType.Text; equip.Manufacturer = ddlManufacturer.Text; equip.Status = ddlStatus.Text; equip.Model = txtBoxModel.Text; if (txtBoxPurchasePrice.Text == "") { equip.PurchasePrice = 0; } else { equip.PurchasePrice = Convert.ToDouble(txtBoxPurchasePrice.Text); } equip.Connectivity = txtBoxConnectivity.Text; equip.Other = txtBoxOther.Text; equip.Notes = txtBoxNotes.Text; equip.CurrentLocation.Building = ddlBuilding.Text; equip.CurrentLocation.Room = txtBoxRoomNumber.Text; equip.CurrentLocation.PrimaryUser = txtBoxPrimaryUser.Text; equip.CurrentLocation.Name = txtBoxName.Text; equip.NetworkCapable = ddlNetworkCapable.Text; equip.PhysicalAddress = txtBoxPhysicalAddress.Text.ToUpper(); equip.PO.ID = Convert.ToInt32(ddlPONO.SelectedValue); equip.Groups = groupList; equipList.Add(equip); for (int j = 0; j < lstBoxLicenses.Items.Count; j++) { License lic = new License(); lic.ID = Convert.ToInt32(lstBoxLicenses.Items[j].Value); equip.Licenses.Add(lic); } equip.Warranties = (List<Warranty>)Session["Warranties"]; } lblMessage.Text = Equipment.saveEquipment(equipList); if (lblMessage.Text == "Operation successfull!<bR>") { lstBoxSerialNos.Items.Clear(); } lblMessage.Visible = true; btnClearMessage.Visible = true; btnPopUpExtender_ModalPopupExtender.Show(); }
public static Group getGroupEquipment(string groupName) { SqlConnection dbConn; string sConnection; SqlCommand dbCmd; SqlTransaction transaction; SqlDataReader dbReader; sConnection = GlobalVars.ConnectionString; dbConn = new SqlConnection(sConnection); dbConn.Open(); dbCmd = dbConn.CreateCommand(); transaction = dbConn.BeginTransaction("Transaction"); dbCmd.Transaction = transaction; try { int groupID = GroupDA.getGroupID(dbCmd, groupName); string sql = "SELECT SerialNo, Inventory.InvID FROM Inventory, GroupInventory WHERE GroupInventory.InvID = Inventory.InvID AND GroupInventory.GroupID = @GroupID"; dbCmd.CommandText = sql; dbCmd.Parameters.AddWithValue("GroupID", groupID); dbReader = dbCmd.ExecuteReader(); Group group = new Group(); while (dbReader.Read()) { Equipment equip = new Equipment(); equip.SerialNo = dbReader["SerialNo"].ToString(); equip.InvID = Convert.ToInt32(dbReader["InvID"]); group.Equipment.Add(equip); } dbReader.Close(); dbCmd.Parameters.Clear(); transaction.Commit(); dbConn.Close(); return group; } catch (Exception ex) { Console.WriteLine(ex.ToString()); transaction.Rollback(); return null; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int invID = 0; string invIDstr = Request.QueryString["id"]; try { invID = Convert.ToInt32(invIDstr); Session["CurrentEquipment"] = invID; } catch (System.FormatException ex) { Session["Exception"] = "Input is in improper format.<bR><bR>" + ex.ToString(); Response.Redirect("~/Error.aspx"); } catch (Exception ex) { Session["Exception"] = ex.ToString(); Response.Redirect("~/Error.aspx"); } Equipment equip = new Equipment(); equip = Equipment.getEquipment(invID); if (equip.Status == "Transferred") { pnlTransferInfo.Visible = true; lblTransferDate.Text = equip.Transfer.Date; lblTransferTo.Text = equip.Transfer.Where; lblTransferNotes.Text = equip.Transfer.Notes; Session["CurrentTransfer"] = equip.Transfer.ID; } txtBoxSMSUTag.Text = equip.SMSUtag; ddlType.Text = equip.EquipmentType; bool containsManufacturer = false; ddlManufacturer.DataBind(); for (int i = 0; i < ddlManufacturer.Items.Count; i++) { if (ddlManufacturer.Items[i].Text == equip.Manufacturer) { containsManufacturer = true; } } if (containsManufacturer == false) { ddlManufacturer.Items.Add(equip.Manufacturer); ddlManufacturer.Text = equip.Manufacturer; } else { ddlManufacturer.Text = equip.Manufacturer; } if (equip.Status != "Transferred") { ddlStatus.Text = equip.Status; } else { ddlStatus.Items.Add("Transferred"); ddlStatus.Text = "Transferred"; ddlStatus.Enabled = false; } txtBoxModel.Text = equip.Model; txtBoxSerialNo.Text = equip.SerialNo; ddlBuilding.DataBind(); bool containsBuilding = false; for (int i = 0; i < ddlBuilding.Items.Count; i++) { if (ddlBuilding.Items[i].Text == equip.CurrentLocation.Building) { containsBuilding = true; } } if (containsBuilding == false) { ddlBuilding.Items.Add(equip.CurrentLocation.Building); ddlBuilding.Text = equip.CurrentLocation.Building; } else { ddlBuilding.Text = equip.CurrentLocation.Building; } txtBoxRoomNumber.Text = equip.CurrentLocation.Room; txtBoxPrimaryUser.Text = equip.CurrentLocation.PrimaryUser; txtBoxName.Text = equip.CurrentLocation.Name; txtBoxPurchasePrice.Text = equip.PurchasePrice.ToString(); ddlPONO.SelectedValue = equip.PO.ID.ToString(); txtBoxConnectivity.Text = equip.Connectivity; ddlNetworkCapable.Text = equip.NetworkCapable; txtBoxOther.Text = equip.Other; txtBoxPhysicalAddress.Text = equip.PhysicalAddress; txtBoxNotes.Text = equip.Notes; txtBoxMaintDate.Text = DateTime.Now.ToShortDateString(); List<Group> groups = new List<Group>(); groups = Group.getAllEquipmentGroups(); int nextGroup = 1; //populates chkBoxList for (int i = 0; i < groups.Count; i++) { Group group = new Group(); group = (Group)groups[i]; if (nextGroup == 1) { chkBoxLstGroups1.Items.Add(group.Name); nextGroup = 2; for (int j = 0; j < equip.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)equip.Groups[j]; if (compGroup.Name == group.Name) { chkBoxLstGroups1.Items[chkBoxLstGroups1.Items.Count - 1].Selected = true; } } } else if (nextGroup == 2) { chkBoxLstGroups2.Items.Add(group.Name); nextGroup = 3; for (int j = 0; j < equip.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)equip.Groups[j]; if (compGroup.Name == group.Name) { chkBoxLstGroups2.Items[chkBoxLstGroups1.Items.Count - 1].Selected = true; } } } else if (nextGroup == 3) { chkBoxLstGroups3.Items.Add(group.Name); nextGroup = 4; for (int j = 0; j < equip.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)equip.Groups[j]; if (compGroup.Name == group.Name) { chkBoxLstGroups3.Items[chkBoxLstGroups1.Items.Count - 1].Selected = true; } } } else if (nextGroup == 4) { chkBoxLstGroups4.Items.Add(group.Name); nextGroup = 1; for (int j = 0; j < equip.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)equip.Groups[j]; if (compGroup.Name == group.Name) { chkBoxLstGroups4.Items[chkBoxLstGroups1.Items.Count - 1].Selected = true; } } } if (Session["Authenticated"].ToString() != "True") { panelLicenses.Visible = false; } } if (equip.Status == "Transferred") { btnEditGroups.Enabled = false; btnAddLicense.Enabled = false; btnRemoveSelectedLicense.Enabled = false; btnAddMaintenance.Enabled = false; btnAddWarranty.Enabled = false; btnUpdateEquipment.Enabled = false; GridView4.Enabled = false; } } }
protected void btnUpdateEquipment_Click(object sender, EventArgs e) { Equipment equip = new Equipment(); Equipment oEquip = new Equipment(); oEquip = Equipment.getEquipment(Convert.ToInt32(Session["CurrentEquipment"])); equip.InvID = Convert.ToInt32(Session["CurrentEquipment"]); equip.SMSUtag = txtBoxSMSUTag.Text; equip.EquipmentType = ddlType.Text; equip.Manufacturer = ddlManufacturer.Text; if (ddlStatus.Enabled == true) { equip.Status = ddlStatus.Text; } else { equip.Status = null; } equip.Model = txtBoxModel.Text; equip.SerialNo = txtBoxSerialNo.Text.ToUpper(); equip.CurrentLocation.Building = ddlBuilding.Text; equip.CurrentLocation.Room = txtBoxRoomNumber.Text; equip.CurrentLocation.PrimaryUser = txtBoxPrimaryUser.Text; equip.CurrentLocation.Name = txtBoxName.Text; equip.PurchasePrice = Convert.ToDouble(txtBoxPurchasePrice.Text); equip.PO.ID = Convert.ToInt32(ddlPONO.SelectedValue); equip.Connectivity = txtBoxConnectivity.Text; equip.NetworkCapable = ddlNetworkCapable.Text; equip.Other = txtBoxOther.Text; equip.PhysicalAddress = txtBoxPhysicalAddress.Text.ToUpper(); equip.Notes = txtBoxNotes.Text; lblMessage.Text = Equipment.updateEquipment(oEquip, equip); lblMessage.Visible = true; btnClearMessage.Visible = true; }
protected void btnSelectGroup_Click(object sender, EventArgs e) { List<Group> computerGroups = new List<Group>(); computerGroups = Group.getAllComputerGroups(); List<Group> equipmentGroups = new List<Group>(); equipmentGroups = Group.getAllEquipmentGroups(); foreach (int i in lstBoxGroups.GetSelectedIndices()) { bool isComputerGroup = false; bool isEquipmentGroup = false; for (int j = 0; j < computerGroups.Count; j++) { Group group = new Group(); group = (Group)computerGroups[j]; if (group.Name == lstBoxGroups.Items[i].Text) { isComputerGroup = true; } } for (int j = 0; j < equipmentGroups.Count; j++) { Group group = new Group(); group = (Group)equipmentGroups[j]; if (group.Name == lstBoxGroups.Items[i].Text) { isEquipmentGroup = true; } } if (isComputerGroup == true) { Group selectedGroup = new Group(); selectedGroup = Group.getGroupComputers(lstBoxGroups.Items[i].Text); for (int j = 0; j < selectedGroup.Computers.Count; j++) { Computer comp = new Computer(); comp = (Computer)selectedGroup.Computers[j]; //txtBoxServiceTags.Text += comp.SerialNo + "\r\n"; bool existsLB = false; for (int k = 0; k < lstBoxSerialNos.Items.Count; k++) { if (lstBoxSerialNos.Items[k].Text == comp.SerialNo.ToUpper()) { existsLB = true; } } if (existsLB == false) { lstBoxSerialNos.Items.Add(comp.SerialNo.ToUpper()); lstBoxSerialNos.Text = comp.SerialNo.ToUpper(); } } } else if (isEquipmentGroup == true) { Group selectedGroup = new Group(); selectedGroup = Group.getGroupEquipment(lstBoxGroups.Items[i].Text); for (int j = 0; j < selectedGroup.Equipment.Count; j++) { Equipment equip = new Equipment(); equip = (Equipment)selectedGroup.Equipment[j]; //txtBoxServiceTags.Text += comp.SerialNo + "\r\n"; bool existsLB = false; for (int k = 0; k < lstBoxSerialNos.Items.Count; k++) { if (lstBoxSerialNos.Items[k].Text == equip.SerialNo.ToUpper()) { existsLB = true; } } if (existsLB == false) { lstBoxSerialNos.Items.Add(equip.SerialNo.ToUpper()); lstBoxSerialNos.Text = equip.SerialNo.ToUpper(); } } } } }