Guest User

Untitled

a guest
May 20th, 2018
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.09 KB | None | 0 0
  1. //first i am filling listview control.
  2. private void Form1_Load(object sender, EventArgs e)
  3. {
  4. FirebirdEntity asa = new FirebirdEntity();
  5.  
  6. ObjectQuery<NEW_TABLE> sorgu = asa.NEW_TABLE;
  7.  
  8. foreach (var item in sorgu)
  9. {
  10. ListViewItem list = new ListViewItem();
  11. list.Text = item.AD;
  12. list.SubItems.Add(item.SOYAD);
  13. list.Tag = item;
  14. listView1.Items.Add(list);
  15.  
  16. }
  17. //than getting New_table entity from listview's tag property.
  18. private void button3_Click(object sender, EventArgs e)
  19. {
  20.  
  21. using (FirebirdEntity arama = new FirebirdEntity())
  22. {
  23.  
  24. NEW_TABLE del = (NEW_TABLE)listView1.SelectedItems[0].Tag;
  25. arama.DeleteObject(del);
  26. arama.SaveChanges();
  27.  
  28.  
  29. }}
  30.  
  31. NEW_TABLE del = (NEW_TABLE)listView1.SelectedItems[0].Tag;
  32. arama.Attach(del);
  33. arama.DeleteObject(del);
  34. arama.SaveChanges();
  35.  
  36. private void Form1_Load(object sender, EventArgs e) {
  37. FirebirdEntity asa = new FirebirdEntity();
  38.  
  39. ObjectQuery<NEW_TABLE> sorgu = asa.NEW_TABLE;
  40. foreach (var item in sorgu) {
  41. asa.Detach(item);
  42. // add to listView1
  43. }
  44. }
  45.  
  46. public void DeleteSharedDoc(SharedDocs shareddoc)
  47. {
  48. this.ObjectContext.SharedDocs.DeleteObject(shareddoc);
  49. }
  50.  
  51. public void DeleteSharedDoc(SharedDocs shareddoc)
  52. {
  53. var query = (from w in this.ObjectContext.SharedDocs
  54. where w.UserShareName == shareddoc.UserShareName
  55. && w.UserShareUsersEmail == shareddoc.UserShareUsersEmail
  56. && w.DocumentId == shareddoc.DocumentId
  57. select w).First();
  58. this.ObjectContext.SharedDocs.DeleteObject(query);
  59. }
  60.  
  61. int id = convert.toint32(some text field from the page);
  62. entity data = new entity();
  63. var del = (from record in data.records
  64. where record.id == id
  65. select record).FirstOrDefault();
  66. data.deleteObject(del);
  67. data.saveChanges();
  68.  
  69. CREATE TABLE [dbo].[Department]
  70. (
  71. DepartmentUUID [UNIQUEIDENTIFIER] NOT NULL
  72. , DepartmentName varchar(24) not null
  73. , CreateDate smalldatetime not null
  74. )
  75. GO
  76.  
  77.  
  78. ALTER TABLE [dbo].[Department] ADD CONSTRAINT PK_Department PRIMARY KEY NONCLUSTERED (DepartmentUUID)
  79. GO
  80.  
  81. ALTER TABLE [dbo].[Department] ADD CONSTRAINT CK_DepartmentName_Unique UNIQUE (DepartmentName)
  82. GO
  83.  
  84. ALTER TABLE [dbo].[Department] ADD CONSTRAINT [DF_Department_DepartmentUUID] DEFAULT ( NEWSEQUENTIALID() ) FOR DepartmentUUID
  85. GO
  86.  
  87. ALTER TABLE [dbo].[Department] ADD CONSTRAINT [DF_Department_CreateDate] DEFAULT ( CURRENT_TIMESTAMP ) FOR CreateDate
  88. GO
  89.  
  90. public int DeleteDepartment(Guid departmentUUID)
  91. {
  92.  
  93. int returnValue = 0;
  94.  
  95. Department holder = new Department();
  96. holder.DepartmentUUID = departmentUUID; // DepartmentUUID is the primary key of this object (entity in the db)
  97.  
  98. using (MyContectObject context = new MyContectObject())
  99. {
  100. context.AttachTo("Departments", holder);
  101.  
  102. context.DeleteObject(holder);
  103.  
  104. int numOfObjectsAffected = context.SaveChanges();
  105. returnValue = numOfObjectsAffected;
  106.  
  107. context.Dispose();
  108. }
  109.  
  110. return returnValue;
  111.  
  112. }
Add Comment
Please, Sign In to add comment