protected void btnAddGroup_Click(object sender, EventArgs e) { Group group = new Group(); group.Name = txtBoxName.Text; group.Notes = txtBoxNotes.Text; group.Type = ddlType.Text; lblMessage.Text = Group.saveGroup(group); lblMessage.Visible = true; }
protected void btnAddGroup_Click(object sender, EventArgs e) { Group group = new Group(); group.Name = txtBoxName.Text; group.Notes = txtBoxNotes.Text; group.Type = ddlType.Text; lblMessage.Text = Group.saveGroup(group); lblMessage.Visible = true; if (lblMessage.Text == "Group created successfully<bR>") { GridView1.DataBind(); GridView2.DataBind(); panelAddGroup.Visible = false; btnAddNewGroup.Visible = true; txtBoxName.Text = ""; txtBoxNotes.Text = ""; } }
public static void updateGroups(SqlCommand cmd, List<Group> groupList, int invID) { GroupDA.removeLinks(cmd, invID); for (int i = 0; i < groupList.Count; i++) { Group group = new Group(); group = (Group)groupList[i]; int groupID = GroupDA.getGroupID(cmd, group.Name); GroupDA.addLink(cmd, groupID, invID); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["Warranties"] = new List<Warranty>(); List<Monitor> monList = new List<Monitor>(); monList = Monitor.getMonitors(); ddlType.Text = "Please Select"; ddlPONO.SelectedValue = "28"; List<Group> groupList = new List<Group>(); groupList = Group.getAllComputerGroups(); int nextGroup = 1; for (int i = 0; i < groupList.Count; i++) { Group group = new Group(); group = (Group)groupList[i]; if (nextGroup == 1) { chkBoxListGroups1.Items.Add(group.Name); nextGroup = 2; } else if (nextGroup == 2) { chkBoxListGroups2.Items.Add(group.Name); nextGroup = 3; } else if (nextGroup == 3) { chkBoxListGroups3.Items.Add(group.Name); nextGroup = 4; } else if (nextGroup == 4) { chkBoxListGroups4.Items.Add(group.Name); nextGroup = 1; } } if (Session["Authenticated"].ToString() != "True") { panelLicenses.Visible = false; } txtBoxSerialNo.Focus(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlBuilding.DataBind(); ddlBuilding.Items.Insert(0, ""); ddlBuilding.SelectedIndex = 0; ddlManufacturer.DataBind(); ddlManufacturer.Items.Insert(0, ""); ddlManufacturer.SelectedIndex = 0; List<Group> groupList = new List<Group>(); groupList = Group.getAllEquipmentGroups(); for (int i = 0; i < groupList.Count; i++) { Group group = new Group(); group = (Group)groupList[i]; lstBoxGroups.Items.Add(group.Name); } if (Session["Authenticated"].ToString() != "True") { btnManageLicensing.Enabled = false; } txtBoxSerialNo.Focus(); populateDDLs(); } else { handleGridView(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["Warranties"] = new List<Warranty>(); List<Group> groups = new List<Group>(); groups = Group.getAllEquipmentGroups(); int counter = 0; for (int i = 0; i < groups.Count; i++) { if (counter == 0) { Group group = new Group(); group = (Group)groups[i]; ListItem li = new ListItem(group.Name, group.ID.ToString()); chkBoxListGroups1.Items.Add(li); counter = 1; } else if (counter == 1) { Group group = new Group(); group = (Group)groups[i]; ListItem li = new ListItem(group.Name, group.ID.ToString()); chkBoxListGroups2.Items.Add(li); counter = 2; } else if (counter == 2) { Group group = new Group(); group = (Group)groups[i]; ListItem li = new ListItem(group.Name, group.ID.ToString()); chkBoxListGroups3.Items.Add(li); counter = 3; } else if (counter == 3) { Group group = new Group(); group = (Group)groups[i]; ListItem li = new ListItem(group.Name, group.ID.ToString()); chkBoxListGroups4.Items.Add(li); counter = 0; } } if (Session["Authenticated"].ToString() != "True") { panelLicenses.Visible = false; } txtBoxSerialNo.Focus(); } }
public static string updateGroup(Group newGroup, int oldGroupID) { return GroupDA.updateGroup(newGroup, oldGroupID); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["CurrentGroup"] == null) { Response.Redirect("~Groups/ManageGroups.aspx"); } int groupID; groupID = Convert.ToInt16(Session["CurrentGroup"]); Group group = new Group(); group = Group.getGroup(groupID); txtBoxName.Text = group.Name; txtBoxNotes.Text = group.Notes; populateDDLs(); } else { handleGridView(); } }
public static Group getGroup(SqlCommand cmd, int groupID) { SqlDataReader dbReader; string sql = "SELECT GroupID, Name, Notes FROM Groups WHERE GroupID = @GroupID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("GroupID", groupID); dbReader = cmd.ExecuteReader(); Group group = new Group(); while (dbReader.Read()) { group.ID = Convert.ToInt32(dbReader["GroupID"]); group.Name = dbReader["Name"].ToString(); group.Notes = dbReader["Notes"].ToString(); } dbReader.Close(); cmd.Parameters.Clear(); return group; }
public static Group getGroup(int GroupID) { 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 { string sql = "SELECT GroupID, Name, Notes from Groups where GroupID = @GroupID"; dbCmd.CommandText = sql; dbCmd.Parameters.AddWithValue("GroupID", GroupID); dbReader = dbCmd.ExecuteReader(); Group group = new Group(); while (dbReader.Read()) { group.ID = Convert.ToInt32(dbReader["GroupID"]); group.Name = dbReader["Name"].ToString(); group.Notes = dbReader["Notes"].ToString(); } dbReader.Close(); dbCmd.Parameters.Clear(); transaction.Commit(); 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 Page_Load(object sender, EventArgs e) { if (!IsPostBack) { List<Group> groupList = new List<Group>(); groupList = Group.getAllGroups(); for (int i = 0; i < groupList.Count; i++) { Group group = new Group(); group = (Group)groupList[i]; lstBoxGroups.Items.Add(group.Name); } txtBoxSerialNo.Focus(); populateComputerDDLs(); populateEquipmentDDLs(); } else { handleComputerGridView(); handleEquipmentGridView(); } }
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(); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int invID = 0; string invIDstr = Request.QueryString["id"]; try { invID = Convert.ToInt32(invIDstr); Session["CurrentComputer"] = 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"); } Computer comp = new Computer(); comp = Computer.getComputer(invID); if (comp.Status == "Transferred") { pnlTransferInfo.Visible = true; lblTransferDate.Text = comp.Transfer.Date; lblTransferTo.Text = comp.Transfer.Where; lblTransferNotes.Text = comp.Transfer.Notes; Session["CurrentTransfer"] = comp.Transfer.ID; } if (comp.InvID == 0 || comp.InvID == null) { Response.Redirect("~/PageNotFound.aspx"); } Session["CurrentComputerID"] = comp.CompID; txtBoxDate.Text = DateTime.Now.ToShortDateString(); txtBoxServiceTag.Text = comp.SerialNo; txtBoxSMSUTag.Text = comp.SMSUtag; bool containsManufacturer = false; ddlManufacturer.DataBind(); for (int i = 0; i < ddlManufacturer.Items.Count; i++) { if (ddlManufacturer.Items[i].Text == comp.Manufacturer) { containsManufacturer = true; } } if (containsManufacturer == false) { ddlManufacturer.Items.Add(comp.Manufacturer); ddlManufacturer.Text = comp.Manufacturer; } else { ddlManufacturer.Text = comp.Manufacturer; } txtBoxModel.Text = comp.Model; ddlBuilding.DataBind(); bool containsBuilding = false; for (int i = 0; i < ddlBuilding.Items.Count; i++) { if (ddlBuilding.Items[i].Text == comp.CurrentLocation.Building) { containsBuilding = true; } } if (containsBuilding == false) { ddlBuilding.Items.Add(comp.CurrentLocation.Building); ddlBuilding.Text = comp.CurrentLocation.Building; } else { ddlBuilding.Text = comp.CurrentLocation.Building; } txtBoxRoomNumber.Text = comp.CurrentLocation.Room; txtBoxPrimaryUser.Text = comp.CurrentLocation.PrimaryUser; txtBoxName.Text = comp.CurrentLocation.Name; txtBoxPurchasePrice.Text = comp.PurchasePrice.ToString(); txtBoxCPU.Text = comp.CPU; txtBoxVideoCard.Text = comp.VideoCard; txtBoxHardDrive.Text = comp.HardDrive; txtBoxMemory.Text = comp.Memory; txtBoxOpticalDrive.Text = comp.OpticalDrive; txtBoxRemovableMedia.Text = comp.RemovableMedia; ddlUSBPorts.SelectedValue = comp.USBports.ToString(); txtBoxOtherConnectivity.Text = comp.OtherConnectivity; txtBoxSize.Text = comp.Size; txtBoxPhysicalAddress.Text = comp.PhysicalAddress; txtBoxNotes.Text = comp.Notes; ddlType.Text = comp.Type; ddlPONO.SelectedValue = comp.PO.ID.ToString(); if (comp.Status != "Transferred") { ddlStatus.Text = comp.Status; } else { ddlStatus.Items.Add("Transferred"); ddlStatus.Text = "Transferred"; ddlStatus.Enabled = false; } List<Group> groups = new List<Group>(); groups = Group.getAllComputerGroups(); 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 < comp.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)comp.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 < comp.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)comp.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 < comp.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)comp.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 < comp.Groups.Count; j++) { Group compGroup = new Group(); compGroup = (Group)comp.Groups[j]; if (compGroup.Name == group.Name) { chkBoxLstGroups4.Items[chkBoxLstGroups1.Items.Count - 1].Selected = true; } } } } if (comp.Status == "Transferred") { btnAddMonitor.Enabled = false; btnRemoveMonitor.Enabled = false; btnEditGroups.Enabled = false; btnAddLicense.Enabled = false; btnRemoveLicense.Enabled = false; btnAddMaintenance.Enabled = false; btnAddWarranty.Enabled = false; btnUpdateDesktop.Enabled = false; gvWarranties.Enabled = false; } if (Session["Authenticated"].ToString() != "True") { panelLicenses.Visible = false; } } }
public static List<Group> getAllEquipmentGroups() { 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; string sql = "SELECT GroupID, Name, Notes FROM Groups WHERE Type = 'Equipment'"; dbCmd.CommandText = sql; dbReader = dbCmd.ExecuteReader(); List<Group> groupList = new List<Group>(); while (dbReader.Read()) { Group group = new Group(); group.ID = Convert.ToInt16(dbReader["GroupID"]); group.Name = dbReader["Name"].ToString(); group.Notes = dbReader["Notes"].ToString(); groupList.Add(group); } dbReader.Close(); dbCmd.Parameters.Clear(); return groupList; }
protected void btnUpdateGroup_Click(object sender, EventArgs e) { Group group = new Group(); group.Name = txtBoxName.Text; group.Notes = txtBoxNotes.Text; lblMessage.Visible = true; lblMessage.Text = Group.updateGroup(group, Convert.ToInt32(Session["CurrentGroup"])); if (lblMessage.Text == "Group updated successfully<bR>") { Panel1.Visible = false; DetailsView1.Visible = true; btnEditGroup.Visible = true; btnUpdateGroup.Visible = false; DetailsView1.DataBind(); } }
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; } }
public static string saveGroup(Group group) { return GroupDA.saveGroup(group); }
public static List<Group> getGroups(SqlCommand cmd, int invID) { SqlDataReader dbReader; string sql; sql = "SELECT Name, Notes FROM GroupInventory, Groups WHERE GroupInventory.GroupID = Groups.GroupID AND InvID = @InvID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("InvID", invID); dbReader = cmd.ExecuteReader(); List<Group> groupList = new List<Group>(); while (dbReader.Read()) { Group group = new Group(); group.Name = dbReader["Name"].ToString(); group.Notes = dbReader["Notes"].ToString(); groupList.Add(group); } dbReader.Close(); cmd.Parameters.Clear(); return groupList; }
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 bool groupExist(string GroupName) { SqlConnection dbConn; string sConnection; SqlCommand dbCmd; SqlTransaction transaction; StringBuilder message = new StringBuilder(); SqlDataReader dbReader; sConnection = GlobalVars.ConnectionString; dbConn = new SqlConnection(sConnection); dbConn.Open(); dbCmd = dbConn.CreateCommand(); transaction = dbConn.BeginTransaction("Transaction"); dbCmd.Transaction = transaction; string sql = "SELECT GroupID, Notes FROM Groups WHERE Name = @Name"; dbCmd.CommandText = sql; dbCmd.Parameters.AddWithValue("Name", GroupName); dbReader = dbCmd.ExecuteReader(); List<Group> groupList = new List<Group>(); while (dbReader.Read()) { Group group = new Group(); group.ID = Convert.ToInt32(dbReader["GroupID"]); group.Notes = dbReader["Notes"].ToString(); groupList.Add(group); } dbReader.Close(); dbCmd.Parameters.Clear(); if (groupList.Count > 0) { return true; } else { return false; } }
public static string saveEquipment(List<Equipment> equipment) { StringBuilder message = new StringBuilder(); SqlConnection dbConn; string sConnection; SqlCommand dbCmd; SqlTransaction transaction; 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 < equipment.Count; i++) { Equipment equip = (Equipment)equipment[i]; //Insert Into Inventory Table string sqlCommand = "INSERT INTO Inventory (SMSUTag, SerialNo, Manufacturer, Model, PurchasePrice, Notes, Status, PhysicalAddress) " + "VALUES (@SMSUTag, @SerialNo, @Manufacturer, @Model, @PurchasePrice, @Notes, @Status, @PhysicalAddress)"; 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("Status", equip.Status); dbCmd.Parameters.AddWithValue("PhysicalAddress", equip.PhysicalAddress); dbCmd.ExecuteNonQuery(); dbCmd.Parameters.Clear(); //Get InvID equip.InvID = ComputerDA.getInvID(dbCmd, equip.SerialNo); //Insert Into Computer Table sqlCommand = "INSERT INTO Equipment (InvID, EquipmentType, Connectivity, NetworkCapable, Other) " + "VALUES (@InvID, @EquipmentType, @Connectivity, @NetworkCapable, @Other)"; dbCmd.CommandText = sqlCommand; 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.ExecuteNonQuery(); dbCmd.Parameters.Clear(); sqlCommand = "INSERT INTO Logistics (InvID, Building, Room, PrimaryUser, Name, StartDate, Status) " + "VALUES (@InvID5, @Building, @Room, @PrimaryUser, @Name, @StartDate, @Status)"; dbCmd.CommandText = sqlCommand; dbCmd.Parameters.AddWithValue("InvID5", equip.InvID); dbCmd.Parameters.AddWithValue("Building", equip.CurrentLocation.Building); dbCmd.Parameters.AddWithValue("Room", equip.CurrentLocation.Room); dbCmd.Parameters.AddWithValue("PrimaryUser", equip.CurrentLocation.PrimaryUser); dbCmd.Parameters.AddWithValue("Name", equip.CurrentLocation.Name); dbCmd.Parameters.AddWithValue("StartDate", DateTime.Now.ToShortDateString()); dbCmd.Parameters.AddWithValue("Status", "Active"); dbCmd.ExecuteNonQuery(); dbCmd.Parameters.Clear(); PODA.addLink(dbCmd, equip.InvID, equip.PO.ID); for (int j = 0; j < equip.Groups.Count; j++) { Group grp = new Group(); grp = (Group)equip.Groups[j]; GroupDA.addLink(dbCmd, grp.ID, equip.InvID); } for (int j = 0; j < equip.Licenses.Count; j++) { License li = new License(); li = (License)equip.Licenses[j]; LicenseDA.addLicense(dbCmd, li.ID, equip.InvID); } for (int j = 0; j < equip.Warranties.Count; j++) { WarrantyDA.addWarranty(dbCmd, equip.InvID, (Warranty)equip.Warranties[j]); } } transaction.Commit(); dbConn.Close(); message.Append("Operation successfull!<bR>"); return message.ToString(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); message.Append("Database Error: " + ex.ToString() + "<bR>"); transaction.Rollback(); return message.ToString(); } }
public static bool groupExist(SqlCommand cmd, string groupName) { SqlDataReader dbReader; string sql = "SELECT GroupID, Notes FROM Groups WHERE Name = @GroupName"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("GroupName", groupName); dbReader = cmd.ExecuteReader(); List<Group> groupList = new List<Group>(); while (dbReader.Read()) { Group group = new Group(); group.ID = Convert.ToInt32(dbReader["GroupID"]); group.Notes = dbReader["Notes"].ToString(); groupList.Add(group); } dbReader.Close(); cmd.Parameters.Clear(); if (groupList.Count > 0) { return true; } else { return false; } }
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 saveGroup(Group group) { 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; if (GroupDA.groupExist(group.Name) == false) { try { string sqlCommand = "INSERT INTO Groups (Name, Notes, Type) " + "VALUES (@GroupName, @Notes, @Type)"; dbCmd.CommandText = sqlCommand; dbCmd.Parameters.AddWithValue("GroupName", group.Name); dbCmd.Parameters.AddWithValue("Notes", group.Notes); dbCmd.Parameters.AddWithValue("Type", group.Type); dbCmd.ExecuteNonQuery(); dbCmd.Parameters.Clear(); transaction.Commit(); dbConn.Close(); message.Append("Group created successfully<bR>"); } catch (Exception ex) { Console.WriteLine(ex.ToString()); message.Append(ex.ToString()); transaction.Rollback(); } return message.ToString(); } else { message.Append("That group name already exists, choose another.<bR>"); return message.ToString(); } }
public static string updateGroup(Group newGroup, int oldGroupID) { 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; Group oldGroup = new Group(); oldGroup = GroupDA.getGroup(dbCmd, oldGroupID); if (newGroup.Name == oldGroup.Name || GroupDA.groupExist(dbCmd, newGroup.Name) == false) { try { string sqlCommand = "UPDATE Groups SET " + "Name = @Name, " + "Notes = @Notes " + "WHERE Name = @OldName"; dbCmd.CommandText = sqlCommand; dbCmd.Parameters.AddWithValue("Name", newGroup.Name); dbCmd.Parameters.AddWithValue("Notes", newGroup.Notes); dbCmd.Parameters.AddWithValue("OldName", oldGroup.Name); dbCmd.ExecuteNonQuery(); dbCmd.Parameters.Clear(); transaction.Commit(); dbConn.Close(); message.Append("Group updated successfully<bR>"); } catch (Exception ex) { Console.WriteLine(ex.ToString()); message.Append(ex.ToString()); transaction.Rollback(); } return message.ToString(); } else { message.Append("That group name already exists, choose another.<bR>"); return message.ToString(); } }
protected void btnAddDesktop_Click(object sender, EventArgs e) { List<Group> groupList = new List<Group>(); List<Computer> computers = new List<Computer>(); for(int i=0; i < chkBoxListGroups1.Items.Count; i++) { if (chkBoxListGroups1.Items[i].Selected == true) { Group group = new Group(); group.Name = chkBoxListGroups1.Items[i].ToString(); groupList.Add(group); } } for (int i = 0; i < chkBoxListGroups2.Items.Count; i++) { if (chkBoxListGroups2.Items[i].Selected == true) { Group group = new Group(); group.Name = chkBoxListGroups1.Items[i].ToString(); groupList.Add(group); } } for (int i = 0; i < chkBoxListGroups3.Items.Count; i++) { if (chkBoxListGroups3.Items[i].Selected == true) { Group group = new Group(); group.Name = chkBoxListGroups1.Items[i].ToString(); groupList.Add(group); } } for (int i = 0; i < chkBoxListGroups4.Items.Count; i++) { if (chkBoxListGroups4.Items[i].Selected == true) { Group group = new Group(); group.Name = chkBoxListGroups1.Items[i].ToString(); groupList.Add(group); } } for (int i = 0; i < lstBoxSerialNos.Items.Count; i++) { Computer comp = new Computer(); comp.SerialNo = lstBoxSerialNos.Items[i].Text.ToUpper(); comp.SMSUtag = txtBoxSMSUTag.Text; comp.Manufacturer = ddlManufacturer.Text; comp.Model = txtBoxModel.Text; comp.CurrentLocation.Building = ddlBuilding.Text; comp.CurrentLocation.Room = txtBoxRoomNumber.Text; comp.CurrentLocation.PrimaryUser = txtBoxPrimaryUser.Text; if (txtBoxPurchasePrice.Text == "") comp.PurchasePrice = 0; else comp.PurchasePrice = Convert.ToDouble(txtBoxPurchasePrice.Text); comp.CurrentLocation.Name = txtBoxName.Text; comp.CPU = txtBoxCPU.Text; comp.VideoCard = txtBoxVideoCard.Text; comp.HardDrive = txtBoxHardDrive.Text; comp.Memory = txtBoxMemory.Text; comp.OpticalDrive = txtBoxOpticalDrive.Text; comp.RemovableMedia = txtBoxRemovableMedia.Text; comp.USBports = Convert.ToInt32(ddlUSBports.Text); comp.OtherConnectivity = txtBoxOtherConnectivity.Text; comp.Size = txtBoxSize.Text; comp.Notes = txtBoxNotes.Text; comp.Type = ddlType.Text; comp.PO = PurchaseOrder.getPO(ddlPONO.SelectedValue.ToString()); comp.Status = ddlStatus.Text; comp.Groups = groupList; comp.PhysicalAddress = txtBoxPhysicalAddress.Text.ToUpper(); for (int j = 0; j < lstBoxMonitors.Items.Count; j++) { Monitor mon = new Monitor(); mon.ID = Convert.ToInt32(lstBoxMonitors.Items[j].Value); comp.Monitors.Add(mon); } for (int j = 0; j < lstBoxLicenses.Items.Count; j++) { License lic = new License(); lic.ID = Convert.ToInt32(lstBoxLicenses.Items[j].Value); comp.Licenses.Add(lic); } comp.Warranties = (List<Warranty>)Session["Warranties"]; computers.Add(comp); } lblMessage.Text = Computer.saveComputers(computers); if (lblMessage.Text == "Operation successfull!<bR>") { lstBoxSerialNos.Items.Clear(); } btnClearMessage.Visible = true; btnPopUpExtender_ModalPopupExtender.Show(); }