public OperationsStatus AddProductToCart(ShoppingCart cartObj)
{
OperationsStatus operationsStatusObj = new OperationsStatus();
try
{
SqlParameter statusCode = null;
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[InsertShoppingCart]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = cartObj.ProductID;
cmd.Parameters.Add("@CustomerID", SqlDbType.Int).Value = cartObj.CustomerID;
cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = cartObj.ItemID;
cmd.Parameters.Add("@ProductSpecXML", SqlDbType.Xml).Value = _attributesRepository.GetAttributeXML(cartObj.AttributeValues);
cmd.Parameters.Add("@Qty", SqlDbType.Int).Value = cartObj.Qty;
cmd.Parameters.Add("@CurrencyCode", SqlDbType.NVarChar, 3).Value = cartObj.CurrencyCode;
cmd.Parameters.Add("@CurrencyRate", SqlDbType.Decimal).Value = cartObj.CurrencyRate;
cmd.Parameters.Add("@Price", SqlDbType.Decimal).Value = cartObj.Price;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 250).Value = cartObj.logDetails.CreatedBy;
cmd.Parameters.Add("@CreatedDate", SqlDbType.SmallDateTime).Value = cartObj.logDetails.CreatedDate;
statusCode = cmd.Parameters.Add("@StatusOut", SqlDbType.SmallInt);
statusCode.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
switch (statusCode.Value.ToString())
{
case "0":
operationsStatusObj.StatusCode = Int16.Parse(statusCode.Value.ToString());
operationsStatusObj.StatusMessage = constObj.InsertFailure;
break;
case "1":
operationsStatusObj.StatusCode = Int16.Parse(statusCode.Value.ToString());
operationsStatusObj.StatusMessage = constObj.InsertSuccess;
break;
default:
break;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(operationsStatusObj);
}
public OperationsStatus InsertBookings(Bookings bookingsObj)
{
OperationsStatus operationsStatusObj = new OperationsStatus();
try
{
SqlParameter statusCode = null;
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[InsertBookings]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = bookingsObj.ProductID;
cmd.Parameters.Add("@CustomerID", SqlDbType.Int).Value = bookingsObj.CustomerID;
cmd.Parameters.Add("@RequiredDate", SqlDbType.SmallDateTime).Value = bookingsObj.RequiredDate;
cmd.Parameters.Add("@SourceIP", SqlDbType.NVarChar, 50).Value = bookingsObj.SourceIP;
cmd.Parameters.Add("@Qty", SqlDbType.Int).Value = bookingsObj.Qty;
cmd.Parameters.Add("@Price", SqlDbType.Decimal).Value = bookingsObj.Price;
cmd.Parameters.Add("@AdditionalCharges", SqlDbType.Decimal).Value = bookingsObj.AdditionalCharges;
cmd.Parameters.Add("@TaxAmt", SqlDbType.Decimal).Value = bookingsObj.TaxAmt;
cmd.Parameters.Add("@DiscountAmt", SqlDbType.Decimal).Value = bookingsObj.DiscountAmt;
cmd.Parameters.Add("@Message", SqlDbType.NVarChar, -1).Value = bookingsObj.Message;
cmd.Parameters.Add("@ProductSpecXML", SqlDbType.Xml).Value = _attributesRepository.GetAttributeXML(bookingsObj.AttributeValues);
cmd.Parameters.Add("@CustomerAddressID", SqlDbType.Int).Value = bookingsObj.CustomerAddress.ID;
cmd.Parameters.Add("@BillLocation", SqlDbType.Int).Value = bookingsObj.CustomerAddress.LocationID;
cmd.Parameters.Add("@BillPrefix", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.Prefix;
cmd.Parameters.Add("@BillFirstName", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.FirstName;
cmd.Parameters.Add("@BillMidName", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.MidName;
cmd.Parameters.Add("@BillLastName", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.LastName;
cmd.Parameters.Add("@BillAddress", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.Address;
cmd.Parameters.Add("@BillCity", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.City;
cmd.Parameters.Add("@BillCountryCode", SqlDbType.NVarChar, 3).Value = bookingsObj.CustomerAddress.CountryCode;
cmd.Parameters.Add("@BillStateProvince", SqlDbType.NVarChar, 100).Value = bookingsObj.CustomerAddress.StateProvince;
cmd.Parameters.Add("@BillContactNo", SqlDbType.NVarChar, 20).Value = bookingsObj.CustomerAddress.ContactNo;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 250).Value = bookingsObj.logDetails.CreatedBy;
cmd.Parameters.Add("@CreatedDate", SqlDbType.SmallDateTime).Value = bookingsObj.logDetails.CreatedDate;
statusCode = cmd.Parameters.Add("@StatusOut", SqlDbType.SmallInt);
statusCode.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
switch (statusCode.Value.ToString())
{
case "0":
operationsStatusObj.StatusCode = Int16.Parse(statusCode.Value.ToString());
operationsStatusObj.StatusMessage = constObj.InsertFailure;
break;
case "1":
operationsStatusObj.StatusCode = Int16.Parse(statusCode.Value.ToString());
operationsStatusObj.StatusMessage = constObj.InsertSuccess;
break;
default:
break;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(operationsStatusObj);
}