public OrdersByDate()
{
string source = "server=(local);" + "integrated security=SSPI;" + "database=db_tolkdanmark"; /// Connection string
string selectOrderPri = "SELECT [order_id],[language],[NumberOfTolks],[order_date],[fromMinutes],[fromHours],[toMinutes],[toHours],[postalCode],[tolkning_info]," +
"[postalCode_tolkning], address, address_tolkning FROM [db_tolkdanmark].[dbo].[OrdersLang] where order_date ='02-05-2016'" + //+DateOfOrders+"'"+
" order by NumberOfTolks,fromHours,fromMinutes"; //,[day],[month],[year] // this string is used to get orders with language priority and specific date
SqlConnection conn = new SqlConnection(source);
conn.Open();
//----------------------------here we get orders with priority of languages and make their objects
try
{
SqlCommand cmdOrderPri = new SqlCommand(selectOrderPri, conn);
SqlDataReader readerOrderPri = cmdOrderPri.ExecuteReader();
while (readerOrderPri.Read())
{
AllOrders currentOrder = new AllOrders(Convert.ToString(readerOrderPri[0]), Convert.ToString(readerOrderPri[1]), Convert.ToString(readerOrderPri[2]),
Convert.ToString(readerOrderPri[3]), Convert.ToString(readerOrderPri[4]), Convert.ToString(readerOrderPri[5]),
Convert.ToString(readerOrderPri[6]), Convert.ToString(readerOrderPri[7]), Convert.ToString(readerOrderPri[8]),
Convert.ToString(readerOrderPri[9]), Convert.ToString(readerOrderPri[10]),
Convert.ToString(readerOrderPri[11]), Convert.ToString(readerOrderPri[12]));
AllOrderListInOrdersByDate.Add(currentOrder); // List is populated with objects of AllOrders class
}
readerOrderPri.Dispose();
}
catch (SqlException ex)
{
Console.WriteLine(" there is error while opening the conncetion, error is : " + ex);
}
conn.Close();
}
public ActionResult AllOrders()
{
var OR = (from o in context.Orders
select o).ToList();
AllOrders test;
List <AllOrders> AllO = new List <AllOrders>();
// Product Prod = context.Products.FirstOrDefault(d => d.ID == .ProductID);
foreach (var item in OR)
{
test = new AllOrders();
test.ID = (from o in context.Products
where o.ID == item.ProductID
select o.ID).FirstOrDefault();
test.Name = (from o in context.Products
where o.ID == item.ProductID
select o.Name).FirstOrDefault();
test.Image = (from o in context.Products
where o.ID == item.ProductID
select o.Image).FirstOrDefault();
test.Price = (decimal)(from o in context.Products
where o.ID == item.ProductID
select o.Price).FirstOrDefault();
test.Quantity = (int)(from o in context.Orders
where o.ID == item.ID
select o.Quantity).FirstOrDefault();
AllO.Add(test);
}
return(View(AllO));
}
private void mtBack_Click(object sender, EventArgs e)
{
//bool IsOpen = false;
//FormCollection fc = Application.OpenForms;
//foreach (Form f in fc)
//{
// if (f.Name == "Main")
// {
// IsOpen = true;
// f.Focus();
// break;
// }
//}
//if (IsOpen == true)
//{
//}
//this.Hide();
//Home f1obj = new Home();
AllOrders obj = new AllOrders();
obj.WindowState = FormWindowState.Maximized;
obj.Show();
this.Hide();
//this.Close();
}
public bool CanBeOrdered(ThingDef foodDef)
{
// Do we have any item of that type that isn't part of any order?
var orderedAmount = AllOrders.Where(o => o.consumableDef == foodDef).Sum(o => 1);
var stockedAmount = Stock.GetAllStockOfDef(foodDef).Sum(item => item.stackCount);
return(stockedAmount > orderedAmount);
}
public bool CheckCurrentOrder()
{
var temp = CurrentOrder.IsEmpty();
if (temp)
{
AllOrders.Remove(CurrentOrder);
CurrentOrder = new Order(CurrentUser);
AllOrders.Add(CurrentOrder);
}
return(temp);
}
public void PlaceOrder()
{
AllOrders All = AllOrders.Instance;
PersonOrders.OrderID = All.AllFoodOrders.Count + 1;
All.AllFoodOrders.Add(PersonOrders);
foreach (Order O in Orders.ToList())
{
Orders.Remove(O);
}
PersonOrders = new AllOrderPerPerson();
MessageBox.Show("Order Placed");
}
public OrdersIndex Add(IReadOnlyList <IUserOrder> newOrders, IReadOnlyList <IAssigningUserOrder> assigningOrders)
{
if (IsEmpty)
{
throw new InvalidOperationException("Index in empty");
}
var allOrders = AllOrders.AddRange(newOrders);
var newUnassignedOrdersDic = UnassignedOrders.RemoveRange(assigningOrders.SelectMany(o => o.Orders)).AddRange(newOrders);
var allAssigningOrders = AssigningOrders.AddRange(assigningOrders);
return(new OrdersIndex(allOrders, newUnassignedOrdersDic, allAssigningOrders));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER"] == null)
{
Response.Redirect("Login.aspx");
}
count_Notification = nBusiness.countUnreadNotification();
list_Notification = nBusiness.GetUnreadNotificationService();
popup_Notifications.DataSource = list_Notification;
popup_Notifications.DataBind();
list_OrderProduct = orderBusiness.GetAllOrders();
AllOrders.DataSource = list_OrderProduct;
AllOrders.DataBind();
}
public void GetCodeJewelry(string vc)
{
Orders.Clear();
if (vc == "")
{
GetAllOrders();
}
else
{
Order[] orders = AllOrders.Where(i => i.Jewelry.VenderCode == vc).ToArray <Order>();
foreach (Order o in orders)
{
Orders.Add(o);
}
}
}
public void GetTypeJewelry(string type)
{
Orders.Clear();
if (type == "")
{
GetAllOrders();
}
else
{
Order[] orders = AllOrders.Where(i => i.Jewelry.Type.NameOfJewerly == type).ToArray <Order>();
foreach (Order o in orders)
{
Orders.Add(o);
}
}
}
public void GetOrders()
{
Orders.Clear();
AllOrders.Clear();
foreach (Client c in Clients)
{
if (!(c.Orders is null))
{
foreach (Order o in c.Orders)
{
AllOrders.Add(o);
Orders.Add(o);
}
}
}
}
public void GetNameMasters(string name)
{
Orders.Clear();
if (name == "")
{
GetAllOrders();
}
else
{
Order[] orders = AllOrders.Where(i => i.Master.Surname == name).ToArray <Order>();
foreach (Order o in orders)
{
Orders.Add(o);
}
}
}
public static bool UserHasOrder(User u)
{
List <Order> AllOrders = new List <Order>();
string ConnectionString = @"Data Source=(local);Initial Catalog=Zadatak_1;Integrated Security=True;";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlCommand query = new SqlCommand("select * from tblOrder", conn);
conn.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
if (AllOrders == null)
{
AllOrders = new List <Order>();
}
foreach (DataRow row in dataTable.Rows)
{
Order o = new Order
{
Id = int.Parse(row[0].ToString()),
User = new User(int.Parse(row[1].ToString())),
OrderTimeStamp = (DateTime)row[2],
Price = int.Parse(row[3].ToString()),
Approved = (bool)row[4]
};
AllOrders.Add(o);
}
}
foreach (Order o in AllOrders)
{
if (u.Id == o.User.Id && o.Approved == false)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show($"You already have order (Order Id: {o.Id}, Price: {o.Price}) with pending approval, please try again latter.", "Notification");
return(true);
}
}
return(false);
}
public bool ChangeUser(User user)
{
if (user == null)
{
throw new ArgumentNullException("User is NULL.", nameof(user));
}
var tempOrd = AllOrders.FirstOrDefault(o => o.CurrentUser.Name == user.Name);
if (tempOrd == null)
{
CurrentOrder = new Order(user);
CurrentUser = user;
CurrentBasket = new Dictionary <Goods, int>();
AllOrders.Add(CurrentOrder);
AllBaskets.Add(CurrentUser, CurrentBasket);
}
else
{
foreach (var item in AllOrders)
{
if (item.CurrentUser.Name == user.Name)
{
CurrentOrder = item;
CurrentUser = item.CurrentUser;
}
}
foreach (var item in AllBaskets)
{
if (item.Key.Name == user.Name)
{
CurrentBasket = item.Value;
}
}
}
return(true);
}
public void GetNewDay()
{
Today = Today.AddDays(1);
for (int i = 0; i < Clients.Count; ++i)
{
for (int j = 0; j < Clients[i].Orders.Count; ++j)
{
if (Clients[i].Orders[j].End.Date == Today.Date)
{
AllOrders.Remove(Clients[i].Orders[j]);
Clients[i].Orders[j].Status = "Готово. Заберите заказ.";
}
}
}
for (int i = 0; i < Masters.Count; ++i)
{
if (Masters[i].Busy > 0)
{
Masters[i].Busy--;
AllMasters[i].Busy--;
}
}
}
public void CheckOrders(object obj, EventArgs args)
{
var temp = new List <Order>(AllOrders.ToArray());
foreach (var item in temp)
{
if (item.IsEmpty())
{
if (item == CurrentOrder)
{
CurrentOrder = new Order(CurrentUser);
AllOrders.Remove(item);
AllOrders.Add(CurrentOrder);
}
else
{
AllOrders.Remove(item);
var order = new Order(item.CurrentUser);
AllOrders.Add(order);
}
}
}
}
private void updateComplete()
{
Orders ordersss = db.Orders.Find(comleteID);
ordersss.Status = comboBox1.Text;
ordersss.FinishDate = dateTimePicker1.Value;
if (ordersss.Status == "Completed")
{
dateTimePicker1.Value = DateTime.Now;
AllOrders allOrders = new AllOrders();
allOrders.ConsumerID = ordersss.ConsumerID;
allOrders.CarmadeID = Convert.ToInt32(ordersss.CarMadeID);
allOrders.Carmake = ordersss.CarMake;
allOrders.Status = "Completed";
allOrders.PickedDate = ordersss.PickedDate;
allOrders.FinishDate = ordersss.FinishDate;
allOrders.Price = ordersss.Price;
db.AllOrders.Add(allOrders);
}
db.SaveChanges();
}
private void qqq()
{
if (!string.IsNullOrWhiteSpace(cbConsumerName.Text) &&
!string.IsNullOrWhiteSpace(cbCarMade.Text) &&
!string.IsNullOrWhiteSpace(cbCarMake.Text) &&
cbConsumerName.Text != "Choose..." &&
cbCarMake.Text != "Choose..." &&
cbCarMade.Text != "Choose..."
)
{
AllOrders allOrders = new AllOrders();
Orders orders = new Orders();
int getCarConsumerID = db.Consumers.FirstOrDefault(m => m.FullName == cbConsumerName.Text).Id;
int getCarMadeID = db.Mades.FirstOrDefault(m => m.Made == cbCarMade.Text).Id;
int getCarPrice = db.Cars.FirstOrDefault(m => m.Make == cbCarMake.Text).Id;
Cars inttt = db.Cars.Find(getCarPrice);
orders.ConsumerID = Convert.ToInt32(getCarConsumerID);
orders.CarMadeID = Convert.ToInt32(getCarMadeID);
orders.CarId = Convert.ToInt32(getCarPrice);
orders.CarMake = cbCarMake.Text;
orders.PickedDate = dtFrom.Value;
orders.FinishDate = dtTill.Value;
orders.Price = inttt.Price;
db.Orders.Add(orders);
db.SaveChanges();
MessageBox.Show("Order Succesfully Created!");
}
else
{
MessageBox.Show("Please Fill All Fields! By the way 'Choose' is not an option");
}
}
public void AddAnOrderToTheQueue(Order order)
{
AllOrders.Enqueue(order);
}
private void btnAllOrders_Click(object sender, EventArgs e)
{
AllOrders allOrders = new AllOrders(user);
Contain(allOrders);
}
private void الطلباتToolStripMenuItem_Click(object sender, EventArgs e)
{
AllOrders all = new AllOrders();
all.Show();
}
public ServiceViewModel(User user, ResourceDictionary resource)
{
res = resource;
unitOfWork = new UnitOfWork();
userContext = new UserContext();
userContext2 = new UserContext();
service = new DataModels.Service();
this.user = user;
//Person info page
Email = user.Email;
FirstName = user.FirstName;
LastName = user.LastName;
Phone = user.Phone;
// List of users & list of logins(ComboBox) in PersonList page
foreach (User userlist in userContext.Users)
{
PersonsList.Add(userlist);
UserComboList.Add(userlist.Login);
}
// list of orders id in combo
foreach (UsersServices services in userContext.UsersServices)
{
if (user.Id == services.UserId)
{
UserOrderIdCombo.Add(services.UserServicesId);
}
}
// status ComboBox PersonList page
UserStatusCombo.Add("user");
UserStatusCombo.Add("admin");
// order status. All Orders page
OrderStatusCombo.Add("Not ready");
OrderStatusCombo.Add("Ready");
OrderStatusCombo.Add("Denied");
// Order list of each user
using (UserContext db = new UserContext())
{
foreach (UsersServices ser in db.UsersServices)
{
foreach (DataModels.Service serv in userContext.Services)
{
if (user.Id == ser.UserId && ser.ServiceId == serv.Id)
{
InfoUserServices infoUserServices = new InfoUserServices {
Id = ser.UserServicesId, Date = ser.Date, Price = serv.Price, ServiceName = serv.ServiceName,
Status = ser.Status
};
PersonOrderList.Add(infoUserServices);
}
}
}
}
// page with all orders
using (UserContext db = new UserContext())
{
foreach (UsersServices ser in db.UsersServices)
{
foreach (DataModels.Service serv in userContext.Services)
{
foreach (User userr in userContext2.Users)
{
if (ser.ServiceId == serv.Id && ser.UserId == userr.Id)
{
AllOrders all = new AllOrders {
Id = ser.UserServicesId, Date = ser.Date, Email = userr.Email, Name = userr.FirstName, Phone = userr.Phone, Price = serv.Price, ServiceName = serv.ServiceName, Status = ser.Status
};
PersonOrderAllList.Add(all);
}
}
}
AllOrderIdCombo.Add(ser.UserServicesId);
}
}
}
public Order(string customerName, Estimate estimateDetails)
{
CustomerName = customerName;
EstimateDetails = estimateDetails;
AllOrders.Add(this);
}
private void orderAgingReport3060daysToolStripMenuItem_Click(object sender, EventArgs e)
{
AllOrders al = new AllOrders(4);
al.ShowDialog();
}
private void LoadCanceledOrders()
{
CanceledOrders = new ObservableCollection <Order>(AllOrders.Where(x => x.Ord_status == 2));
}
private void LoadNewOrders()
{
NewOrders = new ObservableCollection <Order>(AllOrders.Where(x => x.Ord_status == 0));
}
private void LoadActiveOrders()
{
ActiveOrders = new ObservableCollection <Order>(AllOrders.Where(x => x.Ord_status == 1));
}
public AddOrder(AllOrders frm1)
{
owner = frm1;
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.AddOrder_FormClosing);
InitializeComponent();
}
private void LoadDeliveredOrders()
{
DeliveredOrders = new ObservableCollection <Order>(AllOrders.Where(x => x.Ord_status == 3));
}
private void top10OutstandingCustomerToolStripMenuItem_Click(object sender, EventArgs e)
{
AllOrders al = new AllOrders(3);
al.ShowDialog();
}
