public string documentTableSelectByDocNameForGroupDoc(string docName, string gId) { gtemp = context.GroupTables.SingleOrDefault(x => x.group_id == gId); int noofdoc = gtemp.total_document; docgroupid = 0; for (int i = 0; i < noofdoc; i++) { dgtemp = context2.DocumentAndGroupTables.First(x => x.group_id == gId && x.doc_group_id > docgroupid); docgroupid = dgtemp.doc_group_id; string docId = dgtemp.doc_id; dtemp = context.DocumentTables.SingleOrDefault(x => x.doc_id == docId); string name = dtemp.doc_name; if (name.Equals(docName)) { break; } else { continue; } } return(dtemp.doc_id); }
public string documentAndGroupTableSelectAndReturnDocName(string gId) { dgtemp = context2.DocumentAndGroupTables.First(x => x.group_id == gId && x.doc_group_id > docgroupid); docgroupid = dgtemp.doc_group_id; string docId = dgtemp.doc_id; dtemp = context.DocumentTables.SingleOrDefault(x => x.doc_id == docId); return(dtemp.doc_name); }
//Deleting from DocumentAndGroupTable public void deleteFromDocumentAndGroupTableAndNoOfDocDecreaseInGroupTable(string docId, string gId) { dgtemp = context2.DocumentAndGroupTables.SingleOrDefault(x => x.doc_id == docId && x.group_id == gId); context2.DocumentAndGroupTables.DeleteOnSubmit(dgtemp); context2.SubmitChanges(); gtemp = context.GroupTables.Single(x => x.group_id == gId); gtemp.total_document--; context.SubmitChanges(); }
public void documentAndGroupTableInsert(string dId, string gId, string docRight) { DocumentAndGroupTable ob = new DocumentAndGroupTable(); ob.group_id = gId; ob.doc_id = dId; ob.doc_right = docRight; //LinqToSqlDataContext context = new LinqToSqlDataContext(); context2.DocumentAndGroupTables.InsertOnSubmit(ob); context2.SubmitChanges(); }
public void deleteFromDocumentAndGroupTableByDocId(string docId) { dgtemp = context2.DocumentAndGroupTables.First(x => x.doc_id == docId); string gId = dgtemp.group_id; context2.DocumentAndGroupTables.DeleteOnSubmit(dgtemp); context2.SubmitChanges(); gtemp = context.GroupTables.Single(x => x.group_id == gId); gtemp.total_document = gtemp.total_document - 1; context.SubmitChanges(); }
public string documentAndGroupTableSelect(string gId) { try { // LinqToSqlDataContext context = new LinqToSqlDataContext(); dgtemp = context2.DocumentAndGroupTables.First(x => x.group_id == gId && x.doc_group_id > docgroupid); docgroupid = dgtemp.doc_group_id; return(dgtemp.doc_id); } catch (Exception) { return("You Are Not Connected To Any Group"); } }
partial void DeleteDocumentAndGroupTable(DocumentAndGroupTable instance);
partial void UpdateDocumentAndGroupTable(DocumentAndGroupTable instance);
partial void InsertDocumentAndGroupTable(DocumentAndGroupTable instance);
public int LastRowDocumentAndGroupTable() { dgtemp = context2.DocumentAndGroupTables.AsEnumerable().Last(); return(dgtemp.doc_group_id); }
public int firstRowDocumentAndGroupTable() { dgtemp = context2.DocumentAndGroupTables.First(); return(dgtemp.doc_group_id); }
public void deleteFromdocumentAndGroupTable(string groupId) { dgtemp = context2.DocumentAndGroupTables.FirstOrDefault(x => x.group_id == groupId); context2.DocumentAndGroupTables.DeleteOnSubmit(dgtemp); context2.SubmitChanges(); }