//Deleting from UserAndDocumentTable
public void deleteFromUserAndDocumentTable(string userId, string docId)
{
//LinqToSqlDataContext context = new LinqToSqlDataContext();
udtemp = context2.UserAndDocumentTables.FirstOrDefault(x => x.user_id == userId && x.doc_id == docId);
context2.UserAndDocumentTables.DeleteOnSubmit(udtemp);
context2.SubmitChanges();
}
public string deleteFromUserAndDocumentTableByDocId(string docId)
{
udtemp = context2.UserAndDocumentTables.First(x => x.doc_id == docId);
string userId = udtemp.user_id;
context2.UserAndDocumentTables.DeleteOnSubmit(udtemp);
context2.SubmitChanges();
return(userId);
}
public string userAndDocumentTableSelectByListBoxIndex(string tempuser, int index)
{
for (int i = 0; i <= index; i++)
{
udtemp = context2.UserAndDocumentTables.FirstOrDefault(x => x.user_id == tempuser && x.user_doc_id > userdocidforsharelist);
userdocidforsharelist = udtemp.user_doc_id;
dtemp = context.DocumentTables.SingleOrDefault(x => x.doc_id == udtemp.doc_id);
}
return(dtemp.doc_id);
}
//Insert into UserAndDocumentTable
public void userAndDocumentTableInsert(string userId, string docId, string docRight)
{
UserAndDocumentTable ob = new UserAndDocumentTable();
ob.doc_id = docId;
ob.user_id = userId;
ob.doc_right = docRight;
//LinqToSqlDataContext context = new LinqToSqlDataContext();
context2.UserAndDocumentTables.InsertOnSubmit(ob);
context2.SubmitChanges();
}
//Enter into userAndDocumentTable
public string userAndDocumentTableSelect(string tempuser)
{
try
{
//LinqToSqlDataContext context = new LinqToSqlDataContext();
udtemp = context2.UserAndDocumentTables.FirstOrDefault(x => x.user_id == tempuser && x.user_doc_id > userdocid);
userdocid = udtemp.user_doc_id;
return(udtemp.doc_id);
}
catch (Exception)
{
string message = "Not Found";
return(message);
}
}
public string userAndDocumentTableSelectAndReturnDocName(string tempuser)
{
try
{
udtemp = context2.UserAndDocumentTables.FirstOrDefault(x => x.user_id == tempuser && x.user_doc_id > userdocidforsharelist);
userdocidforsharelist = udtemp.user_doc_id;
dtemp = context.DocumentTables.SingleOrDefault(x => x.doc_id == udtemp.doc_id);
return(dtemp.doc_name);
}
catch (Exception)
{
string message = "Not Found";
return(message);
}
}
public string documentTableSelectByDocName(string docName, string user)
{
utemp = context.UserTables.SingleOrDefault(x => x.user_id == user);
int noofdoc = utemp.no_of_document;
userdocid = 0;
for (int i = 0; i < noofdoc; i++)
{
udtemp = context2.UserAndDocumentTables.First(x => x.user_id == user && x.user_doc_id > userdocid);
userdocid = udtemp.user_doc_id;
string docId = udtemp.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);
}
partial void DeleteUserAndDocumentTable(UserAndDocumentTable instance);
partial void UpdateUserAndDocumentTable(UserAndDocumentTable instance);
partial void InsertUserAndDocumentTable(UserAndDocumentTable instance);
public int LastRowUserAndDocumentTable()
{
udtemp = context2.UserAndDocumentTables.AsEnumerable().Last();
return(udtemp.user_doc_id);
}
public int firstRowUserAndDocumentTable()
{
udtemp = context2.UserAndDocumentTables.First();
return(udtemp.user_doc_id);
}
public string docRight(string userId, string docId)
{
//LinqToSqlDataContext context = new LinqToSqlDataContext();
udtemp = context2.UserAndDocumentTables.SingleOrDefault(x => x.user_id == userId && x.doc_id == docId);
return(udtemp.doc_right);
}