public static void Insert(Restaurant restaurant)
{
OperationsLogs.WriteLogsDebug("VentaBrl", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(),
"Empezando a ejecutar el método lógica de negocio para crear un Venta"));
try
{
RestaurantDal.Insert(restaurant);
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("VentaBrl", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("VentaBrl", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
throw ex;
}
OperationsLogs.WriteLogsDebug("VentaBrl", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(), DateTime.Now.ToString(),
"Termino de ejecutar el método lógica de negocio para insertar Venta"));
}
public List<OrderSummary> GetUserOrders(string memberCardNo)
{
List<OrderSummary> list = new List<OrderSummary>();
using (var SqlConn = ConnectionProvider.GetConnection())
{
var SqlCmd = new SqlCommand();
SqlCmd.Connection = SqlConn;
SqlCmd.CommandText = @"
select o.Id AS OrderId,o.ContactName,o.ContactPhone,o.DiningDate,o.DiningDate,o.CreateDate,
o.Status,o.RstId AS RestaurantId,o.PersonCount, os.OrderStatus, os.LastUpdateTime,
-- Caculates order total price
case when pr.PrepayMoney is NULL then
(select SUM(od.ProductCount * od.UnitPrice) from OrderDetails od where od.OrderId=o.Id)
else pr.PrepayMoney end as TotalMoney
from orders o
left join OrderStatus os on os.OrderId = o.Id
left join PrepayRecord pr on pr.SId = convert(nvarchar(50), o.Id)
where
((pr.AddMoney = pr.PrepayMoney and pr.AddMoney <= 0) or (pr.AddMoney is null and pr.PrepayMoney is null))
and o.MemberCardNo=@MemberCardNo
order by o.CreateDate desc;
";
SqlCmd.Parameters.AddWithValue(@"MemberCardNo", memberCardNo);
var reader = SqlCmd.ExecuteReader();
while (reader.Read())
{
if (reader["TotalMoney"] == DBNull.Value)
{ continue; }
var summary = new OrderSummary();
summary.OrderId = Guid.Parse(reader["OrderId"].ToString());
summary.ContactName = reader["ContactName"].ToString();
if (reader["ContactPhone"] != DBNull.Value)
{
summary.ContactPhone = reader["ContactPhone"].ToString();
}
if (reader["PersonCount"] != DBNull.Value)
{
summary.PersonCount = Convert.ToInt32(reader["PersonCount"]);
}
if (reader["OrderStatus"] != DBNull.Value)
{
summary.Status = Convert.ToString(reader["OrderStatus"]);
}
if (reader["DiningDate"] != DBNull.Value)
{
summary.DiningDate = Convert.ToDateTime(reader["DiningDate"]);
}
if (reader["TotalMoney"] != DBNull.Value)
{
summary.TotalMoney = Math.Abs(Convert.ToDecimal(reader["TotalMoney"]));
}
summary.RestaurantId = Guid.Parse(reader["RestaurantId"].ToString());
summary.CreateTime = Convert.ToDateTime(reader["CreateDate"]);
summary.Backlog = "无";
list.Add(summary);
}
}
if (list != null && list.Count > 0)
{
RestaurantDal restaurantDal = new RestaurantDal();
foreach (var item in list)
{
item.RestaurantName = restaurantDal.GetRestaurantName(item.RestaurantId);
}
}
return list;
}
