protected void btnAddMonitor_Click(object sender, EventArgs e)
{
if (btnAddMonitor.Text == "Add Monitor")
{
Monitor mon = new Monitor();
mon.Brand = txtBoxBrand.Text;
mon.Connectors = txtBoxConnectors.Text;
mon.DisplayText = txtBoxDisplayText.Text;
mon.Model = txtBoxModel.Text;
mon.Resolution = txtBoxResolution.Text;
mon.Size = txtBoxResolution.Text;
lblMessage.Text = Monitor.saveMonitor(mon);
refresh();
}
else if (btnAddMonitor.Text == "Update Monitor")
{
Monitor mon = new Monitor();
mon = (Monitor)Session["SelectedMonitor"];
mon.Brand = txtBoxBrand.Text;
mon.Connectors = txtBoxConnectors.Text;
mon.DisplayText = txtBoxDisplayText.Text;
mon.Model = txtBoxModel.Text;
mon.Resolution = txtBoxResolution.Text;
mon.Size = txtBoxResolution.Text;
lblMessage.Text = Monitor.updateMonitor(mon);
btnAddMonitor.Text = "Add Monitor";
btnCancel.Visible = false;
refresh();
txtBoxSize.Text = "";
txtBoxBrand.Text = "";
txtBoxModel.Text = "";
txtBoxResolution.Text = "";
txtBoxConnectors.Text = "";
txtBoxDisplayText.Text = "";
lstBoxMonitor.SelectedIndex = 0;
}
}
public static string updateMonitor(Monitor mon)
{
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
{
string sql = "UPDATE Monitor SET Size = @Size, Brand = @Brand, Resolution = @Resolution, Connectors = @Connectors, Model = @Model, " +
" Display = @Display WHERE MonID= @MonID";
dbCmd.CommandText = sql;
dbCmd.Parameters.AddWithValue("Size", mon.Size);
dbCmd.Parameters.AddWithValue("Brand", mon.Brand);
dbCmd.Parameters.AddWithValue("Resolution", mon.Resolution);
dbCmd.Parameters.AddWithValue("Connectors", mon.Connectors);
dbCmd.Parameters.AddWithValue("Model", mon.Model);
dbCmd.Parameters.AddWithValue("Display", mon.DisplayText);
dbCmd.Parameters.AddWithValue("MonID", mon.ID);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
transaction.Commit();
dbConn.Close();
message.Append("Monitor updated successfully!");
return message.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
transaction.Rollback();
message.Append(ex.ToString());
return message.ToString();
}
}
public static string saveMonitor(Monitor mon)
{
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
{
String sqlCommand = "INSERT INTO Monitor (Size, Brand, Resolution, Connectors, Model, Display) " +
"VALUES (@Size, @Brand, @Resolution, @Connectors, @Model, @Display)";
dbCmd.CommandText = sqlCommand;
dbCmd.Parameters.AddWithValue("Size", mon.Size);
dbCmd.Parameters.AddWithValue("Brand", mon.Brand);
dbCmd.Parameters.AddWithValue("Resolution", mon.Resolution);
dbCmd.Parameters.AddWithValue("Connectors", mon.Connectors);
dbCmd.Parameters.AddWithValue("Model", mon.Model);
dbCmd.Parameters.AddWithValue("Display", mon.DisplayText);
dbCmd.ExecuteNonQuery();
transaction.Commit();
dbCmd.Parameters.Clear();
dbConn.Close();
message.Append("Monitor added successfully<bR>");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString());
transaction.Rollback();
}
return message.ToString();
}
public static List<Monitor> getMonitors()
{
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; ;
string sql = "SELECT MonID, Size, Brand, Resolution, Connectors, Model FROM Monitor";
dbCmd.CommandText = sql;
dbReader = dbCmd.ExecuteReader();
List<Monitor> monitorList = new List<Monitor>();
while (dbReader.Read())
{
Monitor mon = new Monitor();
mon.ID = Convert.ToInt32(dbReader["MonID"]);
mon.Size = dbReader["Size"].ToString();
mon.Brand = dbReader["Brand"].ToString();
mon.Resolution = dbReader["Resolution"].ToString();
mon.Connectors = dbReader["Connectors"].ToString();
mon.Model = dbReader["Model"].ToString();
monitorList.Add(mon);
}
dbReader.Close();
dbCmd.Parameters.Clear();
return monitorList;
}
public static Monitor getMonitor(int monID)
{
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 MonID, Size, Brand, Resolution, Connectors, Model, Display FROM Monitor WHERE MonID = @MonID";
dbCmd.CommandText = sql;
dbCmd.Parameters.AddWithValue("MonID", monID);
dbReader = dbCmd.ExecuteReader();
Monitor mon = new Monitor();
while (dbReader.Read())
{
mon.ID = Convert.ToInt32(dbReader["MonID"]);
mon.Size = dbReader["Size"].ToString();
mon.Brand = dbReader["Brand"].ToString();
mon.Resolution = dbReader["Resolution"].ToString();
mon.Connectors = dbReader["Connectors"].ToString();
mon.Model = dbReader["Model"].ToString();
mon.DisplayText = dbReader["Display"].ToString();
}
dbReader.Close();
dbCmd.Parameters.Clear();
transaction.Commit();
dbConn.Close();
return mon;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
transaction.Rollback();
return null;
}
}
public static List<Monitor> getMonitor(SqlCommand cmd, int compID)
{
SqlDataReader dbReader;
string sql = "SELECT Monitor.MonID, Size, Brand, Resolution, Connectors, Model, Display FROM MonitorComputer, Monitor WHERE MonitorComputer.MonID = Monitor.MonID AND MonitorComputer.CompID = @CompID";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("CompID", compID);
dbReader = cmd.ExecuteReader();
List<Monitor> monitors = new List<Monitor>();
while (dbReader.Read())
{
Monitor mon = new Monitor();
mon.ID = Convert.ToInt32(dbReader["MonID"]);
mon.Size = dbReader["Size"].ToString();
mon.Brand = dbReader["Brand"].ToString();
mon.Resolution = dbReader["Resolution"].ToString();
mon.Connectors = dbReader["Connectors"].ToString();
mon.Model = dbReader["Model"].ToString();
mon.DisplayText = dbReader["Display"].ToString();
monitors.Add(mon);
}
dbReader.Close();
cmd.Parameters.Clear();
return monitors;
}
public static string saveComputers(List<Computer> computers)
{
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 < computers.Count; i++)
{
Computer comp = (Computer)computers[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", 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("PhysicalAddress", comp.PhysicalAddress);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
//Get InvID
comp.InvID = ComputerDA.getInvID(dbCmd, comp.SerialNo);
//Insert Into Computer Table
sqlCommand = "INSERT INTO Computer (InvID, CPU, VideoCard, HardDrive, Memory, OpticalDrive, RemovableMedia, USBPorts, OtherConnectivity, FormFactor, Type) " +
"VALUES (@InvID, @CPU, @VideoCard, @HardDrive, @Memory, @OpticalDrive, @RemovableMedia, @USBPorts, @OtherConnectivity, @FormFactor, @Type)";
dbCmd.CommandText = sqlCommand;
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.ExecuteNonQuery();
dbCmd.Parameters.Clear();
comp.CompID = ComputerDA.getCompID(dbCmd, comp.InvID);
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", comp.InvID);
dbCmd.Parameters.AddWithValue("Building", comp.CurrentLocation.Building);
dbCmd.Parameters.AddWithValue("Room", comp.CurrentLocation.Room);
dbCmd.Parameters.AddWithValue("PrimaryUser", comp.CurrentLocation.PrimaryUser);
dbCmd.Parameters.AddWithValue("Name", comp.CurrentLocation.Name);
dbCmd.Parameters.AddWithValue("StartDate", DateTime.Now.ToShortDateString());
dbCmd.Parameters.AddWithValue("Status", "Active");
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
for (int j = 0; j < comp.Monitors.Count; j++)
{
sqlCommand = "INSERT INTO MonitorComputer (MonID, CompID) VALUES (@MonID, @CompID)";
dbCmd.CommandText = sqlCommand;
Monitor mon = new Monitor();
mon = (Monitor)comp.Monitors[j];
dbCmd.Parameters.AddWithValue("MonID", mon.ID);
dbCmd.Parameters.AddWithValue("CompID", comp.CompID);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
}
PODA.addLink(dbCmd, comp.InvID, comp.PO.ID);
GroupDA.updateGroups(dbCmd, comp.Groups, comp.InvID);
for (int j = 0; j < comp.Licenses.Count; j++)
{
License li = new License();
li = (License)comp.Licenses[j];
LicenseDA.addLicense(dbCmd, li.ID, comp.InvID);
}
for (int j = 0; j < comp.Warranties.Count; j++)
{
WarrantyDA.addWarranty(dbCmd, comp.InvID, (Warranty)comp.Warranties[j]);
}
}
transaction.Commit();
dbConn.Close();
message.Append("Operation successfull!<bR>");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append("Database Error: " + ex.ToString() + "<bR>");
transaction.Rollback();
}
return message.ToString();
}
public static string updateMonitor(Monitor mon)
{
return MonitorDA.updateMonitor(mon);
}
public static string saveMonitor(Monitor mon)
{
return MonitorDA.saveMonitor(mon);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
try
{
Monitor mon = new Monitor();
mon = Monitor.getMonitor(Convert.ToInt32(lstBoxMonitor.SelectedValue));
mon.ID = Convert.ToInt32(lstBoxMonitor.SelectedValue);
txtBoxSize.Text = mon.Size;
txtBoxBrand.Text = mon.Brand;
txtBoxModel.Text = mon.Model;
txtBoxResolution.Text = mon.Resolution;
txtBoxConnectors.Text = mon.Connectors;
txtBoxDisplayText.Text = mon.DisplayText;
Session["SelectedMonitor"] = mon;
btnAddMonitor.Text = "Update Monitor";
btnCancel.Visible = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
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();
}
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();
}