public void UpdateDrum(DrumDO drumDO)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand commandUpdateDrum = new SqlCommand("sp_UpdateDrumInfo", sqlConnection);
try
{
commandUpdateDrum.CommandType = CommandType.StoredProcedure;
commandUpdateDrum.Parameters.AddWithValue("@DrumID", drumDO.DrumID);
commandUpdateDrum.Parameters.AddWithValue("@BrandName", drumDO.BrandName);
commandUpdateDrum.Parameters.AddWithValue("@DrumType", drumDO.DrumType);
commandUpdateDrum.Parameters.AddWithValue("@DrumDescription", drumDO.DrumDescription);
commandUpdateDrum.Parameters.AddWithValue("@DrumQuantity", drumDO.DrumQuantity);
commandUpdateDrum.Parameters.AddWithValue("@DrumPrice", drumDO.DrumPrice);
commandUpdateDrum.Parameters.AddWithValue("@DrumImgURL", drumDO.DrumImgURL);
sqlConnection.Open();
commandUpdateDrum.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
DataErrorLogger.ErrorLogger("Update Drum", DateTime.Now, sqlEx.Message);
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
}
public static DrumDO MapDrumPOtoDO(DrumPO from)
{
DrumDO to = new DrumDO();
to.AccountID = from.AccountID;
to.DrumID = from.DrumID;
to.BrandName = from.BrandName;
to.DrumType = from.DrumType;
to.DrumDescription = from.DrumDescription;
to.DrumPrice = from.DrumPrice;
to.DrumQuantity = from.DrumQuantity;
to.DrumImgURL = from.DrumImgURL;
return(to);
}
public ActionResult AddDrumProduct(ProductModel drumModel)
{
if (ModelState.IsValid)
{
drumModel.aDrum.AccountID = (int)Session["AccountID"];
DrumDO drumDO = MappingMethods.MapDrumPOtoDO(drumModel.aDrum);
dataMethods.CreateDrum(drumDO);
return(RedirectToAction("ViewProducts", "StoreManager"));
}
else
{
return(View());
}
}
public ActionResult PlaceOrder()
{
ProductModel cart = new ProductModel();
cart = (ProductModel)Session["ShoppingCart"];
foreach (DrumPO drum in cart.drumList)
{
DrumDO drumDO = new DrumDO();
drumDO = MappingMethods.MapDrumPOtoDO(drum);
dataMethods.UpdateDrumQuantity(drum.DrumID, drum.CheckoutQty);
DrumPO drumPO = MappingMethods.MapDrumDOtoPO(drumDO);
}
foreach (CymbalPO cymbal in cart.cymbalList)
{
CymbalDO cymbalDO = new CymbalDO();
cymbalDO = MappingMethods.MapCymbalPOtoDO(cymbal);
dataMethods.UpdateCymbalQty(cymbal.CymbalID, cymbal.CheckoutQty);
CymbalPO cymbalPO = MappingMethods.MapCymbalDOtoPO(cymbalDO);
}
cart.cymbalList.Clear();
cart.drumList.Clear();
return(View());
}
public DrumDO GetDrumInfoByID(int DrumID)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand commandGetDrumInfoByID = new SqlCommand("sp_GetDrumInfoByID", sqlConnection);
DrumDO drumDO = new DrumDO();
try
{
commandGetDrumInfoByID.CommandType = CommandType.StoredProcedure;
commandGetDrumInfoByID.Parameters.AddWithValue("@DrumID", DrumID);
sqlConnection.Open();
using (SqlDataReader reader = commandGetDrumInfoByID.ExecuteReader())
{
while (reader.Read())
{
drumDO.AccountID = Convert.ToInt32(reader["AccountID"]);
drumDO.DrumID = Convert.ToInt32(reader["DrumID"]);
drumDO.BrandName = (string)reader["BrandName"];
drumDO.DrumType = (string)reader["DrumType"];
drumDO.DrumDescription = (string)reader["DrumDescription"];
drumDO.DrumPrice = (decimal)reader["DrumPrice"];
drumDO.DrumQuantity = (int)reader["DrumQuantity"];
drumDO.DrumImgURL = (string)reader["DrumImgURL"];
}
}
}
catch (SqlException sqlEx)
{
DataErrorLogger.ErrorLogger("Get Drum info by ID", DateTime.Now, sqlEx.Message);
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
return(drumDO);
}
