public async Task <ActionResult <Response <IEnumerable <DtoOrder> > > > GetOrderById([FromRoute] int idOrder)
{
try
{
if (idOrder == 0)
{
return(BadRequest(new Response <string>()
{
Error = "IdOrder can't be equal to 0", Succes = true
}));
}
var result = await BsOrder.GetById <DtoOrder>(idOrder);
if (result == null)
{
return(NotFound(new Response <string>()
{
Error = "The Order doesn't exist", Succes = true
}));
}
return(Ok(new Response <DtoOrder>()
{
Error = "", Data = result, Succes = true
}));
}
catch (Exception e)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response <string[]>()
{
Error = e.Message, Data = e.StackTrace.Split("\r\n"), Succes = false
}));
}
}
protected void Page_Load(object sender, EventArgs e)
{
BsOrder order = new BsOrder();
order.State = 1;
MembershipUser user = Membership.GetUser(Page.User.Identity.Name);;
order.UserID = (Guid)user.ProviderUserKey;
int orderID = orderBLL.AddBsOrder(order, Profile.BsCartBLL.FindItems());
}
public BsOrder FindBsOrder(int id)
{
BsOrder bsOrder = null;
string sql = String.Format("select ID,UserID,Date,State from BsOrder where id={0}", id);
SqlDataReader sdr = SqlHelper.ExecuteReader(sql);
if (sdr.Read())
{
bsOrder = new BsOrder(sdr.GetInt32(0), sdr.GetGuid(1), sdr.GetDateTime(2), sdr.GetInt32(3));
}
sdr.Close();
return(bsOrder);
}
public int AddBsOrder(BsOrder order, ICollection <CartItem> items)
{
string sql = String.Format("insert into BsOrder(UserID, State) values ('{0}', {1});", order.UserID, 0);
//string sql = String.Format("insert into BsOrder(UserID, State) values ('{0}');", order.UserID);
foreach (CartItem item in items)
{
sql += String.Format("insert into BsDetail(OrderID,BookID,Quantity,Price) values (IDENT_CURRENT( 'BsOrder' ),{0},{1},{2});", item.ID, item.Quantity, item.Price);
}
SqlHelper.ExecuteNonQuery(sql);
sql = String.Format("select top 1 ID from BsOrder where UserID='{0}' order by ID desc;", order.UserID);
return((int)SqlHelper.ExecuteScalar(sql));
}
public async Task <ActionResult <Response <IEnumerable <DtoOrder> > > > GetAllOrder()
{
try
{
return(Ok(new Response <IEnumerable <DtoOrder> >()
{
Error = "", Data = await BsOrder.GetAll <DtoOrder>(), Succes = true
}));
}
catch (Exception e)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response <string[]>()
{
Error = e.Message, Data = e.StackTrace.Split("\r\n"), Succes = false
}));
}
}
private void AddOrder()
{
Panel1.Visible = false;
MembershipUser user = Membership.GetUser(Page.User.Identity.Name);
BsOrder order = new BsOrder();
order.UserID = (Guid)user.ProviderUserKey;
//Console.WriteLine(order.UserID);
order.State = 1;
//System.Diagnostics.Debug.WriteLine(order.UserID);
int orderID = orderBLL.AddBsOrder(order, Profile.BsCartBLL.FindItems());
//清空购物车
Profile.BsCartBLL.DeleteAll();
Profile.Save();
Literal1.Text = "结账成功!订单号为：" + orderID + " <a href='" + "OrderFind.aspx?userID=" + (Guid)user.ProviderUserKey + "'>查询订单</a>";
}
public IList <BsOrder> FindBsOrders(Guid UserId, int state)
{
IList <BsOrder> list = new List <BsOrder>();;
string sql = String.Format("select * from BsOrder where {0} UserId='{1}'", (state == -1 ? "" : "b.state=" + state + " and"), UserId);
DataTable dt = SqlHelper.ExecuteQuery(sql);
if (dt != null)
{
BsOrder bsOrder = null;
foreach (DataRow row in dt.Rows)
{
bsOrder = new BsOrder();
bsOrder.ID = Int32.Parse(row["ID"].ToString());
bsOrder.UserID = new Guid(row["UserId"].ToString());
bsOrder.Date = DateTime.Parse(row["date"].ToString());
bsOrder.State = Int32.Parse(row["State"].ToString());
list.Add(bsOrder);
}
}
return(list);
}
public IList <BsOrder> FindBsOrders(string username, int state)
{
IList <BsOrder> list = new List <BsOrder>();
string sql = String.Format("select a.UserName,b.* from aspnet_users a,BsOrder b where a.UserId=b.UserId and {0} a.UserName like '%{1}%'", (state == -1 ? "" : "b.state=" + state + " and"), username);
DataTable dt = SqlHelper.ExecuteQuery(sql);
if (dt != null)
{
BsOrder bsOrder = null;
foreach (DataRow row in dt.Rows)
{
bsOrder = new BsOrder();
bsOrder.ID = Int32.Parse(row["ID"].ToString());
bsOrder.UserID = new Guid(row["UserId"].ToString());
bsOrder.Date = DateTime.Parse(row["date"].ToString());
bsOrder.State = Int32.Parse(row["State"].ToString());
list.Add(bsOrder);
}
}
return(list);
}
public async Task <ActionResult <Response <DtoOrder> > > UpdateOrder([FromRoute] int idOrder, [FromBody] DtoOrderUpdate order)
{
try
{
if (idOrder == 0)
{
return(BadRequest(new Response <string>()
{
Error = "IdOrder can't be equal to 0", Succes = true
}));
}
if ((await BsOrder.GetById <DtoOrder>(idOrder)) == null)
{
return(NotFound(new Response <string>()
{
Error = "The Order doesn't exist", Succes = true
}));
}
if (order == null)
{
return(BadRequest(new Response <string>()
{
Error = "The Order can't be null", Succes = true
}));
}
return(Ok(new Response <DtoOrder>()
{
Error = "", Data = await BsOrder.Update <DtoOrder, DtoOrderUpdate>(idOrder, order), Succes = true
}));
}
catch (Exception e)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response <string[]>()
{
Error = e.Message, Data = e.StackTrace.Split("\r\n"), Succes = false
}));
}
}
public async Task <ActionResult <Response <DtoOrder> > > AddOrder([FromBody] DtoOrderAdd order)
{
try
{
if (order == null)
{
return(BadRequest(new Response <string>()
{
Error = "The Order can't be null", Succes = true
}));
}
return(Ok(new Response <DtoOrder>()
{
Error = "", Data = await BsOrder.Add <DtoOrder, DtoOrderAdd>(order), Succes = true
}));
}
catch (Exception e)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response <string[]>()
{
Error = e.Message, Data = e.StackTrace.Split("\r\n"), Succes = false
}));
}
}
public int EditBsOrder(BsOrder order)
{
return(orderDAL.EditBsOrder(order));
}
public int AddBsOrder(BsOrder order, ICollection <CartItem> items)
{
return(orderDAL.AddBsOrder(order, items));
}
public int EditBsOrder(BsOrder order)
{
string sql = String.Format("update BsOrder set State={0} where id={1}", order.State, order.ID);
return(SqlHelper.ExecuteNonQuery(sql));
}
