public List <documentuc> getDocuments() { documentuc docrec; List <documentuc> DocUC = new List <documentuc>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select a.UserID, a.Status,b.EmployeeID,b.Name from DocumentUC a Inner Join ViewUserEmployeeList b on a.UserID=b.UserID"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { docrec = new documentuc(); docrec.UserID = reader.GetString(0); docrec.Status = reader.GetInt32(1); docrec.empid = reader.GetString(2); docrec.empname = reader.GetString(3); DocUC.Add(docrec); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(DocUC); }
public Boolean insertDocument(documentuc doc) { Boolean status = true; string utString = ""; try { DocumentDB dc = new DocumentDB(); DateTime cdt = DateTime.Now; string updateSQL = "insert into DocumentUC (UserID,Status,CreateTime,CreateUser)" + "values (" + "'" + doc.UserID + "'," + doc.Status + "," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "DocumentUC", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public Boolean updateDocument(documentuc doc) { Boolean status = true; string utString = ""; try { string updateSQL = "update DocumentUC set Status=" + doc.Status + " where UserID='" + doc.UserID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "DocumentUC", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public Boolean validateDocument(documentuc doc) { Boolean status = true; try { if (doc.UserID.Trim().Length == 0 || doc.UserID == null) { return(false); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); return(false); } return(status); }