/// <summary> /// Handle event click Select All button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSelectAll_Click(object sender, EventArgs e) { if (this.mode == MODE_APPROVE) { if (MessageBox.Show( "Bạn có chắc chắn muốn phê duyệt đơn nhập hàng này?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ItemOrderDTO temp = this.parent.quanLySanPhamBUS.listSPOrder[this.selectedIndex]; temp.isApproved = true; this.parent.quanLySanPhamBUS.UpdateItemOrder( this.parent.conn, temp); this.parent.quanLySanPhamBUS.AddSanPhamAfterApproveOrder(this.parent.conn, temp.listSP); this.parent.LoadSPOrderCallback(); this.parent.quanLySanPhamBUS.LoadSanPham(this.parent.conn); this.parent.dataSanPham = this.parent.quanLySanPhamBUS.listSanPham; this.parent.LoadSanPhamCallback(); this.parent.selectedBillIndex = -1; this.Close(); } } else { for (int i = 0; i < this.listSP.Items.Count; i++) { this.listSP.Items[i].Checked = true; } } }
public bool UpdateItemOrder(Connection conn, ItemOrderDTO data) { string queryString = "update ItemOrder set owner='" + data.owner + "',type=" + data.type + ",listItem='" + data.listItemID + "',isApproved=" + data.isApproved.ToString() + " where id=" + data.ID; Console.WriteLine(queryString); conn.cmd.CommandText = queryString; try { conn.cmd.ExecuteNonQuery(); for (int i = 0; i < data.listSP.Count; i++) { ItemDAO itemDAO = new ItemDAO(); data.listSP[i].isImportOrder = false; itemDAO.UpdateItem(conn, data.listSP[i]); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(false); } return(true); }
/// <summary> /// Load current order data /// </summary> /// <param name="order"></param> private void LoadOrderData(ItemOrderDTO order) { this.data = order.listSP; this.txtDate.Text = String.Format("{0:MM/dd/yyyy}", order.date); this.txtOwner.Text = order.owner; this.LoadData(); }
public List <ItemOrderDTO> LoadApprovedImport(Connection conn) { List <ItemOrderDTO> temp = new List <ItemOrderDTO>(); string queryString = "select* from ItemOrder where isApproved = true and isDeleted = false"; conn.cmd.CommandText = queryString; using (DbDataReader reader = conn.cmd.ExecuteReader()) { if (!reader.HasRows) { return(new List <ItemOrderDTO>()); } else { while (reader.Read()) { ItemOrderDTO data = new ItemOrderDTO( reader.GetInt32(0), reader.GetDateTime(1), reader.GetString(2), reader.GetInt32(3), reader.GetString(4), reader.GetBoolean(5)); temp.Add(data); } } } return(temp); }
public bool AddItemOrder(Connection conn, ItemOrderDTO data) { string queryString = ""; for (int i = 0; i < data.listSP.Count; i++) { ItemDAO itemDAO = new ItemDAO(); data.listSP[i].isImportOrder = true; itemDAO.UpdateItem(conn, data.listSP[i]); } queryString = "insert into ItemOrder(createddate, owner, type, listItem, isApproved) " + "values('" + String.Format("{0:yyyy/MM/dd}", DateTime.Now) + "'," + "'" + data.owner + "'," + data.type + "," + "'" + this.BuildListIDString(data.listSP) + "'" + ", false)"; Console.WriteLine(queryString); conn.cmd.CommandText = queryString; try { conn.cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(false); } return(true); }
public CreateSanPhamImportOrder(InitPage parent, int mode, ItemOrderDTO order, int itemOrder) { this.InitializeComponent(); this.parent = parent; this.selectedIndex = itemOrder; this.mode = mode; this.InitFormSetting(); this.LoadOrderData(order); }
/// <summary> /// Add SanPham's Import Order to DB /// </summary> /// <param name="repository"></param> public void AddSanPhamImportOrder(Connection conn, ItemOrderDTO data) { if (this.itemOrderDAO.AddItemOrder(conn, data)) { this.LoadSanPhamOrder(conn); } else { MessageBox.Show( "Có lỗi xảy ra trong quá trình thêm dữ liệu, vui lòng thử lại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <ItemOrderDTO> getAllItemOrder(Connection conn) { List <ItemOrderDTO> result = new List <ItemOrderDTO>(); string queryString = "select* from ItemOrder where isApproved = false and isDeleted = false"; conn.cmd.CommandText = queryString; using (DbDataReader reader = conn.cmd.ExecuteReader()) { if (!reader.HasRows) { return(new List <ItemOrderDTO>()); } else { while (reader.Read()) { ItemOrderDTO temp = new ItemOrderDTO( reader.GetInt32(0), reader.GetDateTime(1), reader.GetString(2), reader.GetInt32(3), reader.GetString(4), reader.GetBoolean(5)); result.Add(temp); } } } for (int i = 0; i < result.Count; i++) { string[] listSPID = result[i].listItemID.Trim().Split(' '); List <ItemDTO> listOrderItem = new List <ItemDTO>(); for (int j = 0; j < listSPID.Length; j++) { ItemDAO itemDAO = new ItemDAO(); if (itemDAO.getItemByID(conn, Convert.ToInt32(listSPID[j])).ID != -1) { listOrderItem.Add(itemDAO.getItemByID(conn, Convert.ToInt32(listSPID[j]))); } } result[i].listSP = listOrderItem; } return(result); }
/// <summary> /// Handle event click Confirm button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnOK_Click(object sender, EventArgs e) { if (this.mode == MODE_CREATE_IMPORT) { if (MessageBox.Show( "Bạn có chắc muốn lập đơn nhập hàng này?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { // Get all selected Item List <ItemDTO> selectedItem = new List <ItemDTO>(); for (int i = 0; i < this.listSP.Items.Count; i++) { if (this.listSP.Items[i].Checked) { selectedItem.Add(this.data[i]); } } ItemOrderDTO temp = new ItemOrderDTO( DateTime.Now, this.parent.currentUser.name, ItemOrderDTO.IMPORT, selectedItem, false); this.parent.quanLySanPhamBUS.AddSanPhamImportOrder(this.parent.conn, temp); this.parent.LoadSPOrderCallback(); this.parent.quanLySanPhamBUS.LoadSanPham(this.parent.conn); this.parent.dataSanPham = this.parent.quanLySanPhamBUS.listSanPham; this.parent.LoadSanPhamCallback(); } this.Close(); } else if (this.mode == MODE_CREATE_RETURN) { } else if (this.mode == MODE_APPROVE) { } }
public bool DeleteItemOrder(Connection conn, ItemOrderDTO data) { string queryString = "update ItemOrder set isDeleted=true where id=" + data.ID; Console.WriteLine(queryString); conn.cmd.CommandText = queryString; try { conn.cmd.ExecuteNonQuery(); for (int i = 0; i < data.listSP.Count; i++) { ItemDAO itemDAO = new ItemDAO(); data.listSP[i].isImportOrder = false; itemDAO.UpdateItem(conn, data.listSP[i]); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(false); } return(true); }