public Boolean updateStatusCatalogue(statuscatalogue doc) { Boolean status = true; string utString = ""; try { string updateSQL = "update StatusCatalogue set ID = '" + doc.ID + "'," + "Description= '" + doc.Description + "', Status= " + doc.Status + " where RowID= " + doc.Rowid; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "StatusCatalogue", "", 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 <statuscatalogue> getStatusCatalogue() { statuscatalogue stclg; List <statuscatalogue> statcatlog = new List <statuscatalogue>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = " select a.RowID,a.DocumentID, b.DocumentName, a.ID,a.Description, a.CreateUser, " + " a.CreateTime,a.Status from StatusCatalogue a, Document b where a.DocumentID=b.DocumentID" + " order by a.DocumentId,a.ID"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { stclg = new statuscatalogue(); stclg.Rowid = reader.GetInt32(0); stclg.DocumentID = reader.GetString(1); stclg.DocumentName = reader.GetString(2); stclg.ID = reader.GetInt32(3); stclg.Description = reader.GetString(4); stclg.userCreateUser = reader.GetString(5); stclg.userCreateime = reader.GetDateTime(6); stclg.Status = reader.GetInt32(7); statcatlog.Add(stclg); } conn.Close(); } catch (Exception) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(statcatlog); }
public Boolean insertStatusCatalogue(statuscatalogue doc) { Boolean status = true; string utString = ""; try { DateTime cdt = DateTime.Now; string updateSQL = "insert into StatusCatalogue(DocumentID,ID,Description,Status,CreateTime,CreateUser)" + "values (" + "'" + doc.DocumentID + "'," + "'" + doc.ID + "'," + "'" + doc.Description + "'," + "'" + doc.Status + "'," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "StatusCatalogue", "", 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(statuscatalogue doc) { Boolean status = true; try { if (doc.DocumentID.Trim().Length == 0 || doc.DocumentID == null) { return(false); } if (doc.Description.Trim().Length == 0 || doc.Description == null) { return(false); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(status); }