private void updateData() { using (var context = new UniContext()) { // Load all students and related enrollments rooms = context.Rooms.ToList(); items = context.Items.ToList(); binas = context.Binas.ToList(); otaqsave.ItemsSource = rooms; otaqsave.DisplayMemberPath = "Name"; otaqsave.SelectedValuePath = "RoomID"; otaqsave.SelectedIndex = 0; inventarsave.ItemsSource = items; inventarsave.DisplayMemberPath = "Name"; inventarsave.SelectedValuePath = "ItemID"; inventarsave.SelectedIndex = 0; binasave.ItemsSource = binas; binasave.DisplayMemberPath = "Name"; binasave.SelectedValuePath = "BinaId"; binasave.SelectedIndex = 0; } }
private void importfromexcel(object sender, RoutedEventArgs e) { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook workbook; Microsoft.Office.Interop.Excel.Worksheet worksheet; Microsoft.Office.Interop.Excel.Range range; workbook = excelApp.Workbooks.Open("C:/" + "testitem.xlsx"); worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets["Test Sheet"]; int column = 0; int row = 0; range = worksheet.UsedRange; using (var context = new UniContext()) { for (row = 2; row <= range.Rows.Count; row++) { for (column = 1; column <= range.Columns.Count; column++) { Item itemObj = new Item { Name = (range.Cells[row, column] as Microsoft.Office.Interop.Excel.Range).Value2.ToString(), }; context.Items.Add(itemObj); } } context.SaveChangesAsync(); } workbook.Close(true, Missing.Value, Missing.Value); excelApp.Quit(); }
private void Button_Click_4(object sender, RoutedEventArgs e) { using (var context = new UniContext()) { if (!string.IsNullOrEmpty(adAdd.Text)) { var item = new Item { Name = adAdd.Text, }; context.Items.Add(item); } if (!string.IsNullOrEmpty(inventarAdd.Text)) { var room = new Room { Name = inventarAdd.Text, }; context.Rooms.Add(room); } if (!string.IsNullOrEmpty(binaAdd.Text)) { var bina = new Bina { Name = binaAdd.Text, }; context.Binas.Add(bina); } context.SaveChanges(); adAdd.Clear(); inventarAdd.Clear(); binaAdd.Clear(); updateData(); } }
private void Button_Click_2(object sender, RoutedEventArgs e) { view.Visibility = Visibility.Visible; edit.Visibility = Visibility.Hidden; if (otaqedit.SelectedValue != null) { roomId = int.Parse(otaqedit.SelectedValue.ToString()); } if (adedit.SelectedValue != null) { itemId = int.Parse(adedit.SelectedValue.ToString()); } if (binaedit.SelectedValue != null) { binaId = int.Parse(binaedit.SelectedValue.ToString()); } using (var context = new UniContext()) { item = context.Inventars.Where(i => i.Barcode == searchtxt.Text).FirstOrDefault(); item.SN = snedit.Text; item.Note = new TextRange(qeydedit.Document.ContentStart, qeydedit.Document.ContentEnd).Text; item.Count = int.Parse(sayedit.Text); item.Year = int.Parse(iledit.Text); item.Person = msedit.Text; item.Room = context.Rooms.Find(roomId); item.Item = context.Items.Find(itemId); item.Bina = context.Binas.Find(binaId); context.SaveChanges(); } ShowView(); }
private void searchtxt_changed(object sender, TextChangedEventArgs e) { using (var context = new UniContext()) { item = context.Inventars.Where(i => i.Barcode == searchtxt.Text).FirstOrDefault(); if (item != null) { ShowView(); var inventar = new Checked { ChechkedTime = DateTime.Now, Inventar = item, }; context.CheckedItem.Add(inventar); context.SaveChanges(); } } }
private void Button_Click(object sender, RoutedEventArgs e) { if (String.IsNullOrEmpty(saysave.Text) | String.IsNullOrEmpty(mssave.Text) | rooms == null | items == null | binas == null | string.IsNullOrEmpty(otaqsave.SelectedValue.ToString()) | string.IsNullOrEmpty(inventarsave.SelectedValue.ToString()) | string.IsNullOrEmpty(binasave.SelectedValue.ToString()) ) { ersave.Content = "Bütün xanaları Doldurun"; return; } using (var context = new UniContext()) { roomId = (int)otaqsave.SelectedValue; itemId = (int)inventarsave.SelectedValue; binaId = (int)binasave.SelectedValue; if (!int.TryParse(saysave.Text, out say)) { say = 1; } if (!int.TryParse(ilsave.Text, out il)) { il = 0; } var r = context.Rooms.Find(roomId); var b = context.Binas.Find(binaId); var inventar = new Inventar { SN = snsave.Text, Count = say, Year = il, Person = mssave.Text, Note = new TextRange(qeydsave.Document.ContentStart, qeydsave.Document.ContentEnd).Text, CreateDate = DateTime.Now, Room = r, Bina = b, Item = context.Items.Find(itemId), }; var inven = context.Inventars.Add(inventar); try { context.SaveChanges(); string barkod = ("SB" + r.Name + "R" + b.Name + "F" + "-" + inven.InventarID).Replace(" ", String.Empty); inven.Barcode = barkod; context.SaveChanges(); updateGridData(); snsave.Clear(); qeydsave.Document.Blocks.Clear(); mssave.Clear(); saysave.Clear(); ilsave.Clear(); ersave.Content = "Yaddaşa verildi"; string dataDir = System.AppDomain.CurrentDomain.BaseDirectory; ersave.Content = "Şəkil düzəlir.."; BarcodeLib.Barcode ba = new BarcodeLib.Barcode(); System.Drawing.Image img = ba.Encode(BarcodeLib.TYPE.CODE128, barkod, System.Drawing.Color.Black, System.Drawing.Color.White, 450, 180); if (!Directory.Exists("C:/barkodlar/")) { Directory.CreateDirectory("C:/barkodlar/"); } if (!Directory.Exists("C:/barkodlar/" + r.Name)) { Directory.CreateDirectory("C:/barkodlar/" + r.Name); } if (!Directory.Exists("C:/barkodlar/" + r.Name + "/" + b.Name)) { Directory.CreateDirectory("C:/barkodlar/" + r.Name + "/" + b.Name); } for (int i = 0; i < say; i++) { img.Save("C:/" + "/barkodlar/" + r.Name + "/" + b.Name + "/" + barkod + "c" + i + ".png", ImageFormat.Png); } barimage.Source = new BitmapImage(new Uri("C:/" + "/barkodlar/" + r.Name + "/" + b.Name + "/" + barkod + "c0" + ".png")); ersave.Content = "yadda saxlanıldı"; } catch (Exception ex) { Debug.WriteLine(ex); ersave.Content = ex; } } }