public List <productTestDesc> getProductTestDescriptionList() { productTestDesc ptdesc; List <productTestDesc> PTDescList = new List <productTestDesc>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select TestDescriptionID, TestDescription,Status,CreateTime,CreateUser from ProductTestDescription order by TestDescriptionID"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ptdesc = new productTestDesc(); ptdesc.TestDescriptionID = reader.GetString(0); ptdesc.TestDescription = reader.GetString(1); ptdesc.Status = reader.GetInt32(2); ptdesc.CreateTime = reader.GetDateTime(3); ptdesc.CreateUser = reader.GetString(4); PTDescList.Add(ptdesc); } conn.Close(); } catch (Exception ex) { } return(PTDescList); }
public Boolean insertProductTestDescription(productTestDesc ptdesc) { Boolean status = true; string utString = ""; try { DateTime cdt = DateTime.Now; string updateSQL = "insert into ProductTestDescription (TestDescriptionID,TestDescription,Status,CreateTime,CreateUser)" + "values (" + "'" + ptdesc.TestDescriptionID + "'," + "'" + ptdesc.TestDescription + "'," + ptdesc.Status + "," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductTestDescription", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
//public string getDocumentStatusString(int userStatus) //{ // string documentStatusString = "Unknown"; // try // { // for (int i = 0; i < Document.documentStatusValues.GetLength(0); i++) // { // if (Convert.ToInt32(Document.documentStatusValues[i, 0]) == userStatus) // { // documentStatusString = Document.documentStatusValues[i, 1]; // break; // } // } // } // catch (Exception) // { // documentStatusString = "Unknown"; // } // return documentStatusString; //} //public int getDocumentStatusCode(string documentStatusString) //{ // int documentStatusCode = 0; // try // { // for (int i = 0; i < Document.documentStatusValues.GetLength(0); i++) // { // if (Document.documentStatusValues[i, 1].Equals(documentStatusString)) // { // documentStatusCode = Convert.ToInt32(Document.documentStatusValues[i, 0]); // break; // } // } // } // catch (Exception) // { // documentStatusCode = 0; // } // return documentStatusCode; //} public Boolean updateProductTestDescription(productTestDesc ptdesc) { Boolean status = true; string utString = ""; try { string updateSQL = "update ProductTestDescription set Status=" + ptdesc.Status + "," + "TestDescription='" + ptdesc.TestDescription + "'" + " where TestDescriptionID='" + ptdesc.TestDescriptionID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "ProductTestDescription", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
public Boolean validateProductTestDescription(productTestDesc ptdesc) { Boolean status = true; try { if (ptdesc.TestDescriptionID.Trim().Length == 0 || ptdesc.TestDescriptionID == null) { return(false); } if (ptdesc.TestDescription.Trim().Length == 0 || ptdesc.TestDescription == null) { return(false); } } catch (Exception ex) { } return(status); }