public ActionResult CreateDriverOrder(CreateDriverOrder createDriverOrder)
{
string idUser;
if (TempData["ID"] != null)
{
idUser = TempData["ID"].ToString();
TempData["ID"] = null;
}
else
{
idUser = null;
}
OrderDriver orderDriver = new OrderDriver
{
CarBrand = createDriverOrder.CarBrand,
MaxWeight = createDriverOrder.MaxWeight,
StartAddressCity = createDriverOrder.StartAddressCity,
StartAddressRoad = createDriverOrder.StartAddressRoad,
StartAddressHouse = createDriverOrder.StartAddressHouse,
ApplicationUserId = User.Identity.GetUserId().ToString(),
Status = true
};
UserService.CreateDriverOrder(orderDriver, idUser);
string messege = "user Id:" + User.Identity.GetUserId() + "User Name: " + User.Identity.Name +
"controller: AccountController, Action CreateUserOrder Succses";
logger.Info(messege);
return(RedirectToAction("index", "Home"));
}
private void User1MakeOrder()
{
_orderBridge = OrderDriver.getBridge();
_orderBridge.GetOrderService(_userBridge.GetUserSession());
_orderBridge.BuyItemFromImmediate("hello", "blahblah", 2, 10, null);
_orderBridge.BuyItemFromImmediate("Goodbye", "blahblah2", 2, 10, null);
}
private void CreateOrderWithCouponInvalidCoupon(string coupon)
{
_orderBridge = OrderDriver.getBridge();
_orderBridge.GetOrderService(_userBuyer.GetUserSession());
MarketAnswer res = _orderBridge.BuyItemFromImmediate("Ouch", "Toy", 2, 30, coupon);
Assert.AreEqual((int)OrderStatus.InvalidCoupon, res.Status);
}
public void LotteryFailGuest()
{
_buyerGuestBridge = UserDriver.getBridge();
_buyerGuestBridge.EnterSystem();
_orderBridge1 = OrderDriver.getBridge();
_orderBridge1.GetOrderService(_buyerGuestBridge.GetUserSession());
Assert.AreEqual((int)OrderStatus.InvalidUser, _orderBridge1.BuyLotteryTicket("Fanta", storeName, 1, 4).Status);
}
private void MakeRegisteredShopper3()
{
_buyerRegisteredUserBridge3 = UserDriver.getBridge();
_buyerRegisteredUserBridge3.EnterSystem();
_buyerRegisteredUserBridge3.SignUp("Shalom3", "Bye3", "555", "55555555");
_orderBridge3 = OrderDriver.getBridge();
_orderBridge3.GetOrderService(_buyerRegisteredUserBridge3.GetUserSession());
}
private void CreateOrder()
{
_storeManager1.AddNewProduct("Yolo", 5, "Once", 10);
_storeBridge.AddProductToCart("Volcano", "Yolo", 2);
_orderBridge = OrderDriver.getBridge();
_orderBridge.GetOrderService(_bridgeSignUp.GetUserSession());
_orderBridge.BuyEverythingFromCart(new string[] { null });
}
public ActionResult CancelOrder(Guid orderId, Guid driverId)
{
Client.GetOrder(driverId, orderId);
Order order = Parser.GetOrder(Client.FindOrder(orderId));
Driver driver = Parser.GetDriver(Client.FindDriver(driverId));
OrderDriver orderDriver = new OrderDriver(order, driver);
Client.CancellationOfOrder(orderDriver.Driver.ID, orderDriver.Order.ID);
return(View(orderDriver));
}
public OrderDriver FinishTrip(Guid orderId, Guid driverId)
{
Client.FinishTrip(driverId, orderId);
Order order = Parser.GetOrder(Client.FindOrder(orderId));
Driver driver = Parser.GetDriver(Client.FindDriver(driverId));
OrderDriver orderDriver = new OrderDriver(order, driver);
//return View(orderDriver);
return(orderDriver);
}
public void UpdateOrderDriver(OrderDriver item)
{
var r = Database.orderDrivers.Find(item.Id);
r.StartAddressCity = item.StartAddressCity;
r.StartAddressRoad = item.StartAddressRoad;
r.StartAddressHouse = item.StartAddressHouse;
r.MaxWeight = item.MaxWeight;
r.CarBrand = item.CarBrand;
//Database.Entry(item).State = EntityState.Modified;
Database.SaveChanges();
}
public ActionResult UpdateDriverOrder(string id)
{
OrderDriver orderDriver = UserService.FindOrderDriver(id);
CreateDriverOrder createDriverOrder = new CreateDriverOrder();
createDriverOrder.StartAddressCity = orderDriver.StartAddressCity;
createDriverOrder.StartAddressRoad = orderDriver.StartAddressRoad;
createDriverOrder.StartAddressHouse = orderDriver.StartAddressHouse;
createDriverOrder.CarBrand = orderDriver.CarBrand;
createDriverOrder.MaxWeight = orderDriver.MaxWeight;
createDriverOrder.Id = orderDriver.Id;
return(View(createDriverOrder));
}
public void DeleteDriverOrderById(string idDriverOrder)
{
//if (Database.orderDrivers.Find(idDriverOrder) != null &&
// Database.orderUsers.Find(idDriverOrder).ApplicationUserId == idUserIdentyti)
//{
OrderDriver r = Database.orderDrivers.Find(idDriverOrder);
Database.orderDrivers.Remove(r);
Database.SaveChanges();
//result = "Заявка удалена";
//_logger.Error("[Error in ClientController.Edit - id: " + idDriverOrder + "24234" + idDriverOrder + " - Error: " "]");
//result = "ЧТо то пошло не так удалена";
}
public ActionResult UpdateDriverOrder(CreateDriverOrder createDriverOrder)
{
OrderDriver orderDriver = new OrderDriver
{
CarBrand = createDriverOrder.CarBrand,
MaxWeight = createDriverOrder.MaxWeight,
StartAddressCity = createDriverOrder.StartAddressCity,
StartAddressRoad = createDriverOrder.StartAddressRoad,
StartAddressHouse = createDriverOrder.StartAddressHouse,
ApplicationUserId = User.Identity.GetUserId().ToString(),
Status = true,
Id = createDriverOrder.Id
};
UserService.UpdateOrderDriver(orderDriver);
return(RedirectToAction("index", "Home"));
}
public void MarketBuilder()
{
MarketDB.Instance.InsertByForce();
SignUp("Pnina", "mishol", "666", "66666666");
OpenStoreAndAddProducts();
_orderBridge = OrderDriver.getBridge();
_userAdminBridge = UserDriver.getBridge();
_userAdminBridge.EnterSystem();
MarketAnswer res = _userAdminBridge.SignIn("Arik1", "123");
_adminBridge = AdminDriver.getBridge();
_adminBridge.GetAdminService(_userAdminBridge.GetUserSession());
_buyerRegisteredUserBridge = null;
_buyerGuestBridge = null;
PaymentService.Instance.FixExternal();
SupplyService.Instance.FixExternal();
}
/*public ActionResult GetOrder(Guid driverId, Guid orderId) //взять заказ
* {
* OrderDriver orderDriver = new OrderDriver(Parser.GetOrder(Client.FindOrder(orderId)), Parser.GetDriver(Client.FindDriver(driverId)));
* Client.GetOrder(orderDriver.Driver.ID, orderDriver.Order.ID);
* //Order orderToDo = Parser.GetOrder(Client.FindOrder(orderId));
* return RedirectToAction("ShowOrder", new { order = orderDriver.Order });
* }*/
/*public ActionResult ShowOrder(Guid idOrder, Guid idDriver)
* {
* Order order = Parser.GetOrder(Client.FindOrder(idOrder));
* Driver driver = Parser.GetDriver(Client.FindDriver(idDriver));
* OrderDriver orderDriver = new OrderDriver(order, driver);
* return View(orderDriver);
* }*/
// [HttpPost]
public ActionResult ShowOrder(Guid orderId, Guid driverId, string act) //подробности о заказе
{
Client = new ServiceReference1.WebServiceTaxiSoapClient();
if (act == "ShowOrder")
{
Client.GetOrder(driverId, orderId);
Order order = Parser.GetOrder(Client.FindOrder(orderId));
Driver driver = Parser.GetDriver(Client.FindDriver(driverId));
OrderDriver orderDriver = new OrderDriver(order, driver);
//Client.GetOrder(orderDriver.Driver.ID, orderDriver.Order.ID);
//Order order = Client.ShowOrder(orderDriver.Order.ID_Driver);
//return View(orderDriver);
return(View(orderDriver));
}
if (act == "StartTrip")
{
Client.StartTrip(driverId, orderId);
Order order = Parser.GetOrder(Client.FindOrder(orderId));
Driver driver = Parser.GetDriver(Client.FindDriver(driverId));
OrderDriver orderDriver = new OrderDriver(order, driver);
return(View(orderDriver));
}
if (act == "FinishTrip")
{
Client.FinishTrip(driverId, orderId);
Order order = Parser.GetOrder(Client.FindOrder(orderId));
Driver driver = Parser.GetDriver(Client.FindDriver(driverId));
OrderDriver orderDriver = new OrderDriver(order, driver);
return(View(orderDriver));
}
if (act == "Update")
{
Order order = Parser.GetOrder(Client.FindOrder(orderId));
Driver driver = Parser.GetDriver(Client.FindDriver(driverId));
OrderDriver orderDriver = new OrderDriver(order, driver);
if (orderDriver.Order.Status == "3")
{
//order1 = null;
return(View(orderDriver));
}
}
return(View());
}
protected void btn_Accepted_Click(object sender, EventArgs e)
{
// Get button from the gridview, sender is the object of the butotn
Button btn = (Button)sender;
// Gets the row of the button in the gridview
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
// Gets the order id from the gridview
string order_id = gvr.Cells[0].Text;
// Create object and use the method
OrderDriver orders = new OrderDriver();
int result = orders.orderUpdateStatus(order_id, "Completed");
//Reload the table
bind(); // NOTE THAT WHEN YOU UPDATE TO ACCEPTED, IT WILL NOT SHOW ON DRIVER.ASPX BECAUSE BIND() VARIABLE IS "NEW" (Line 21)
//NEW PLAN
//click pickup update status to collected
//BELOW IS OLD PLAN
/*
* Session["orderID"] = 1; //change 1 to order id of the row you click
* Session["hello"] = "pickup";
*
*
* //in other aspx.cs page_load
* if(Session["hello"].Equals("pickup"))
* {
* //display all the pickup info
* }
* else if (Session["hello"].Equals("delivery"))
* { //display all the pickup info
*
* }
*/
}
//Below as the Class methods for some DB operations.
//We will revisit these section in our next practical
public OrderDriver getOrder(string order)
{
OrderDriver orderDetail = null;
string order_id, pickupdvr, deliverydvr, order_status, payment_info, cust_id, total_price, todate, totime, frodate, frotime, pickupaddrid, deliveryaddrid, email;
string queryStr = "select A.cust_id, A.order_id, A.total_price, A.pickupdvr, A.deliverydvr, A.todate, A.totime, A.frodate, A.frotime, A.order_status, A.payment_info, A.pickupaddrid, A.deliveryaddrid, (select email from cust_info B where B.cust_id = A.cust_id) as email from laundry_order A where A.order_status =@pStatus";
SqlConnection conn = new SqlConnection(_connstr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
cmd.Parameters.AddWithValue("@order_id", orderDetail);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
//sheck if there are any resultsets
if (dr.Read())
{
order_id = dr["order_id"].ToString();
pickupdvr = dr["pickupdvr"].ToString();
deliverydvr = dr["deliverydvr"].ToString();
order_status = dr["order_status"].ToString();
payment_info = dr["payment_info"].ToString();
cust_id = dr["cust_id"].ToString();
total_price = dr["total_price"].ToString();
todate = Convert.ToDateTime(dr["todate"].ToString()).ToShortDateString();
totime = dr["totime"].ToString();
frodate = Convert.ToDateTime(dr["frodate"].ToString()).ToShortDateString();
frotime = dr["frotime"].ToString();
pickupaddrid = dr["pickupaddrid"].ToString();
deliveryaddrid = dr["deliveryaddrid"].ToString();
email = dr["email"].ToString();
orderDetail = new OrderDriver(order_id, pickupdvr, deliverydvr, order_status, payment_info, cust_id, total_price, todate, totime, frodate, frotime, pickupaddrid, deliveryaddrid, email);
}
else
{
orderDetail = null;
}
conn.Close();
dr.Close();
dr.Dispose();
return(orderDetail);
}
public List <OrderDriver> getOrderbyStatus(string pStatus)
{
List <OrderDriver> orderList = new List <OrderDriver>();
string order_id, pickupdvr, deliverydvr, order_status, payment_info, cust_id, total_price, todate, totime, frodate, frotime, pickupaddrid, deliveryaddrid, email;
string queryStr = "select A.cust_id, A.order_id, A.total_price, A.pickupdvr, A.deliverydvr, A.todate, A.totime, A.frodate, A.frotime, A.order_status, A.payment_info, A.pickupaddrid, A.deliveryaddrid, (select email from cust_info B where B.cust_id = A.cust_id) as email from laundry_order A where A.order_status =@pStatus";
SqlConnection conn = new SqlConnection(_connstr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
cmd.Parameters.AddWithValue("@pStatus", pStatus);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
order_id = dr["order_id"].ToString();
pickupdvr = dr["pickupdvr"].ToString();
deliverydvr = dr["deliverydvr"].ToString();
order_status = dr["order_status"].ToString();
payment_info = dr["payment_info"].ToString();
cust_id = dr["cust_id"].ToString();
total_price = dr["total_price"].ToString();
todate = Convert.ToDateTime(dr["todate"].ToString()).ToShortDateString();
totime = dr["totime"].ToString();
frodate = Convert.ToDateTime(dr["frodate"].ToString()).ToShortDateString();
frotime = dr["frotime"].ToString();
pickupaddrid = dr["pickupaddrid"].ToString();
deliveryaddrid = dr["deliveryaddrid"].ToString();
email = dr["email"].ToString();
OrderDriver a = new OrderDriver(order_id, pickupdvr, deliverydvr, order_status, payment_info, cust_id, total_price, todate, totime, frodate, frotime, pickupaddrid, deliveryaddrid, email);
orderList.Add(a);
}
conn.Close();
dr.Close();
dr.Dispose();
return(orderList);
}
public void CreateOrderDriver(OrderDriver item, string st)
{
item.Id = Database.orderDrivers.Count() + 2.ToString();
if (st != null)
{
var itemOther = Database.orderUsers.Find(st);
if (item.MaxWeight >= itemOther.Weight)
{
Database.order.Add(new Order {
OrderDriverId = item.Id, OrderUserId = itemOther.Id, Status = "Ready"
});
item.Status = false;
Database.orderUsers.Find(st).Status = false;
}
}
Database.orderDrivers.Add(item);
try
{
Database.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, "; The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
private void CreateOrder()
{
_orderBridge = OrderDriver.getBridge();
_orderBridge.GetOrderService(_userBuyer.GetUserSession());
_orderBridge.BuyEverythingFromCart(new string[] { null });
}
public void UpdateOrderDriver(OrderDriver orderDriver)
{
Database.OrderManager.UpdateOrderDriver(orderDriver);
}
public void CreateDriverOrder(OrderDriver orderDriver, string st)
{
orderDriver.ApplicationUser = Database.UserManager.FindById(orderDriver.ApplicationUserId);
Database.OrderManager.CreateOrderDriver(orderDriver, st);
}
public OrderDriver FindOrderDriver(string id)
{
OrderDriver orderDriver = Database.orderDrivers.Find(id);
return(orderDriver);
}
protected void btn_Accepted_Click(object sender, EventArgs e)
{
// Get button from the gridview, sender is the object of the butotn
Button btn = (Button)sender;
// Gets the row of the button in the gridview
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
// Gets the order id from the gridview
string order_id = gvr.Cells[0].Text;
// Create object and use the method
OrderDriver orders = new OrderDriver();
int result = orders.orderUpdateStatus(order_id, "Completed");
string email;
/*
* Open database and using customer pk to find it
* string customer_ID = gvr.Cells[3].Text;
* customer.getcustomer(customer_Id); //get single customer data out from database
* email = customer.email.tostring(); // make string email to the customer email
* */
Email_orderDriver Eo = new Email_orderDriver();
string customer_ID = gvr.Cells[3].Text;
Email_orderDriver customer = Eo.getOrder(customer_ID);
email = customer.email.ToString();
//Response.Write(String.Format("<script>alert('{0}');</script>", email));
if (result > 0)
{ // If validated properly
Response.Write("<script>alert('Product updated');</script>");
//ADD EMAIL HERE
string psender = "*****@*****.**";
string subject = "Order Completed";
string body = "Order have been Completed. Enjoy";
try
{
MailMessage message = new MailMessage(psender, email, subject, body);
message.IsBodyHtml = true;
SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
client.EnableSsl = true;
client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Ebusiness");
client.Send(message);
}
catch (Exception ex)
{
}
}
else
{ // If something went wrong
Response.Write("<script>alert('Product NOT updated');</script>");
}
//Reload the table
bind(); // NOTE THAT WHEN YOU UPDATE TO ACCEPTED, IT WILL NOT SHOW ON DRIVER.ASPX BECAUSE BIND() VARIABLE IS "NEW" (Line 21)
//NEW PLAN
//click pickup update status to collected
//BELOW IS OLD PLAN
/*
* Session["orderID"] = 1; //change 1 to order id of the row you click
* Session["hello"] = "pickup";
*
*
* //in other aspx.cs page_load
* if(Session["hello"].Equals("pickup"))
* {
* //display all the pickup info
* }
* else if (Session["hello"].Equals("delivery"))
* { //display all the pickup info
*
* }
*/
}
protected void btn_Rejected_Click(object sender, EventArgs e)
{
// Get button from the gridview, sender is the object of the butotn
Button btn = (Button)sender;
// Gets the row of the button in the gridview
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
// Gets the order id from the gridview
string order_id = gvr.Cells[0].Text;
// Create object and use the method
OrderDriver orders = new OrderDriver();
int result = orders.orderUpdateStatus(order_id, "REJECTED");
string email;
/*
* Open database and using customer pk to find it
* string customer_ID = gvr.Cells[3].Text;
* customer.getcustomer(customer_Id); //get single customer data out from database
* email = customer.email.tostring(); // make string email to the customer email
* */
Email_orderDriver Eo = new Email_orderDriver();
string customer_ID = gvr.Cells[3].Text;
Email_orderDriver customer = Eo.getOrder(customer_ID);
email = customer.email.ToString();
//Response.Write(String.Format("<script>alert('{0}');</script>", email));
if (result > 0)
{ // If validated properly
Response.Write("<script>alert('Product updated');</script>");
//ADD EMAIL HERE
string psender = "*****@*****.**";
string subject = "Found Driver";
string body = "Order have been cancel. Please try again later";
try
{
MailMessage message = new MailMessage(psender, email, subject, body);
message.IsBodyHtml = true;
SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
client.EnableSsl = true;
client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Ebusiness");
client.Send(message);
}
catch (Exception ex)
{
}
}
else
{ // If something went wrong
Response.Write("<script>alert('Product NOT updated');</script>");
}
//Reload the table
bind(); // NOTE THAT WHEN YOU UPDATE TO ACCEPTED, IT WILL NOT SHOW ON DRIVER.ASPX BECAUSE BIND() VARIABLE IS "NEW" (Line 21)
}
