public IHttpActionResult PutOrder_details(int id, Order_details order_details)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != order_details.ID)
{
return(BadRequest());
}
db.Entry(order_details).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Order_detailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(string id)
{
Order_details order_details = db.Order_details.Find(id);
db.Order_details.Remove(order_details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult GetOrder_details(int id)
{
Order_details order_details = db.Order_details.Find(id);
if (order_details == null)
{
return(NotFound());
}
return(Ok(order_details));
}
public ActionResult Edit([Bind(Include = "Order_detail_no,Order_id,Service_details_Id,Appointment_date,Session_id,Designer_id,Coupon_id,Last_updata_date")] Order_details order_details)
{
if (ModelState.IsValid)
{
db.Entry(order_details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Order_id = new SelectList(db.Order, "Order_id", "Order_id", order_details.Order_id);
ViewBag.Service_details_Id = new SelectList(db.Service_details, "Service_details_Id", "Name", order_details.Service_details_Id);
return(View(order_details));
}
public IHttpActionResult PostOrder_details(Order_details order_details)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Order_details.Add(order_details);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = order_details.ID }, order_details));
}
// GET: Order_details/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order_details order_details = db.Order_details.Find(id);
if (order_details == null)
{
return(HttpNotFound());
}
return(View(order_details));
}
public async void AddOrderDetailsAsync(int orderId,
int product_id, int size_id, int amount)
{
using (HttpClient client = new HttpClient()) {
String request = "api/Orders/AddOrderDetails";
client.BaseAddress = this.UriApi;
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(this.Header);
Order_details orderDetails = new Order_details(orderId, product_id, size_id, amount);
String json = JsonConvert.SerializeObject(orderDetails);
StringContent content = new StringContent(json, Encoding.UTF8, "application/json");
await client.PostAsync(request, content);
}
}
public IHttpActionResult DeleteOrder_details(int id)
{
Order_details order_details = db.Order_details.Find(id);
if (order_details == null)
{
return(NotFound());
}
db.Order_details.Remove(order_details);
db.SaveChanges();
return(Ok(order_details));
}
public ActionResult Edit(Order_details order)
{
try
{
Order_details orderToEdit = db.Order_details.Find(order.Id);
UpdateModel(orderToEdit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: Order_details/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order_details order_details = db.Order_details.Find(id);
if (order_details == null)
{
return(HttpNotFound());
}
ViewBag.Order_id = new SelectList(db.Order, "Order_id", "Order_id", order_details.Order_id);
ViewBag.Service_details_Id = new SelectList(db.Service_details, "Service_details_Id", "Name", order_details.Service_details_Id);
return(View(order_details));
}
// GET: OrdersAdmin/Edit/5
public ActionResult Edit(int id)
{
Order_details details = db.Order_details.Find(id);
List <Payment> paymentTypes = db.Payment.ToList();
ViewBag.PaymentTypes = new SelectList(paymentTypes, "Id", "Name");
List <Delivery> deliveryTypes = db.Delivery.ToList();
ViewBag.DeliveryTypes = new SelectList(deliveryTypes, "Id", "Name");
List <Status> status = db.Status.ToList();
ViewBag.Status = new SelectList(status, "Id", "Name");
return(View(details));
}
public ActionResult Create(Orders order)
{
try
{
List <ShoppingCart> listCart = (List <ShoppingCart>)Session["Cart"];
db.Orders.Add(order);
db.SaveChanges();
foreach (ShoppingCart cart in listCart)
{
Order_item orderItem = new Order_item()
{
OrderID = order.Id,
ProductID = cart.Product.Id,
Quantity = cart.Quantity
};
db.Order_item.Add(orderItem);
db.SaveChanges();
}
Session.Remove("Cart");
Order_details orderDetails = new Order_details()
{
Order = order,
StatusID = 1
};
db.Order_details.Add(orderDetails);
db.SaveChanges();
// tutaj wyslac na strone ze zamowienie zostalo zlozone i ze liste zamowien mozna zobaczyc np. w profilu
// i oczywisice zrobic trzeba w profilu mozliwosc zobaczenia zamowien
return(RedirectToAction("Index", "Home", new { area = "" }));
}
catch
{
// Error - Trzeba zrobic strone dla View ze blad wystapil albo jakas ogolna ze blad wystapil
// bo jak teraz wywali errora gdzies to zwroci ze ta strona nie istnieje :P
return(View());
}
}
// GET: OrdersAdmin/Details/5
public ActionResult Details(int id)
{
Order_details details = db.Order_details.Find(id);
return(View(details));
}
public void _intoDB(string cartInfo, string Status, string OrderNo, int PayWay_id, int cus_id)
{
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CartDetail> >(cartInfo);
AppleLaLaRepository <Order> repo_order = new AppleLaLaRepository <Order>(context);
AppleLaLaRepository <Order_details> repo_Order_details = new AppleLaLaRepository <Order_details>(context);
AppleLaLaRepository <Work_schedule> repo_Work_schedule = new AppleLaLaRepository <Work_schedule>(context);
Order _order = new Order
{
Order_id = OrderNo,
Payway_id = PayWay_id,
Cust_id = cus_id,
Order_date = DateTime.Now,
Last_updata_date = DateTime.Now,
};
repo_order.Create(_order);
context.SaveChanges();
var SessionId = 0;
var time = 1;
foreach (var item in result)
{
switch (int.Parse(item.Session))
{
case 11:
SessionId = 1;
break;
case 12:
SessionId = 2;
break;
case 13:
SessionId = 3;
break;
case 14:
SessionId = 4;
break;
case 15:
SessionId = 5;
break;
case 16:
SessionId = 6;
break;
case 17:
SessionId = 7;
break;
case 18:
SessionId = 8;
break;
case 19:
SessionId = 9;
break;
case 20:
SessionId = 10;
break;
case 21:
SessionId = 11;
break;
default:
SessionId = 0;
break;
}
Order_details order_Details = new Order_details()
{
Order_detail_no = DateTimeOffset.Now.AddSeconds(time).ToUnixTimeSeconds().ToString(),
Order_id = OrderNo,
Service_details_Id = (from sd in context.Service_details
where sd.Name == item.Services
select sd.Service_details_Id).First(),
Appointment_date = item.Date,
Session_id = SessionId,
Designer_id = (from d in context.Designer
where d.Name == item.Designer
select d.Designer_id).First(),
Last_updata_date = DateTime.Now,
};
repo_Order_details.Create(order_Details);
var cnstr = ConfigurationManager.ConnectionStrings["AppleLaLaModel"].ConnectionString;
using (var conn = new SqlConnection(cnstr))
{
conn.Open();
string sql = "select ws.Schedule_id, ws.Designer_id,ws.Date,ws.Session_id,ws.On_work_flag from[Work_schedule] ws inner join[Designer] d on ws.Designer_id = d.Designer_id where d.Name = @Name and ws.Date = @Date and ws.Session_id = @Session_id ";
var target = conn.Query <dynamic>(sql, new { Name = item.Designer, Date = item.Date, Session_id = SessionId });
foreach (var i in target)
{
Work_schedule Work_schedule = new Work_schedule()
{
Schedule_id = i.Schedule_id,
Designer_id = i.Designer_id,
Date = i.Date,
Session_id = i.Session_id,
On_work_flag = "N"
};
repo_Work_schedule.Update(Work_schedule);
}
}
context.SaveChanges();
time++;
}
}
public JsonResult PlaceOrderAjax(string captcha)
{
Object data = null;
var message = "";
try
{
string response = captcha;
string secretKey = "6Ldx_iQUAAAAANOg9tYwABMd6C2os33YQ5pPt2EY";
var client = new WebClient();
var result = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secretKey, response));
var obj = JObject.Parse(result);
var status = (bool)obj.SelectToken("success");
if (status)
{
User u = (User)Session["User"];
Order o = db.Orders.Where(e => e.U_id == u.U_id && e.Last == 1).FirstOrDefault();
if (o != null)
{
o.Last = 0;
db.SaveChanges();
}
var cart = db.Carts.Where(e => e.U_id == u.U_id).ToList();
Address add = db.Addresses.Where(e => e.U_id == u.U_id).FirstOrDefault();
double grandTotal = 0;
foreach (var x in cart)
{
Product p = db.Products.Find(x.P_id);
double subtotal = (int)x.Quantity * (int)p.Price;
grandTotal = subtotal + grandTotal;
}
Order order = new Order();
order.O_id = 2;
order.U_id = u.U_id;
order.A_id = add.A_id;
order.Date = DateTime.Now.ToString();
order.S_id = 1;
order.Last = 1;
order.Grand_total = grandTotal;
db.Orders.Add(order);
db.SaveChanges();
var orderId = db.Orders.Where(e => e.U_id == u.U_id && e.Last == 1).FirstOrDefault();
foreach (var x in cart)
{
Product p = db.Products.Find(x.P_id);
Order_details orderDetail = new Order_details();
orderDetail.Od_id = 1;
orderDetail.O_id = orderId.O_id;
orderDetail.P_id = x.P_id;
orderDetail.Quantity = x.Quantity;
int price = (int)x.Quantity * (int)p.Price;
orderDetail.Price = price;
db.Order_details.Add(orderDetail);
}
db.SaveChanges();
var remove = db.Carts.Where(e => e.U_id == u.U_id);
foreach (var x in remove)
{
db.Carts.Remove(x);
}
db.SaveChanges();
message = "Your Order is Placed!";
}
else
{
message = "Google reCaptcha Validation Failed!";
}
data = new
{
output = message
};
}
catch (Exception e)
{
message = "Some Thing Went Wrong!";
data = new
{
output = message
};
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增一筆訂單資料.
/// </summary>
/// <param name="orders"></param>
/// <returns></returns>
public int AddOrder(Orders orders)
{
string SqlOrder = @"INSERT INTO [Orders]
([CustomerID]
,[EmployeeID]
,[OrderDate]
,[RequiredDate]
,[ShippedDate]
,[Freight]
,[ShipName])
VALUES
(@CustomerID
,@EmployeeID
,@OrderDate
,@RequiredDate
,@ShippedDate
,@Freight
,@ShipName);select @@IDENTITY";
string SqlOrderDetails = @"INSERT INTO [dbo].[Order Details]
([OrderID]
,[ProductID]
,[UnitPrice]
,[Quantity]
,[Discount])
VALUES
(@OrderID
,@ProductID
,@UnitPrice
,@Quantitys
,@Discount)";
SqlConnection connection = new SqlConnection(new DBConn().ConnectionString);
SqlTransaction tran = null;
try
{
DataAccess dal = new DataAccess();
int result = 0;
connection.Open();
tran = connection.BeginTransaction();
SqlCommand cmd = new SqlCommand(SqlOrder, connection, tran);
SqlParameter[] ParamOrder = new SqlParameter[] {
new SqlParameter("@CustomerID", orders.CustomerID),
new SqlParameter("@EmployeeID", orders.EmployeeID),
new SqlParameter("@OrderDate", orders.OrderDate),
new SqlParameter("@RequiredDate", orders.RequiredDate),
new SqlParameter("@ShippedDate", orders.ShippedDate),
new SqlParameter("@Freight", orders.Freight),
new SqlParameter("@ShipName", orders.ShipName)
};
object identity = dal.ExecuteScalar(cmd, SqlOrder, CommandType.Text, ref connection, ref tran, ParamOrder);
Order_details order_detail = orders.ORDER_DETAILS.FirstOrDefault();
if (order_detail != null)
{
SqlParameter[] ParamOrderDetails = new SqlParameter[] {
new SqlParameter("@OrderID", identity),
new SqlParameter("@ProductID", order_detail.ProductID),
new SqlParameter("@UnitPrice", order_detail.UnitPrice),
new SqlParameter("@Quantitys", order_detail.Quantity),
new SqlParameter("@Discount", order_detail.Discount)
};
result += dal.ExecuteSQL(cmd, SqlOrderDetails, CommandType.Text, ref connection, ref tran, ParamOrderDetails);
}
tran.Commit();
return(result);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
connection.Dispose();
}
}
