public List <clsBag> GetBrandBags(string b)
{
DataTable lcResult = clsDbConnection.GetDataTable("SELECT * FROM Bag WHERE bag_brand_id = '" + b + "'", null);;
List <clsBag> lcNames = new List <clsBag>();
foreach (DataRow dr in lcResult.Rows)
{
clsBag bb = new clsBag();
bb.bag_name = (string)dr["bag_name"];
bb.bag_price = Convert.ToDecimal(dr["bag_price"].ToString());
bb.bag_colour = (string)dr["bag_colour"];
bb.bag_size = (string)dr["bag_size"];
bb.bag_brand_id = (string)dr["bag_brand_id"];
bb.bag_catergory = Convert.ToChar(dr["bag_catergory"]);
if (!string.IsNullOrEmpty(Convert.ToString(dr["bag_condition"])))
{
bb.bag_condition = Convert.ToString(dr["bag_condition"]);
}
if (!string.IsNullOrEmpty(Convert.ToString(dr["bag_warranty"])))
{
bb.bag_warranty = Convert.ToString(dr["bag_warranty"]);
}
lcNames.Add(bb);
}
return(lcNames);
}
private Dictionary <string, object> prepareBagParameters(clsBag prBag)
{
Dictionary <string, object> par = new Dictionary <string, object>(10);
par.Add("bag_name", prBag.bag_name);
par.Add("bag_price", prBag.bag_price);
par.Add("bag_colour", prBag.bag_colour);
par.Add("bag_size", prBag.bag_size);
par.Add("bag_brand_id", prBag.bag_brand_id);
par.Add("bag_condition", prBag.bag_condition);
par.Add("bag_warranty", prBag.bag_warranty);
par.Add("bag_catergory", prBag.bag_catergory);
return(par);
}
public string PostBag(clsBag prBag)
{ // insert
try
{
int lcRecCount = clsDbConnection.Execute("INSERT INTO Bag " +
"VALUES (@bag_name, @bag_price, @bag_colour, @bag_size, @bag_brand_id, @bag_condition, @bag_warranty, @bag_catergory)",
prepareBagParameters(prBag));
if (lcRecCount == 1)
{
return("One Bag inserted");
}
else
{
return("Unexpected Bag insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string PutBag(clsBag prBag)
{ // update
try
{
int lcRecCount = clsDbConnection.Execute("UPDATE Bag SET " +
"bag_price = @bag_price, bag_condition = @bag_condition, bag_warranty = @bag_warranty " +
"WHERE bag_name=@bag_name",
prepareBagParameters(prBag));
if (lcRecCount == 1)
{
return("One Bag updated");
}
else
{
return("Unexpected Bag update count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
