//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- Updat ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Converts the object properties to SQL paramters and executes the update procedure.
/// </summary>
/// <param name="ItemsOrdersDetailsObj">Model object.</param>
/// <returns>The result of update query.</returns>
//--------------------------------------------------------------------
public bool Updat(ItemsOrdersDetailsModel ItemsOrdersDetailsObj)
{
bool result = false;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("[dbo].[ItemsOrdersDetails_Update]", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//----------------------------------------------------------------------------------------------
// Set the parameters
//----------------------------------------------------------------------------------------------
myCommand.Parameters.Add("@ItemID", SqlDbType.Int, 4).Value = ItemsOrdersDetailsObj.ItemID;
myCommand.Parameters.Add("@Title", SqlDbType.NVarChar, 128).Value = ItemsOrdersDetailsObj.Title;
myCommand.Parameters.Add("@Price", SqlDbType.NVarChar, 128).Value = ItemsOrdersDetailsObj.Price;
myCommand.Parameters.Add("@Quantity", SqlDbType.Int, 4).Value = ItemsOrdersDetailsObj.Quantity;
//----------------------------------------------------------------------------------------------
// Execute the command
//----------------------------------------------------------------------------------------------
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
result = true;
}
myConnection.Close();
return result;
//----------------------------------------------------------------------------------------------
}
}
//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- PopulateModelFromIDataReader ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Populates model from IDataReader .
/// </summary>
/// <param name="reader"></param>
/// <returns>Model object.</returns>
//--------------------------------------------------------------------
private ItemsOrdersDetailsModel PopulateModelFromIDataReader(IDataReader reader)
{
//Create a new object
ItemsOrdersDetailsModel ItemsOrdersDetailsObj = new ItemsOrdersDetailsModel();
//Fill the object with data
//------------------------------------------------
//ItemID
//------------------------------------------------
if (reader["ItemID"] != DBNull.Value)
ItemsOrdersDetailsObj.ItemID = (int)reader["ItemID"];
//------------------------------------------------
//------------------------------------------------
//[Title]
//------------------------------------------------
if (reader["Title"] != DBNull.Value)
ItemsOrdersDetailsObj.Title = (string)reader["Title"];
//------------------------------------------------
//------------------------------------------------
//[Price]
//------------------------------------------------
if (reader["Price"] != DBNull.Value)
ItemsOrdersDetailsObj.Price = (string)reader["Price"];
//------------------------------------------------
//------------------------------------------------
//[Quantity]
//------------------------------------------------
if (reader["Quantity"] != DBNull.Value)
ItemsOrdersDetailsObj.Quantity = (int)reader["Quantity"];
//------------------------------------------------
//[CurrentPrice]
//------------------------------------------------
if (reader["CurrentPrice"] != DBNull.Value)
ItemsOrdersDetailsObj.CurrentPrice = (string)reader["CurrentPrice"];
//------------------------------------------------
//[Barcode]
//------------------------------------------------
if (reader["Barcode"] != DBNull.Value)
ItemsOrdersDetailsObj.Barcode = (string)reader["Barcode"];
//------------------------------------------------
//[ByUnit]
//------------------------------------------------
if (reader["ByUnit"] != DBNull.Value)
ItemsOrdersDetailsObj.ByUnit = (string)reader["ByUnit"];
//------------------------------------------------
//[ByCarton]
//------------------------------------------------
if (reader["ByCarton"] != DBNull.Value)
ItemsOrdersDetailsObj.ByCarton = (string)reader["ByCarton"];
//------------------------------------------------
//Return the populated object
return ItemsOrdersDetailsObj;
}
public static void AddToCart(int itemID, ref ItemsEntity item, ref ItemCategoriesEntity category)
{
Guid OwnerID = SitesHandler.GetOwnerIDAsGuid();
//---------------------------------------------------------
Languages langID = SiteSettings.GetCurrentLanguage();
if (item == null)
{
item = ItemsFactory.GetObject(itemID, langID, UsersTypes.User, OwnerID);
}
if (category == null)
{
category = ItemCategoriesFactory.GetObject(item.CategoryID, langID, OwnerID);
}
if (item != null && category != null)
{
List <ItemsOrdersDetailsModel> CartList = GetCartList();
//---------------------------------------------------------
bool existIntoCart = false;
foreach (ItemsOrdersDetailsModel p in CartList)
{
if (p.ItemID == itemID)
{
p.Quantity += 1;
existIntoCart = true;
break;
}
}
if (!existIntoCart)
{
ItemsOrdersDetailsModel newP = new ItemsOrdersDetailsModel();
newP.ItemID = itemID;
newP.Quantity = 1;
CartList.Add(newP);
}
//---------------------------------------------------------
//Session["Cart"] = CartList;
}
}
//------------------------------------------------------------------------------------------------------
#endregion
#region --------------Updat--------------
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Updates model object by calling sql data provider update method.
/// </summary>
/// <param name="ItemsOrdersDetailsObj">The model object.</param>
/// <returns>The result of update operation.</returns>
//--------------------------------------------------------------------
public static bool Updat(ItemsOrdersDetailsModel ItemsOrdersDetailsObj)
{
return(ItemsOrdersDetailsSqlDataPrvider.Instance.Updat(ItemsOrdersDetailsObj));
}