private void btnAccept_Click(object sender, EventArgs e) { if (!ConstructItem()) { return; } using (var context = new MarketDBEntities()) { try { if (isNewRow) { context.Products.Add(product); context.SaveChanges(); } else { UpdateItem(); } } catch (DbUpdateException ex) { Helper.PostError(ex.InnerException.InnerException.Message); } catch (Exception ex) { Helper.PostError(ex.Message); } } DialogResult = DialogResult.OK; }
private void InoiceReportForm_Load(object sender, EventArgs e) { using (MarketDBEntities context = new MarketDBEntities()) { var query = from cart in context.CartViews where cart.Order_id == order.Order_id select cart; ReportDataSource rds = new ReportDataSource("DataSet2", query.ToList()); reportViewer.LocalReport.DataSources.Add(rds); ReportParameter[] rParams = new ReportParameter[] { new ReportParameter("pOrderID", order.Order_id.ToString()), new ReportParameter("pOrderNumber", order.Order_number), new ReportParameter("pDiscountCard", order.Customer.Discount_card), new ReportParameter("pCustomerName", order.Customer.Full_name), new ReportParameter("pEmployeeName", order.Employee.Full_name), new ReportParameter("pOrderDate", order.Order_date.ToShortDateString()), new ReportParameter("pOrderCompletionDate", order.Completion_date.ToShortDateString()), new ReportParameter("pReportDate", DateTime.Now.ToShortDateString()), new ReportParameter("pTotal", order.Total_cost.ToString()) }; reportViewer.LocalReport.SetParameters(rParams); } reportViewer.RefreshReport(); reportViewer.SetDisplayMode(DisplayMode.PrintLayout); reportViewer.ZoomMode = ZoomMode.PageWidth; this.reportViewer.RefreshReport(); }
/// <summary> /// Заполнение экземпляра типа данными из полей формы. /// </summary> /// <returns>Возвращает true, если экземпляр типа заполнен успешно.</returns> private bool ConstructItem() { if (ValidateItems()) { if (isNewRow) { using (MarketDBEntities entities = new MarketDBEntities()) { var newID = (from user in entities.Users select user.User_id).Max() + 1; cart.Cart_id = newID; } } else { cart.Cart_id = oldKey; } cart.Product_code = productCodeComboBox.SelectedValue.ToString(); cart.Amount = Convert.ToInt32(amountTextBox.Text); cart.Price = Convert.ToDecimal(priceTextBox.Text); cart.Order_id = orderID; return(true); } else { return(false); } }
/// <summary> /// Загрузка данных в контекст для выпадающего списка. /// </summary> private void LoadData() { using (MarketDBEntities entities = new MarketDBEntities()) { List <Customer> customers = (from Customer in entities.Customers select Customer).ToList(); customerComboBox.DataSource = customers; customerComboBox.DisplayMember = "Full_name"; customerComboBox.ValueMember = "Customer_id"; customerComboBox.SelectedIndex = -1; List <Employee> employees = (from Employee in entities.Employees select Employee).ToList(); var entity = new Employee(); entity.Employee_id = -1; entity.Full_name = "<Сотрудник не выбран>"; employees.Insert(0, entity); employeeComboBox.DataSource = employees; employeeComboBox.DisplayMember = "Full_name"; employeeComboBox.ValueMember = "Employee_id"; employeeComboBox.SelectedIndex = 0; List <Status> statuses = (from Status in entities.Statuses select Status).ToList(); statusComboBox.DataSource = statuses; statusComboBox.DisplayMember = "Statuse_name"; statusComboBox.ValueMember = "Statuse_code"; statusComboBox.SelectedIndex = 1; } }
public ActionResult DeleteFromCart(string itemId) { if (Session["UserId"] != null && !string.IsNullOrEmpty(itemId)) { string sUserId = Session["UserId"].ToString(); using (MarketDBEntities db = new MarketDBEntities()) { var SPDS = (from sp in db.ShoppingList where sp.itemId == itemId && sp.UserId == sUserId select sp).FirstOrDefault(); if (SPDS != null) { var PDDS = (from pl in db.ProductList where pl.itemid == itemId select pl).FirstOrDefault(); if (PDDS != null) { PDDS.left_amount = PDDS.left_amount + SPDS.amount; } db.ShoppingList.Remove(SPDS); db.SaveChanges(); } } } return(RedirectToAction("ShoppingCart")); }
/// <summary> /// Метод настройки названий и кнопок. /// </summary> void SetUpGUI() { using (MarketDBEntities context = new MarketDBEntities()) { List <Status> statuses = (from Status in context.Statuses select Status).ToList(); var entity = new Status(); entity.Statuse_code = "_EMPTY_"; entity.Statuse_name = "<Статус не выбран>"; statuses.Insert(0, entity); cmbStatuses.DataSource = statuses; cmbStatuses.ValueMember = "Statuse_name"; cmbStatuses.DisplayMember = "Statuse_name"; cmbStatuses.SelectedItem = "<Статус не выбран>"; } ordersDataGridView.Columns[0].HeaderText = "Ид"; ordersDataGridView.Columns[1].HeaderText = "ФИО клиента"; ordersDataGridView.Columns[2].HeaderText = "ФИО сотрудника"; ordersDataGridView.Columns[3].HeaderText = "Номер заказа"; ordersDataGridView.Columns[4].HeaderText = "Дата заказа"; ordersDataGridView.Columns[5].HeaderText = "Дата завершения"; ordersDataGridView.Columns[6].HeaderText = "Статус"; ordersDataGridView.Columns[7].HeaderText = "Полная стоимость"; ordersDataGridView.Columns[8].HeaderText = "Оплачено"; ordersDataGridView.Columns[9].HeaderText = "Причина отмены"; ordersDataGridView.Columns[0].Visible = false; ordersDataGridView.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; ordersDataGridView.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; ordersDataGridView.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; }
/// <summary> /// Заполнение экземпляра типа данными из полей формы. /// </summary> /// <returns>Возвращает true, если экземпляр типа заполнен успешно.</returns> private bool ConstructItem() { if (ValidateItems()) { if (isNewRow) { using (MarketDBEntities entities = new MarketDBEntities()) { var newID = (from customer in entities.Customers select customer.Customer_id).Max() + 1; customer.Customer_id = newID; } } else { customer.Customer_id = oldKey; } customer.User_id = Convert.ToInt32(userComboBox.SelectedValue); customer.Full_name = fullNameTextBox.Text; customer.Email = emailTextBox.Text.Equals("") ? null : emailTextBox.Text; customer.Phone = phoneTextBox.Text; customer.Adress = adressTextBox.Text.Equals("") ? null : adressTextBox.Text; customer.Discount_card = dicountCardTextBox.Text; customer.Registration_date = registrationDateDateTimePicker.Value; userComboBox.SelectedIndex = -1; return(true); } else { return(false); } }
public ActionResult Register(UserInfo userit) { if (userit != null && !string.IsNullOrEmpty(userit.UserId) && !string.IsNullOrEmpty(userit.UserName)) { using (MarketDBEntities db = new MarketDBEntities()) { var UserDs = (from us in db.UserInfo where us.UserId == userit.UserId select us).FirstOrDefault(); if (UserDs != null) { ViewBag.Errmsg = "使用者已存在!"; return(View("Register")); } else { UserInfo InsUserInfo = new UserInfo(); InsUserInfo.UserId = userit.UserId; InsUserInfo.UserName = userit.UserName; db.UserInfo.Add(InsUserInfo); db.SaveChanges(); Session["UserId"] = userit.UserId; Session["UserName"] = userit.UserName; } } } else { ViewBag.Errmsg = "請輸入有效的使用者資料"; return(View()); } return(View("Index")); }
/// <summary> /// Заполнение экземпляра типа данными из полей формы. /// </summary> /// <returns>Возвращает true, если экземпляр типа заполнен успешно.</returns> private bool ConstructItem() { if (ValidateItems()) { if (isNewRow) { using (MarketDBEntities entities = new MarketDBEntities()) { var newID = (from employee in entities.Employees select employee.Employee_id).Max() + 1; employee.Employee_id = newID; } } else { employee.Employee_id = oldKey; } employee.User_id = Convert.ToInt32(userComboBox.SelectedValue); employee.Full_name = fullNameTextBox.Text; employee.Phone = phoneTextBox.Text; employee.Position = positionTextBox.Text; userComboBox.SelectedIndex = -1; return(true); } else { return(false); } }
/// <summary> /// Заполнение экземпляра типа данными из полей формы. /// </summary> /// <returns>Возвращает true, если экземпляр типа заполнен успешно.</returns> private bool ConstructItem() { if (ValidateItems()) { if (isNewRow) { using (MarketDBEntities entities = new MarketDBEntities()) { var newID = (from delivery in entities.Deliveries select delivery.Delivery_id).Max() + 1; delivery.Delivery_id = newID; } } else { delivery.Delivery_id = oldKey; } delivery.Track_number = trackNumberTextBox.Text; delivery.Phone = phoneTextBox.Text; delivery.Delivery_type = deliveryTypeTextBox.Text; delivery.Delivery_date = deliveryDateDateTimePicker.Value; delivery.Statuse_code = statusComboBox.SelectedValue.ToString(); delivery.Order_id = Convert.ToInt32(orderNumberComboBox.SelectedValue); return(true); } else { return(false); } }
private void InvoiceToolStripButton_Click(object sender, EventArgs e) { using (var context = new MarketDBEntities()) { try { int index = ordersDataGridView.SelectedRows[0].Index; Order order = context.Orders.Find(ordersDataGridView[0, index].Value); if (order.Statuse_code == "З04") { var query = from cart in context.CartViews where cart.Order_id == order.Order_id select cart; InoiceReportForm rptForm = new InoiceReportForm(order, query.ToList()); rptForm.ShowDialog(); } } catch (Exception ex) { Helper.PostError(ex.Message); } } }
/// <summary> /// Заполнение экземпляра типа данными из полей формы. /// </summary> /// <returns>Возвращает true, если экземпляр типа заполнен успешно.</returns> private bool ConstructItem() { if (ValidateItems()) { if (isNewRow) { using (MarketDBEntities entities = new MarketDBEntities()) { var newID = (from user in entities.Users select user.User_id).Max() + 1; user.User_id = newID; } } else { user.User_id = oldKey; } user.Login = loginTextBox.Text; user.Password = passwordTextBox.Text; user.Role_code = roleComboBox.SelectedValue.ToString(); return(true); } else { return(false); } }
// GET: Market public ActionResult Index(string s = "1") { using (MarketDBEntities db = new MarketDBEntities()) { var DS = (from pl in db.ProductList select pl); return(View(DS.ToList())); } }
/// <summary> /// Загрузка данных в контекст для выпадающего списка. /// </summary> private void LoadData() { MarketDBEntities entities = new MarketDBEntities(); List <Category> categories = (from Category in entities.Categories select Category).ToList(); categoryComboBox.DataSource = categories; categoryComboBox.SelectedIndex = -1; categoryComboBox.DisplayMember = "Category_name"; categoryComboBox.ValueMember = "Category_Code"; }
public List <TB_CategorySurrogate> GetCategories() { using (MarketDBEntities db = new MarketDBEntities()) { return((from q in db.TB_Category select new TB_CategorySurrogate { CategoryID = q.CategoryID, CategoryName = q.CategoryName }).ToList()); } }
/// <summary> /// Загрузка данных в контекст для выпадающего списка. /// </summary> private void LoadData() { using (MarketDBEntities entities = new MarketDBEntities()) { List <User> user = (from User in entities.Users select User).ToList(); userComboBox.DataSource = user; userComboBox.DisplayMember = "Login"; userComboBox.ValueMember = "User_id"; userComboBox.SelectedIndex = -1; } }
/// <summary> /// Загрузка данных в контекст для выпадающего списка. /// </summary> private void LoadData() { using (MarketDBEntities entities = new MarketDBEntities()) { List <Role> roles = (from role in entities.Roles select role).ToList(); roleComboBox.DataSource = roles; roleComboBox.SelectedIndex = -1; roleComboBox.DisplayMember = "Name"; roleComboBox.ValueMember = "Role_code"; } }
/// <summary> /// Загрузка данных в контекст для выпадающего списка. /// </summary> private void LoadData() { using (MarketDBEntities entities = new MarketDBEntities()) { List <Product> product = (from Product in entities.Products select Product).ToList(); productCodeComboBox.DataSource = product; productCodeComboBox.DisplayMember = "Product_name"; productCodeComboBox.ValueMember = "Product_code"; productCodeComboBox.SelectedIndex = -1; } }
public ActionResult AddCart(string itemId) { try { using (MarketDBEntities db = new MarketDBEntities()) { if (!string.IsNullOrEmpty(itemId)) { //string sUserId = "KrisIdoit"; if (Session["UserId"] == null) { return(RedirectToAction("Index")); } string sUserId = Session["UserId"].ToString(); if (string.IsNullOrEmpty(sUserId)) { return(RedirectToAction("Index")); } var itDtl = (from pl in db.ProductList where pl.itemid == itemId select pl).FirstOrDefault(); if (itDtl.left_amount != 0) { itDtl.left_amount = itDtl.left_amount - 1; var spit = (from sp in db.ShoppingList where sp.itemId == itemId && sp.UserId == sUserId select sp).FirstOrDefault(); if (spit != null) { spit.amount = spit.amount + 1; } else { Entity.ShoppingList insToSp = new ShoppingList(); insToSp.itemId = itemId; insToSp.UserId = sUserId; insToSp.amount = 1; db.ShoppingList.Add(insToSp); } db.SaveChanges(); } } return(RedirectToAction("Index")); } } catch (Exception) { throw; } }
/// <summary> /// Заполнение экземпляра типа данными из полей формы. /// </summary> /// <returns>Возвращает true, если экземпляр типа заполнен успешно.</returns> private bool ConstructItem() { if (ValidateItems()) { if (isNewRow) { using (MarketDBEntities entities = new MarketDBEntities()) { newID = (from order in entities.Orders select order.Order_id).Max() + 1; order.Order_id = newID; } } else { order.Order_id = oldKey; } order.Customer_id = Convert.ToInt32(customerComboBox.SelectedValue); if (employeeComboBox.SelectedIndex == 0) { order.Employee_id = null; } else { order.Employee_id = Convert.ToInt32(employeeComboBox.SelectedValue); } order.Order_number = orderNumberTextBox.Text; order.Order_date = orderDateDateTimePicker.Value; order.Completion_date = completionDateDateTimePicker.Value; order.Total_cost = totalCostTextBox.Text.Equals("") ? 0 : Convert.ToDecimal(totalCostTextBox.Text); order.Paid = paidTextBox.Text.Equals("") ? 0 : Convert.ToDecimal(paidTextBox.Text); order.Statuse_code = statusComboBox.SelectedValue.ToString(); if (!String.IsNullOrWhiteSpace(cancellationSignTextBox.Text)) { order.Cancellation_sign = cancellationSignTextBox.Text; } else { order.Cancellation_sign = null; } return(true); } else { return(false); } }
public List <TB_ColorSurrogate> GetColors() { using (MarketDBEntities db = new MarketDBEntities()) { return((from q in db.TB_Color select new TB_ColorSurrogate { ColoID = q.ColoID, ColorCode = q.ColorCode, ColorName = q.ColorName }).ToList()); } }
public static void ChangeDatabase( this MarketDBEntities source, string initialCatalog = "", string dataSource = "", string userId = "", string password = "", bool integratedSecuity = true ) { string configConnectionStringName = "MarketDB"; try { var configNameEf = string.IsNullOrEmpty(configConnectionStringName) ? source.GetType().Name : configConnectionStringName; var entityCnxStringBuilder = new EntityConnectionStringBuilder (System.Configuration.ConfigurationManager .ConnectionStrings[configNameEf].ConnectionString); var sqlCnxStringBuilder = new SqlConnectionStringBuilder (entityCnxStringBuilder.ProviderConnectionString); if (!string.IsNullOrEmpty(initialCatalog)) { sqlCnxStringBuilder.InitialCatalog = initialCatalog; } if (!string.IsNullOrEmpty(dataSource)) { sqlCnxStringBuilder.DataSource = dataSource; } if (!string.IsNullOrEmpty(userId)) { sqlCnxStringBuilder.UserID = userId; } if (!string.IsNullOrEmpty(password)) { sqlCnxStringBuilder.Password = password; } sqlCnxStringBuilder.IntegratedSecurity = integratedSecuity; source.Database.Connection.ConnectionString = sqlCnxStringBuilder.ConnectionString; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public bool UpdateCategory(TB_CategorySurrogate category) { using (MarketDBEntities db = new MarketDBEntities()) { TB_Category c = db.TB_Category.FirstOrDefault(q => q.CategoryID == category.CategoryID); if (c != null) { c.CategoryName = category.CategoryName; db.SaveChanges(); return(true); } } return(false); }
private void ChartForm_Load(object sender, EventArgs e) { using (MarketDBEntities entities = new MarketDBEntities()) { List <Category> category = (from Category in entities.Categories select Category).ToList(); categoriesComboBox.DataSource = category; categoriesComboBox.DisplayMember = "Category_name"; categoriesComboBox.ValueMember = "Category_Code"; categoriesComboBox.SelectedIndex = 1; } dtpBeg.Value = new DateTime(dtpEnd.Value.Year - 1, dtpEnd.Value.Month, dtpEnd.Value.Day); }
public bool AddCategory(TB_CategorySurrogate category) { using (MarketDBEntities db = new MarketDBEntities()) { TB_Category c = new TB_Category(); if (db.TB_Category.FirstOrDefault(q => q.CategoryName == category.CategoryName) == null) { c.CategoryName = category.CategoryName; db.TB_Category.Add(c); db.SaveChanges(); return(true); } } return(false); }
private void productCodeComboBox_SelectedIndexChanged(object sender, EventArgs e) { if (productCodeComboBox.SelectedIndex != -1) { using (MarketDBEntities entities = new MarketDBEntities()) { var product = entities.Products.SingleOrDefault(b => b.Product_code == productCodeComboBox.SelectedValue.ToString()); priceTextBox.Text = product.Price.ToString(); } } else { priceTextBox.Text = ""; } }
/// <summary> /// Отправка запроса на изменение данных. /// </summary> private void UpdateItem() { using (MarketDBEntities entities = new MarketDBEntities()) { var user = entities.Users.SingleOrDefault(b => b.User_id == oldKey); if (user != null) { user.User_id = this.user.User_id; user.Login = this.user.Login; user.Password = this.user.Password; user.Role_code = this.user.Role_code; entities.SaveChanges(); } } }
public bool AddProduct(TB_ProductSurrogate product) { using (MarketDBEntities db = new MarketDBEntities()) { TB_Product p = new TB_Product(); p.CategoryID = product.Category.CategoryID; p.CityID = product.City.CityID; p.ColorID = product.Color.ColoID; p.DateAdded = DateTime.Now; p.Price = product.Price; p.Title = product.Title; db.TB_Product.Add(p); db.SaveChanges(); return(true); } }
/// <summary> /// Отправка запроса на изменение данных. /// </summary> private void UpdateItem() { using (MarketDBEntities entities = new MarketDBEntities()) { var employee = entities.Employees.SingleOrDefault(b => b.Employee_id == oldKey); if (employee != null) { employee.Employee_id = this.employee.Employee_id; employee.User_id = this.employee.User_id; employee.Full_name = this.employee.Full_name; employee.Phone = this.employee.Phone; employee.Position = this.employee.Position; entities.SaveChanges(); } } }
/// <summary> /// Отправка запроса на изменение данных. /// </summary> private void UpdateItem() { using (MarketDBEntities entities = new MarketDBEntities()) { var cart = entities.Carts.SingleOrDefault(b => b.Cart_id == oldKey); if (cart != null) { cart.Cart_id = this.cart.Cart_id; cart.Product_code = this.cart.Product_code; cart.Amount = this.cart.Amount; cart.Price = this.cart.Price; cart.Order_id = this.cart.Order_id; entities.SaveChanges(); } } }