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