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