public int insertOrdersDA(BusinessEntitiesBS.UserEntities.OrderItems orderitems)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[10];
//User parameters
sqlParams[0] = new SqlParameter("@userId", orderitems.userid);
sqlParams[1] = new SqlParameter("@purchaseDate", orderitems.purchaseDate);
sqlParams[2] = new SqlParameter("@ItemString", orderitems.cartItems);
sqlParams[3] = new SqlParameter("@totalPrice", orderitems.totalBill);
sqlParams[4] = new SqlParameter("@Address", orderitems.ShippingAdr);
sqlParams[5] = new SqlParameter("@totalItems", orderitems.totalItems);
sqlParams[6] = new SqlParameter("@separator", ';');
sqlParams[7] = new SqlParameter("@separator2", ',');
sqlParams[8] = new SqlParameter("@SizeString", orderitems.TypeItem);
sqlParams[9] = new SqlParameter("@areaId", orderitems.areaId);
DataTable idDt = DBHelper.ExecuteDataset(DBCommon.ConnectionString, "USP_INSERT_ORDER_ITEMS", sqlParams).Tables[0];
int returnedId = Convert.ToInt32(idDt.Rows[0].ItemArray[0].ToString());
if (idDt.Rows.Count > 0)
{
return(returnedId);
}
else
{
return(-1);
}
}
catch (SqlException exc)
{
throw exc;
return(-1);
}
}
public int insertOrders(BusinessEntitiesBS.UserEntities.OrderItems orderitems)
{
IUserDA orderInsert = new DataAccessBS.UserClasses.UserDA();
return(orderInsert.insertOrdersDA(orderitems));
}
