private Dictionary <string, object> prepareComputerParameters(clsAllComputers prComputers)
{
Dictionary <string, object> par = new Dictionary <string, object>(12);
//par.Add("ComputerID", prComputers.ComputerID);
par.Add("Name", prComputers.Name);
par.Add("Price", prComputers.Price);
par.Add("LastModified", prComputers.LastModified);
par.Add("Quantity", prComputers.Quantity);
par.Add("Type", prComputers.Type);
par.Add("Ram", prComputers.Ram);
par.Add("HDD", prComputers.HDD);
par.Add("Graphics", prComputers.Graphics);
par.Add("Color", prComputers.Color);
par.Add("TowerType", prComputers.TowerType);
par.Add("BrandName", prComputers.BrandName);
return(par);
}
//Updating the database if any changes are done to a computer
public string UpdateComputer(clsAllComputers prComputers)
{
try
{
int lcRecCount = clsDbConnectioncs.Execute("UPDATE tbl_computer SET " +
"Name = @Name, Price = @Price, LastModified = @LastModified, Quantity = @Quantity, Type = @Type, Ram = @Ram, " +
"HDD = @HDD, Graphics = @Graphics, Color = @Color, TowerType = @TowerType",
prepareComputerParameters(prComputers));
if (lcRecCount == 1)
{
return("One Computer Updated");
}
else
{
return("Unexepected Computer insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
//inserting a new computer into the database
public string InsertComputer(clsAllComputers prComputers)
{
try
{
int lcRecCount = clsDbConnectioncs.Execute("INSERT INTO tbl_computer " +
"(Name, Price, LastModified, Quantity, Type, Ram, HDD, Graphics, Color, TowerType, BrandName)" +
"VALUES (@Name, @Price, @LastModified, @Quantity, @Type, @Ram, @HDD, @Graphics, @Color, @TowerType, @BrandName)",
prepareComputerParameters(prComputers));
if (lcRecCount == 1)
{
return("One Computer inserted");
}
else
{
return("Unexepected Computer insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
