//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- Updat ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Converts the object properties to SQL paramters and executes the update procedure.
/// </summary>
/// <param name="ItemsOrdersObj">Model object.</param>
/// <returns>The result of update query.</returns>
//--------------------------------------------------------------------
public bool Updat(ItemsOrdersModel ItemsOrdersObj)
{
bool result = false;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("[dbo].[ItemsOrders_Update]", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//----------------------------------------------------------------------------------------------
// Set the parameters
//----------------------------------------------------------------------------------------------
myCommand.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = ItemsOrdersObj.OrderID;
//myCommand.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = ItemsOrdersObj.UserId;
myCommand.Parameters.Add("@Status", SqlDbType.Int, 4).Value = ItemsOrdersObj.Status;
myCommand.Parameters.Add("@Comment", SqlDbType.NVarChar, 500).Value = ItemsOrdersObj.Comment;
//myCommand.Parameters.Add("@DateAdded", SqlDbType.DateTime2, 8).Value = ItemsOrdersObj.DateAdded;
//----------------------------------------------------------------------------------------------
// Execute the command
//----------------------------------------------------------------------------------------------
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
result = true;
}
myConnection.Close();
return result;
//----------------------------------------------------------------------------------------------
}
}
//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- Create ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Converts the object properties to SQL paramters and executes the create procedure
/// and updates the object with the SQL data by reference.
/// </summary>
/// <param name="ItemsOrdersObj">Model object.</param>
/// <returns>The result of create query.</returns>
//--------------------------------------------------------------------
public bool Create(ItemsOrdersModel ItemsOrdersObj, List<ItemsOrdersDetailsModel> productsList)
{
bool result = false;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("[dbo].[ItemsOrders_Create]", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//----------------------------------------------------------------------------------------------
// Set the parameters
//----------------------------------------------------------------------------------------------
myCommand.Parameters.Add("@OrderID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
myCommand.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = ItemsOrdersObj.UserId;
//myCommand.Parameters.Add("@Status", SqlDbType.Int, 4).Value = ItemsOrdersObj.Status;
myCommand.Parameters.Add("@Comment", SqlDbType.NVarChar, 500).Value = ItemsOrdersObj.Comment;
myCommand.Parameters.Add("@CustomerName", SqlDbType.NVarChar, 128).Value = ItemsOrdersObj.CustomerName;
myCommand.Parameters.Add("@CustomerEmail", SqlDbType.NVarChar, 128).Value = ItemsOrdersObj.CustomerEmail;
myCommand.Parameters.Add("@CustomerPhone", SqlDbType.NVarChar, 32).Value = ItemsOrdersObj.CustomerPhone;
myCommand.Parameters.Add("@CustomerMobile", SqlDbType.NVarChar, 32).Value = ItemsOrdersObj.CustomerMobile;
myCommand.Parameters.Add("@CustomerAddress", SqlDbType.NVarChar, 256).Value = ItemsOrdersObj.CustomerAddress;
//myCommand.Parameters.Add("@DateAdded", SqlDbType.DateTime2, 8).Value = ItemsOrdersObj.DateAdded;
//----------------------------------------------------------------------------------------------
// Execute the command
//----------------------------------------------------------------------------------------------
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
result = true;
//Get ID value from database and set it in object
ItemsOrdersObj.OrderID = (int)myCommand.Parameters["@OrderID"].Value;
SaveDetails(myConnection, ItemsOrdersObj.OrderID, productsList);
}
myConnection.Close();
return result;
//----------------------------------------------------------------------------------------------
}
}
//------------------------------------------------------------------------------------------------------
#endregion
#region --------------Updat--------------
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Updates model object by calling sql data provider update method.
/// </summary>
/// <param name="ItemsOrdersObj">The model object.</param>
/// <returns>The result of update operation.</returns>
//--------------------------------------------------------------------
public static bool Updat(ItemsOrdersModel ItemsOrdersObj)
{
return(ItemsOrdersSqlDataPrvider.Instance.Updat(ItemsOrdersObj));
}
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Creates model object by calling News data provider create method.
/// </summary>
/// <param name="ItemsOrdersObj">The model object.</param>
/// <returns>The result of create operation.</returns>
//--------------------------------------------------------------------
public static bool Create(ItemsOrdersModel ItemsOrdersObj, List <ItemsOrdersDetailsModel> productsList)
{
return(ItemsOrdersSqlDataPrvider.Instance.Create(ItemsOrdersObj, productsList));
}
//------------------------------------------------------------------------------------------------------
#endregion
#region /*--------- PopulateModelFromIDataReader ---------*\
//------------------------------------------------------------------------------------------------------
/// <summary>
/// Populates model from IDataReader .
/// </summary>
/// <param name="reader"></param>
/// <returns>Model object.</returns>
//--------------------------------------------------------------------
private ItemsOrdersModel PopulateModelFromIDataReader(IDataReader reader)
{
//Create a new object
ItemsOrdersModel ItemsOrdersObj = new ItemsOrdersModel();
//Fill the object with data
//------------------------------------------------
//OrderID
//------------------------------------------------
if (reader["OrderID"] != DBNull.Value)
ItemsOrdersObj.OrderID = (int)reader["OrderID"];
//------------------------------------------------
//------------------------------------------------
//[UserId]
//------------------------------------------------
if (reader["UserId"] != DBNull.Value)
ItemsOrdersObj.UserId = (Guid)reader["UserId"];
//------------------------------------------------
//------------------------------------------------
//[Status]
//------------------------------------------------
if (reader["Status"] != DBNull.Value)
ItemsOrdersObj.Status = (int)reader["Status"];
//------------------------------------------------
//------------------------------------------------
//[Comment]
//------------------------------------------------
if (reader["Comment"] != DBNull.Value)
ItemsOrdersObj.Comment = (string)reader["Comment"];
//------------------------------------------------
//------------------------------------------------
//[DateAdded]
//------------------------------------------------
if (reader["DateAdded"] != DBNull.Value)
ItemsOrdersObj.DateAdded = (DateTime)reader["DateAdded"];
//------------------------------------------------
//------------------------------------------------
//[CustomerName]
//------------------------------------------------
if (reader["CustomerName"] != DBNull.Value)
ItemsOrdersObj.CustomerName = (string)reader["CustomerName"];
//------------------------------------------------
//[CustomerEmail]
//------------------------------------------------
if (reader["CustomerEmail"] != DBNull.Value)
ItemsOrdersObj.CustomerEmail = (string)reader["CustomerEmail"];
//------------------------------------------------
//[CustomerPhone]
//------------------------------------------------
if (reader["CustomerPhone"] != DBNull.Value)
ItemsOrdersObj.CustomerPhone = (string)reader["CustomerPhone"];
//------------------------------------------------
//[CustomerMobile]
//------------------------------------------------
if (reader["CustomerMobile"] != DBNull.Value)
ItemsOrdersObj.CustomerMobile = (string)reader["CustomerMobile"];
//------------------------------------------------
//[CustomerAddress]
//------------------------------------------------
if (reader["CustomerAddress"] != DBNull.Value)
ItemsOrdersObj.CustomerAddress = (string)reader["CustomerAddress"];
//------------------------------------------------
//Return the populated object
return ItemsOrdersObj;
}