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)); }