public static Transfer getTransfer(SqlCommand cmd, int InvID)
{
SqlDataReader dbReader;
string sql = "SELECT Transfers.TransID, Transfers.Name, Transfers.Date, Transfers.Whereto, Transfers.Notes " +
"FROM Transfers, TransferInventory WHERE Transfers.TransID = TransferInventory.TransID AND "
+ "TransferInventory.InvID = @InvID";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("InvID", InvID);
dbReader = cmd.ExecuteReader();
Transfer trans = new Transfer();
while (dbReader.Read())
{
trans.ID = Convert.ToInt32(dbReader["TransID"]);
trans.Date = Convert.ToString(dbReader["Date"]);
trans.Where = Convert.ToString(dbReader["Whereto"]);
trans.Notes = Convert.ToString(dbReader["Notes"]);
}
dbReader.Close();
cmd.Parameters.Clear();
return trans;
}
public Computer()
{
monitors = new List<Monitor>();
po = new PurchaseOrder();
groups = new List<Group>();
logistics = new List<Logistics>();
currentLocation = new Logistics();
licenses = new List<License>();
warranties = new List<Warranty>();
transfer = new Transfer();
}
public static string saveTransfer(Transfer transfer)
{
return TransferDA.saveTransfer(transfer);
}
protected void btnCreateTransfer_Click(object sender, EventArgs e)
{
Transfer transfer = new Transfer();
transfer.Date = txtBoxDate.Text;
transfer.Notes = txtBoxNotes.Text;
transfer.Where = txtBoxWhere.Text;
for (int i = 0; i < lstBoxSerialNos.Items.Count; i++)
{
transfer.Inventory.Add(lstBoxSerialNos.Items[i].Text);
}
lblTransferMessage.Text = Transfer.saveTransfer(transfer);
lblTransferMessage.Visible = true;
btnClearMessage.Visible = true;
}
public static string saveTransfer(Transfer transfer)
{
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;
int invCount = 0;
try
{
string sqlCommand = "INSERT INTO Transfers (Date, Whereto, Notes) " +
"VALUES (@Date, @Whereto, @Notes)";
dbCmd.CommandText = sqlCommand;
dbCmd.Parameters.AddWithValue("Date", transfer.Date);
dbCmd.Parameters.AddWithValue("Whereto", transfer.Where);
dbCmd.Parameters.AddWithValue("Notes", transfer.Notes);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
int transferID = TransferDA.getTransferID(dbCmd, transfer.Name);
for (int i = 0; i < transfer.Inventory.Count; i++)
{
string serialNo = transfer.Inventory[i].ToString();
if (ComputerDA.computerExist(dbCmd, serialNo) == true || EquipmentDA.equipmentExist(dbCmd, serialNo) == true)
{
if (ComputerDA.computerTransferred(dbCmd, serialNo) == false)
{
int invId = 0;
invId = ComputerDA.getInvID(dbCmd, serialNo);
if (invId < 1)
{
invId = EquipmentDA.getInvID(dbCmd, serialNo);
}
GroupDA.removeLinks(dbCmd, invId);
ComputerDA.transferComputer(dbCmd, invId);
MonitorDA.deleteMonitors(dbCmd, invId);
LicenseDA.removeLicenses(dbCmd, invId);
sqlCommand = "INSERT INTO TransferInventory (TransID, InvID) " +
"VALUES (@TransID, @InvID)";
dbCmd.CommandText = sqlCommand;
dbCmd.Parameters.AddWithValue("TransID", transferID);
dbCmd.Parameters.AddWithValue("InvID", invId);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
invCount++;
}
else
{
message.Append("Inventory item with Serial Number " + serialNo + " is already transferred and has not been added to this transfer.<bR>");
}
}
else
{
message.Append("Inventory with Serial Number " + serialNo + " does not exist and has not been added to this transfer.<bR>");
}
}
if (invCount == 0)
{
message.Append("There were no current inventory items on this transfer, therefore the transfer has not been created.");
transaction.Rollback();
}
else
{
transaction.Commit();
message.Append("Operation Successful!");
}
dbConn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString() + "<bR>");
transaction.Rollback();
}
return message.ToString();
}