public static ObservableCollection <ManagerListAddedBook> GetImported() { ObservableCollection <ManagerListAddedBook> result = null; try { var reader = DataConnector.ExecuteQuery("select MaPhieuNhap,NgayNhapKho,NgayTaoPhieu,MaTaiKhoan from PhieuNhap where DaNhap = 'true'"); if (reader != null) { result = new ObservableCollection <ManagerListAddedBook>(); while (reader.Read()) { var id = reader.GetInt32(0); var item = new ManagerListAddedBook(id); item.BeginInit(); item.DateCreated = reader.GetDateTime(1); item.DateAddIntoStorage = reader.GetDateTime(2); item.IDManager = (int)reader.GetValueDefault(3, 0); item.EndInit(); result.Add(item); } } } catch (Exception ex) { ErrorManager.Current.DataCantBeRead.Call(ex.Message); } return(result); }
private void lv_ListPN_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (lv_ListPN.SelectedItem != null) { SelectedMLAB = lv_ListPN.SelectedItem as ManagerListAddedBook; SelectedMLAB.ListAddedBook = new ObservableCollection <AddedBook>(); SelectedMLAB.ListAddedBook = Bus.FillData.GetAllListAddedBook(SelectedMLAB.ID); //NotifyPropertyChanged("SelectedMLAB"); } }
public static void UpdateIsImported(ManagerListAddedBook mlab) { try { DataConnector.ExecuteNonQuery(string.Format("update PhieuNhap set DaNhap='true' where MaPhieuNhap={0}", mlab.ID)); } catch (Exception ex) { ErrorManager.Current.DataCantBeRead.Call(ex.Message); } }
public static void Update(ManagerListAddedBook mlab) { try { DataConnector.ExecuteNonQuery(string.Format("update PhieuNhap set NgayNhapKho='{0}' where MaPhieuNhap={1}", mlab.DateAddIntoStorage, mlab.ID)); } catch (Exception ex) { ErrorManager.Current.DataCantBeRead.Call(ex.Message); } }
public static void Delete(ManagerListAddedBook mlab) { try { DataConnector.ExecuteNonQuery("delete from PhieuNhap where MaPhieuNhap=" + mlab.ID); } catch (Exception ex) { ErrorManager.Current.DataCantBeRead.Call(ex.Message); } }
private void btn_DeletePN(object sender, RoutedEventArgs e) { Button btn = sender as Button; if (btn.Tag != null) { ManagerListAddedBook mlab = btn.Tag as ManagerListAddedBook; ListMLAB.Remove(mlab); NotifyPropertyChanged("ListMLAB"); Bus.DeleteData.DeleteManagerListAddedBook(mlab); } }
public static int Insert(ManagerListAddedBook mlab) { try { DataConnector.ExecuteNonQuery(string.Format("insert into PhieuNhap(NgayNhapKho,NgayTaoPhieu,MaTaiKhoan) values('{0}','{1}',{2})", mlab.DateAddIntoStorage, DateTime.Now, mlab.IDManager)); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } return(-1); }
public static void SaveChangesListAddedBook(ManagerListAddedBook SelectedMLAB) { foreach (var item in SelectedMLAB.ListAddedBook) { if (item.IsEditedItem) { Adapters.AddedBookAdapter.UpdateAddedBook(item); } if (item.IsDeletedItem) { Adapters.AddedBookAdapter.DeleteAddedBook(item); } } }
public static void DeleteManagerListAddedBook(ManagerListAddedBook mlab) { if (mlab.ListAddedBook.Count <= 0) { Adapters.ManagerListAddedBookAdapter.Delete(mlab); } else { foreach (AddedBook item in mlab.ListAddedBook) { item.IsDeletedItem = true; Bus.SaveChanges.SaveChangesListAddedBook(mlab); } Adapters.ManagerListAddedBookAdapter.Delete(mlab); } }
private void btn_Search_Click(object sender, RoutedEventArgs e) { if (tb_Search.Text != "") { ManagerListAddedBook mlab = ListMLAB.FirstOrDefault(x => x.ID.ToString() == tb_Search.Text.ToString()); if (mlab == null) { ErrorManager.Current.InfoIsNull.Call("Không tìm được phiếu có mã cần tìm!"); tb_Search.Text = ""; } else { lv_ListPN.SelectedItem = mlab; lv_ListPN.ScrollIntoView(mlab); } } }
public static void InsertNewAddedBook(ManagerListAddedBook mlab) { Adapters.ManagerListAddedBookAdapter.Insert(mlab); var IDmanager = Adapters.ManagerListAddedBookAdapter.GetLatestId(); foreach (var item in mlab.ListAddedBook) { if (item.Book.IsCreatedItem) { Bus.InsertData.InsertNewBook(item.Book); var id = Adapters.BookAdapter.GetLatestId(); if (id > 0) { Adapters.AddedBookAdapter.InsertAddedBookItem(IDmanager, id, item); } } else { Adapters.AddedBookAdapter.InsertAddedBookItem(IDmanager, item.Book.ID, item); } } }
private void btn_Done_Click(object sender, RoutedEventArgs e) { if (lv_PhieuNhapSach.Items.Count > 0) { if (dt_DateInclude.SelectedDate == null || dt_DateInclude.SelectedDate.Value.Date < DateTime.Now.Date) { ErrorManager.Current.WrongDateTime.Call("Vui lòng chọn lại ngày nhập kho được tính từ hôm nay trở về sau!"); return; } string erroritems = ""; foreach (var item in ListAddedBook) { if (item.Book.Number > Managers.RuleManager.Current.Rule.MinNumberToImport) { erroritems += item.Book.Name + ", "; lv_PhieuNhapSach.SelectedItems.Add(item); } } if (erroritems != "") { erroritems = erroritems.TrimEnd(',', ' '); ErrorManager.Current.BookCantInsert.Call(erroritems + " còn nhiều, không được nhập thêm. Vui lòng gỡ bỏ chúng khỏi phiếu!"); return; } else { ManagerListAddedBook mlab = new ManagerListAddedBook(); mlab.ListAddedBook = ListAddedBook; mlab.DateAddIntoStorage = dt_DateInclude.SelectedDate.Value; mlab.IDManager = Manager.Current.User.Info.ID; Bus.InsertData.InsertNewAddedBook(mlab); ListAddedBook = new ObservableCollection <AddedBook>(); tb_BookName.Text = ""; tb_BookName.SelectedItem = null; } } }
public static void SaveChangeManagerListAddedBook(ManagerListAddedBook mlab) { Adapters.ManagerListAddedBookAdapter.Update(mlab); }