public void UpdateCymbal(CymbalDO cymbalDO)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand commandUpdateCymbal = new SqlCommand("sp_UpdateCymbalInfo", sqlConnection);
try
{
commandUpdateCymbal.CommandType = CommandType.StoredProcedure;
commandUpdateCymbal.Parameters.AddWithValue("@CymbalID", cymbalDO.CymbalID);
commandUpdateCymbal.Parameters.AddWithValue("@BrandName", cymbalDO.BrandName);
commandUpdateCymbal.Parameters.AddWithValue("@CymbalName", cymbalDO.CymbalName);
commandUpdateCymbal.Parameters.AddWithValue("@CymbalDescription", cymbalDO.CymbalDescription);
commandUpdateCymbal.Parameters.AddWithValue("@CymbalPrice", cymbalDO.CymbalPrice);
commandUpdateCymbal.Parameters.AddWithValue("@CymbalQuantity", cymbalDO.CymbalQuantity);
commandUpdateCymbal.Parameters.AddWithValue("@CymbalImgURL", cymbalDO.CymbalImgURL);
sqlConnection.Open();
commandUpdateCymbal.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
DataErrorLogger.ErrorLogger("Update Cymbal", DateTime.Now, sqlEx.Message);
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
}
public ActionResult AddCymbalProduct(ProductModel cymbalModel)
{
cymbalModel.aCymbal.AccountID = (int)Session["AccountID"];
CymbalDO cymbalDO = MappingMethods.MapCymbalPOtoDO(cymbalModel.aCymbal);
dataMethods.CreateCymbal(cymbalDO);
return(RedirectToAction("ViewProducts", "StoreManager"));
}
public static CymbalDO MapCymbalPOtoDO(CymbalPO from)
{
CymbalDO to = new CymbalDO();
to.AccountID = from.AccountID;
to.CymbalID = from.CymbalID;
to.BrandName = from.BrandName;
to.CymbalDescription = from.CymbalDescription;
to.CymbalName = from.CymbalName;
to.CymbalPrice = from.CymbalPrice;
to.CymbalQuantity = from.CymbalQuantity;
to.CymbalImgURL = from.CymbalImgURL;
return(to);
}
public CymbalDO GetCymbalInfoByID(int cymbalID)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand commandGetCymbalInfo = new SqlCommand("sp_GetCymbalInfoByID", sqlConnection);
CymbalDO cymbalDO = new CymbalDO();
try
{
commandGetCymbalInfo.CommandType = CommandType.StoredProcedure;
commandGetCymbalInfo.Parameters.AddWithValue("@CymbalID", cymbalID);
sqlConnection.Open();
using (SqlDataReader reader = commandGetCymbalInfo.ExecuteReader())
{
while (reader.Read())
{
cymbalDO.AccountID = Convert.ToInt32(reader["AccountID"]);
cymbalDO.CymbalID = Convert.ToInt32(reader["CymbalID"]);
cymbalDO.BrandName = (string)reader["BrandName"];
cymbalDO.CymbalName = (string)reader["CymbalName"];
cymbalDO.CymbalDescription = (string)reader["CymbalDescription"];
cymbalDO.CymbalPrice = (decimal)reader["CymbalPrice"];
cymbalDO.CymbalQuantity = Convert.ToInt32(reader["CymbalQuantity"]);
cymbalDO.CymbalImgURL = (string)reader["CymbalImgURL"];
}
}
}
catch (SqlException sqlEx)
{
DataErrorLogger.ErrorLogger("Get Cymbal info by ID", DateTime.Now, sqlEx.Message);
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
return(cymbalDO);
}
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());
}