protected void btnAddDesktop_Click(object sender, EventArgs e)
{
List<Computer> computers = new List<Computer>();
for (int i = 0; i < lstBoxSerialNos.Items.Count; i++)
{
Computer comp = new Computer();
comp.InvID = Convert.ToInt32(lstBoxSerialNos.Items[i].Value);
comp.SerialNo = lstBoxSerialNos.Items[i].Text;
comp.SMSUtag = txtBoxSMSUTag.Text;
comp.Manufacturer = ddlManufacturer.Text;
comp.Model = txtBoxModel.Text;
if (txtBoxPurchasePrice.Text != "")
comp.PurchasePrice = Convert.ToDouble(txtBoxPurchasePrice.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;
if (ddlUSBPorts.Text == "")
{
comp.USBports = null;
}
else
{
comp.USBports = Convert.ToInt32(ddlUSBPorts.SelectedValue);
}
comp.OtherConnectivity = txtBoxOtherConnectivity.Text;
comp.Size = txtBoxSize.Text;
comp.PhysicalAddress = txtBoxPhysicalAddress.Text.ToUpper();
comp.Notes = txtBoxNotes.Text;
comp.Type = ddlType.Text;
comp.Status = ddlStatus.Text;
if (ddlPONO.Visible == true)
{
comp.PO.ID = Convert.ToInt32(ddlPONO.SelectedValue);
}
else
{
comp.PO.ID = null;
}
computers.Add(comp);
}
lblMessage.Text = Computer.updateComputers(computers);
lblMessage.Visible = true;
btnClearMessage.Visible = true;
btnPopUpExtender_ModalPopupExtender.Show();
}
public static void addLogistics(SqlCommand cmd, Computer comp)
{
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", comp.InvID);
cmd.Parameters.AddWithValue("Building", comp.CurrentLocation.Building);
cmd.Parameters.AddWithValue("Room", comp.CurrentLocation.Room);
cmd.Parameters.AddWithValue("PrimaryUser", comp.CurrentLocation.PrimaryUser);
cmd.Parameters.AddWithValue("Name", comp.CurrentLocation.Name);
cmd.Parameters.AddWithValue("StartDate", DateTime.Now.ToShortDateString());
cmd.Parameters.AddWithValue("Status", "Active");
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
public static Boolean computerExist(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, Computer Where Inventory.InvID = Computer.InvID AND SerialNo = @SerialNo";
dbCmd = new SqlCommand();
dbCmd.CommandText = sql;
dbCmd.Parameters.AddWithValue("@SerialNo", serialNo);
dbCmd.Connection = dbConn;
dbReader = dbCmd.ExecuteReader();
List<Computer> desktops = new List<Computer>();
while (dbReader.Read())
{
Computer comp = new Computer();
comp.SerialNo = dbReader["SerialNo"].ToString();
desktops.Add(comp);
}
dbReader.Close();
dbCmd.Parameters.Clear();
if (desktops.Count > 0)
return true;
else
return false;
}
public static int? equipmentExistReturnID(string serialNo)
{
StringBuilder message = new StringBuilder();
SqlConnection dbConn;
string sConnection;
SqlCommand dbCmd;
SqlDataReader dbReader;
sConnection = GlobalVars.ConnectionString;
dbConn = new SqlConnection(sConnection);
dbConn.Open();
dbCmd = dbConn.CreateCommand();
try
{
string 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<Computer> desktops = new List<Computer>();
while (dbReader.Read())
{
Computer comp = new Computer();
comp.SerialNo = dbReader["SerialNo"].ToString();
desktops.Add(comp);
}
dbReader.Close();
dbCmd.Parameters.Clear();
if (desktops.Count > 0)
return EquipmentDA.getInvID(dbCmd, serialNo);
else
return null;
}
catch (Exception ex)
{
ex.ToString();
return null;
}
}
public static Group getGroupComputers(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())
{
Computer comp = new Computer();
comp.SerialNo = dbReader["SerialNo"].ToString();
comp.InvID = Convert.ToInt32(dbReader["InvID"]);
group.Computers.Add(comp);
}
dbReader.Close();
dbCmd.Parameters.Clear();
transaction.Commit();
dbConn.Close();
return group;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
transaction.Rollback();
dbConn.Close();
return null;
}
}
public static string updateComputers(List<Computer> computers)
{
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 < computers.Count; i++)
{
Computer comp = new Computer();
comp = (Computer)computers[i];
Computer oComp = ComputerDA.getComputer(dbCmd, comp.SerialNo);
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE Inventory SET ");
if (comp.SMSUtag != "")
{
sqlCommand.Append("SMSUtag = @SMSUtag,");
dbCmd.Parameters.AddWithValue("SMSUtag", comp.SMSUtag);
}
if (comp.Manufacturer != "")
{
sqlCommand.Append("Manufacturer = @Manufacturer,");
dbCmd.Parameters.AddWithValue("Manufacturer", comp.Manufacturer);
}
if (comp.Model != "")
{
sqlCommand.Append("Model = @Model,");
dbCmd.Parameters.AddWithValue("Model", comp.Model);
}
double? price = comp.PurchasePrice;
if (price.HasValue)
{
sqlCommand.Append("PurchasePrice = @PurchasePrice,");
dbCmd.Parameters.AddWithValue("PurchasePrice", comp.PurchasePrice);
}
if (comp.Notes != "")
{
sqlCommand.Append("Notes = @Notes,");
dbCmd.Parameters.AddWithValue("Notes", comp.Notes);
}
if (comp.PhysicalAddress != "")
{
sqlCommand.Append("PhysicalAddress = @PhysicalAddress,");
dbCmd.Parameters.AddWithValue("PhysicalAddress", comp.PhysicalAddress);
}
if (comp.Status != "")
{
if (oComp.Status != "Transferred")
{
sqlCommand.Append("Status = @Status,");
dbCmd.Parameters.AddWithValue("Status", comp.Status);
}
}
sqlCommand.Remove((sqlCommand.Length - 1), 1);
sqlCommand.Append(" WHERE InvID = @InvID");
dbCmd.Parameters.AddWithValue("InvID", oComp.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 Computer SET ");
if (comp.CPU != "")
{
sqlCommand.Append("CPU = @CPU,");
dbCmd.Parameters.AddWithValue("CPU", comp.CPU);
}
if (comp.VideoCard != "")
{
sqlCommand.Append("VideoCard = @VideoCard,");
dbCmd.Parameters.AddWithValue("VideoCard", comp.VideoCard);
}
if (comp.HardDrive != "")
{
sqlCommand.Append("HardDrive = @HardDrive,");
dbCmd.Parameters.AddWithValue("HardDrive", comp.HardDrive);
}
if (comp.Memory != "")
{
sqlCommand.Append("Memory = @Memory,");
dbCmd.Parameters.AddWithValue("Memory", comp.Memory);
}
if (comp.OpticalDrive != "")
{
sqlCommand.Append("OpticalDrive = @OpticalDrive,");
dbCmd.Parameters.AddWithValue("OpticalDrive", comp.OpticalDrive);
}
if (comp.RemovableMedia != "")
{
sqlCommand.Append("RemovableMedia = @RemovableMedia,");
dbCmd.Parameters.AddWithValue("RemovableMedia", comp.RemovableMedia);
}
int? ports = comp.USBports;
if (ports.HasValue)
{
sqlCommand.Append("USBports = @USBports,");
dbCmd.Parameters.AddWithValue("USBports", comp.USBports);
}
if (comp.OtherConnectivity != "")
{
sqlCommand.Append("OtherConnectivity = @OtherConnectivity,");
dbCmd.Parameters.AddWithValue("OtherConnectivity", comp.OtherConnectivity);
}
if (comp.Size != "")
{
sqlCommand.Append("FormFactor = @FormFactor,");
dbCmd.Parameters.AddWithValue("FormFactor", comp.Size);
}
if (comp.Type != "")
{
sqlCommand.Append("Type = @Type,");
dbCmd.Parameters.AddWithValue("Type", comp.Type);
}
sqlCommand.Remove((sqlCommand.Length - 1), 1);
sqlCommand.Append(" WHERE InvID = @InvID");
dbCmd.Parameters.AddWithValue("InvID", oComp.InvID);
dbCmd.CommandText = sqlCommand.ToString();
if (dbCmd.CommandText != "UPDATE Computer SET WHERE InvID = @InvID")
{
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
}
dbCmd.Parameters.Clear();
if (comp.PO.ID != null)
{
PODA.deleteLink(dbCmd, oComp.InvID);
PODA.addLink(dbCmd, oComp.InvID, comp.PO.ID);
}
message.Append("Computer with Service Tag " + comp.SerialNo + " updated successfully!<bR>");
}
transaction.Commit();
dbConn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString() + "<bR>");
transaction.Rollback();
}
return message.ToString();
}
public static string updateComputer(Computer oComp, Computer comp)
{
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 (comp.SerialNo.ToUpper() != oComp.SerialNo.ToUpper() && computerExist(comp.SerialNo))
{
message.Append("That Service tag 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", comp.SMSUtag);
dbCmd.Parameters.AddWithValue("SerialNo", comp.SerialNo);
dbCmd.Parameters.AddWithValue("Manufacturer", comp.Manufacturer);
dbCmd.Parameters.AddWithValue("Model", comp.Model);
dbCmd.Parameters.AddWithValue("PurchasePrice", comp.PurchasePrice);
dbCmd.Parameters.AddWithValue("Notes", comp.Notes);
dbCmd.Parameters.AddWithValue("Status", comp.Status);
dbCmd.Parameters.AddWithValue("InvID", comp.InvID);
dbCmd.Parameters.AddWithValue("PhysicalAddress", comp.PhysicalAddress);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
sqlCommand = "UPDATE Computer SET CPU = @CPU, VideoCard = @VideoCard, HardDrive = @HardDrive, Memory = @Memory, OpticalDrive = @OpticalDrive, " +
"RemovableMedia = @RemovableMedia, USBPorts = @USBPorts, OtherConnectivity = @OtherConnectivity, FormFactor = @FormFactor, Type = @Type WHERE " +
"InvID = @InvID";
dbCmd.Parameters.AddWithValue("InvID", comp.InvID);
dbCmd.Parameters.AddWithValue("CPU", comp.CPU);
dbCmd.Parameters.AddWithValue("VideoCard", comp.VideoCard);
dbCmd.Parameters.AddWithValue("HardDrive", comp.HardDrive);
dbCmd.Parameters.AddWithValue("Memory", comp.Memory);
dbCmd.Parameters.AddWithValue("OpticalDrive", comp.OpticalDrive);
dbCmd.Parameters.AddWithValue("RemovableMedia", comp.RemovableMedia);
dbCmd.Parameters.AddWithValue("USBPorts", comp.USBports);
dbCmd.Parameters.AddWithValue("OtherConnectivity", comp.OtherConnectivity);
dbCmd.Parameters.AddWithValue("FormFactor", comp.Size);
dbCmd.Parameters.AddWithValue("Type", comp.Type);
dbCmd.CommandText = sqlCommand;
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
if (comp.CurrentLocation.Name == oComp.CurrentLocation.Name && comp.CurrentLocation.Building == oComp.CurrentLocation.Building
&& comp.CurrentLocation.Room == oComp.CurrentLocation.Room && comp.CurrentLocation.PrimaryUser == oComp.CurrentLocation.PrimaryUser)
{
//do nothing
}
else
{
LogisticsDA.removeLogistics(dbCmd, comp.InvID);
LogisticsDA.addLogistics(dbCmd, comp);
}
if (oComp.PO.ID != comp.PO.ID)
{
PODA.deleteLink(dbCmd, comp.InvID);
PODA.addLink(dbCmd, comp.InvID, comp.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 Computer getComputer(SqlCommand cmd, int invID)
{
SqlDataReader dbReader;
string sql = "SELECT SerialNo, CompID, SMSUTag, Manufacturer, Model, PurchasePrice, Notes, CPU, VideoCard, "+
"HardDrive, Memory, OpticalDrive, RemovableMedia, USBPorts, OtherConnectivity, FormFactor, Type, Inventory.Status, Building, Room, PrimaryUser, Name "+
"FROM Inventory, Computer, Logistics WHERE Inventory.InvID = Computer.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();
Computer comp = new Computer();
while (dbReader.Read())
{
comp.CompID = Convert.ToInt32(dbReader["CompID"]);
comp.SMSUtag = dbReader["SMSUtag"].ToString();
comp.SerialNo = dbReader["SerialNo"].ToString();
comp.Manufacturer = dbReader["Manufacturer"].ToString();
comp.Model = dbReader["Model"].ToString();
comp.PurchasePrice = Convert.ToDouble(dbReader["PurchasePrice"]);
comp.Notes = dbReader["Notes"].ToString();
comp.CPU = dbReader["CPU"].ToString();
comp.VideoCard = dbReader["VideoCard"].ToString();
comp.HardDrive = dbReader["HardDrive"].ToString();
comp.Memory = dbReader["Memory"].ToString();
comp.OpticalDrive = dbReader["OpticalDrive"].ToString();
comp.RemovableMedia = dbReader["RemovableMedia"].ToString();
comp.USBports = Convert.ToInt32(dbReader["USBports"]);
comp.OtherConnectivity = dbReader["OtherConnectivity"].ToString();
comp.Size = dbReader["FormFactor"].ToString();
comp.Type = dbReader["Type"].ToString();
comp.Status = dbReader["Status"].ToString();
comp.CurrentLocation.Building = dbReader["Building"].ToString();
comp.CurrentLocation.Room = dbReader["Room"].ToString();
comp.CurrentLocation.PrimaryUser = dbReader["PrimaryUser"].ToString();
comp.CurrentLocation.Name = dbReader["Name"].ToString();
}
dbReader.Close();
cmd.Parameters.Clear();
comp.Monitors = MonitorDA.getMonitor(cmd, comp.CompID);
comp.PO = PODA.getPODetails(cmd, comp.InvID);
comp.Groups = GroupDA.getGroups(cmd, comp.InvID);
return comp;
}
protected void btnSelectGroup_Click(object sender, EventArgs e)
{
foreach (int i in lstBoxGroups.GetSelectedIndices())
{
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)
{
ListItem li = new ListItem(comp.SerialNo.ToUpper(), comp.InvID.ToString());
lstBoxSerialNos.Items.Add(li);
lstBoxSerialNos.SelectedValue = li.Value;
}
}
}
}
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();
}
}
}
}
}
public static string updateComputer(Computer oComp, Computer comp)
{
return ComputerDA.updateComputer(oComp, comp);
}
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;
}
}
}
protected void btnUpdateDesktop_Click(object sender, EventArgs e)
{
int compID = Convert.ToInt32(Session["CurrentComputer"]);
oComp = Computer.getComputer(compID);
Computer comp = new Computer();
comp.InvID = Convert.ToInt32(compID);
comp.SerialNo = txtBoxServiceTag.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;
comp.CurrentLocation.Name = txtBoxName.Text;
comp.PurchasePrice = Convert.ToDouble(txtBoxPurchasePrice.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.SelectedValue);
comp.OtherConnectivity = txtBoxOtherConnectivity.Text;
comp.Size = txtBoxSize.Text;
comp.Status = ddlStatus.Text;
comp.Notes = txtBoxNotes.Text;
comp.Type = ddlType.Text;
comp.PhysicalAddress = txtBoxPhysicalAddress.Text.ToUpper();
if (ddlStatus.Enabled == false)
{
comp.Status = "Transferred";
}
else
{
comp.Status = ddlStatus.Text;
}
comp.PO = new PurchaseOrder();
comp.PO.ID = Convert.ToInt32(ddlPONO.SelectedValue);
for (int i = 0; i<lstBoxMonitors.Items.Count; i++)
{
Monitor mon = new Monitor();
mon.ID = Convert.ToInt32(lstBoxMonitors.Items[i].Value);
comp.Monitors.Add(mon);
}
lblMessage.Text = Computer.updateComputer(oComp ,comp);
btnClear.Visible = true;
GridView2.DataBind();
}
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 Computer getComputer(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 CompID, SMSUTag, SerialNo, Manufacturer, Model, PurchasePrice, Notes, PhysicalAddress, CPU, VideoCard, HardDrive, Memory, OpticalDrive, RemovableMedia, USBports,"+
" OtherConnectivity, FormFactor, Type, Inventory.Status, Building, Room, PrimaryUser, Name FROM Inventory, Computer, Logistics WHERE Inventory.InvID = Computer.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();
Computer comp = new Computer();
while (dbReader.Read())
{
comp.InvID = Convert.ToInt32(invID);
comp.CompID = Convert.ToInt32(dbReader["CompID"]);
comp.SMSUtag = dbReader["SMSUtag"].ToString();
comp.SerialNo = dbReader["SerialNo"].ToString();
comp.Manufacturer = dbReader["Manufacturer"].ToString();
comp.Model = dbReader["Model"].ToString();
comp.PurchasePrice = Convert.ToDouble(dbReader["PurchasePrice"]);
comp.Notes = dbReader["Notes"].ToString();
comp.PhysicalAddress = dbReader["PhysicalAddress"].ToString();
comp.CPU = dbReader["CPU"].ToString();
comp.VideoCard = dbReader["VideoCard"].ToString();
comp.HardDrive = dbReader["HardDrive"].ToString();
comp.Memory = dbReader["Memory"].ToString();
comp.OpticalDrive = dbReader["OpticalDrive"].ToString();
comp.RemovableMedia = dbReader["RemovableMedia"].ToString();
comp.USBports = Convert.ToInt32(dbReader["USBports"]);
comp.OtherConnectivity = dbReader["OtherConnectivity"].ToString();
comp.Size = dbReader["FormFactor"].ToString();
comp.Type = dbReader["Type"].ToString();
comp.Status = dbReader["Status"].ToString();
comp.CurrentLocation.Building = dbReader["Building"].ToString();
comp.CurrentLocation.Room = dbReader["Room"].ToString();
comp.CurrentLocation.PrimaryUser = dbReader["PrimaryUser"].ToString();
comp.CurrentLocation.Name = dbReader["Name"].ToString();
}
dbReader.Close();
dbCmd.Parameters.Clear();
if (comp.Status == "Transferred")
{
comp.Transfer = Transfer.getTransfer(dbCmd, invID);
}
comp.Monitors = MonitorDA.getMonitor(dbCmd,comp.CompID);
comp.PO = PODA.getPODetails(dbCmd, comp.InvID);
comp.Groups = GroupDA.getGroups(dbCmd, comp.InvID);
dbReader.Close();
transaction.Commit();
dbConn.Close();
return comp;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
transaction.Rollback();
return null;
}
}
public static string addLicensesComputer(List<int> ids, int licenseID)
{
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;
dbCmd.Connection = dbConn;
StringBuilder message = new StringBuilder();
try
{
for (int i = 0; i < ids.Count; i++)
{
int invID = ids[i];
License lic = new License();
Computer comp = new Computer();
comp = ComputerDA.getComputer(dbCmd, invID);
lic = LicenseDA.getLicense(dbCmd, licenseID);
if (LicenseDA.licenseExist(dbCmd, lic, invID) == true)
{
message.Append("Computer with Serial Number " + comp.SerialNo + " already has that license<bR>");
}
else
{
string sqlCommand = "INSERT INTO LicenseInventory (LicID, InvID) VALUES (@LicID, @InvID)";
dbCmd.CommandText = sqlCommand;
dbCmd.Parameters.AddWithValue("LicID", licenseID);
dbCmd.Parameters.AddWithValue("InvID", invID);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
}
}
transaction.Commit();
dbConn.Close();
message.Append("License added successfully<bR>");
return message.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString() + "<bR>");
transaction.Rollback();
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();
}
