//Methodology
/// <summary>
/// Them don hang moi
/// </summary>
/// Tra ve: Don hang duoc them
public static bool m2018_InsertNewOrder(ORDER_CLIENT item, ORDER_GOODS[] lstGood)
{
bool Result = true;
using (DbTransaction DbTransaction = clsConnect.DbConnection.BeginTransaction())
{
using (DbCommand DbCommand = clsConnect.DbConnection.CreateCommand())
{
DbCommand.CommandText = SpMobile_2018_InsertOrders;
DbCommand.CommandType = System.Data.CommandType.StoredProcedure;
DbCommand.Transaction = DbTransaction;
ORDER_CLIENT.CreateParameterCollection <ORDER_CLIENT>(DbCommand, item);
try
{
DbCommand.ExecuteNonQuery();
}
catch (DbException DbException)
{
DbTransaction.Rollback();
Result = false;
return(Result);
}
}
foreach (var itemGood in lstGood)
{
try
{
m2018_InsertGoodToOrder(itemGood, DbTransaction);
}
catch (DbException DbException)
{
DbTransaction.Rollback();
Result = false;
return(Result);
}
}
DbTransaction.Commit();
return(Result);
}
}
