public List <DocReverse> getDocReverseValues() { DocReverse Docval; List <DocReverse> DocValues = new List <DocReverse>(); try { SqlConnection conn = new SqlConnection(Login.connString); string empLogedin = Login.userLoggedIn; string query = "select distinct a.DocumentID,a.DocumentName,a.TableName from Document a , DocEmpMapping b ,DocumentUC c" + " where a.DocumentID = b.DocumentID and" + " a.IsReversible = 1 and b.SeniorEmployeeID = '" + Login.empLoggedIn + "' or " + "c.UserID = (select distinct UserID from ViewUserEmployeeList a where a.EmployeeID = '" + Login.empLoggedIn + "' )" + "and c.Status = 1 and a.TableName != 'NULL'and a.IsReversible = 1 order by a.DocumentName"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Docval = new DocReverse(); Docval.DocumentID = reader.GetString(0); Docval.DocumentName = reader.GetString(1); Docval.TableName = reader.GetString(2); DocValues.Add(Docval); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(DocValues); }
public Boolean updateDocForReverse(DocReverse du) { Boolean status = true; string utString = ""; try { string updateSQL = "update " + du.TableName + " set DocumentStatus= DocumentStatus-1,ForwardUser ='******',ForwarderList ='" + du.forwarderlist + "' where RowID = " + du.RowID + ""; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", 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 List <DocReverse> getDocumentInfo(string tablename, string documentID) { DocReverse tb; DocumentUnlockDB dbrecord = new DocumentUnlockDB(); List <DocReverse> tbdata = new List <DocReverse>(); try { SqlConnection conn = new SqlConnection(Login.connString); string empLogedin = Login.userLoggedIn; string query = "select DocumentID,TemporaryNo,TemporaryDate,ForwardUser,ForwarderList,RowID from " + tablename + " where DocumentID = '" + documentID + "' and DocumentStatus BETWEEN 2 AND 98 and Status in (0,96) order by TemporaryNo desc, TemporaryDate desc"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tb = new DocReverse(); tb.DocumentID = reader.IsDBNull(0) ? "" : reader.GetString(0); tb.TemporaryNo = reader.GetInt32(1); tb.TemporaryDate = reader.GetDateTime(2); tb.TableName = tablename; tb.ForwardUser = reader.IsDBNull(3) ? "" : reader.GetString(3); tb.forwarderlist = reader.IsDBNull(4) ? "" : reader.GetString(4); tb.RowID = reader.IsDBNull(5) ? 0 : reader.GetInt32(5); tbdata.Add(tb); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(tbdata); }