public static List <producttesttemplatedetail> getProductTestTempDetail(producttesttemplateheader pttemph) { producttesttemplatedetail pttempd; List <producttesttemplatedetail> PTestDetail = new List <producttesttemplatedetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select RowID,DocumentID,TemplateNo,templateDate,TestDescriptionID,TestDescription,SlNo,ExpectedResult, Remarks " + "from ViewProductTestTemplate " + " where DocumentID='" + pttemph.DocumentID + "'" + " and TemplateNo=" + pttemph.TemplateNo + " and TemplateDate='" + pttemph.TemplateDate.ToString("yyyy-MM-dd") + "'" + " order by SLNo"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pttempd = new producttesttemplatedetail(); pttempd.RowID = reader.GetInt32(0); pttempd.DocumentID = reader.GetString(1); pttempd.TemplateNo = reader.GetInt32(2); pttempd.TemplateDate = reader.GetDateTime(3).Date; pttempd.TestDescriptionID = reader.GetString(4); pttempd.TestDescription = reader.GetString(5); if (!reader.IsDBNull(6)) { pttempd.SlNo = reader.GetInt32(6); } pttempd.ExpectedResult = reader.GetString(7); pttempd.Remark = reader.GetString(8); PTestDetail.Add(pttempd); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying PRoduct Test Tesmplate Details"); } return(PTestDetail); }
public static List <producttesttemplatedetail> getTemplateDetailForReport(string ID, string name, string ModelNo) { producttesttemplatedetail pttempd; List <producttesttemplatedetail> PTestDetail = new List <producttesttemplatedetail>(); try { string query = ""; SqlConnection conn = new SqlConnection(Login.connString); query = "select TestDescriptionID,TestDescription,SlNo,ExpectedResult, Remarks " + "from ViewProductTestTemplate " + " where DocumentID='PRODUCTTESTTEMPLATE'" + " and StockItemID='" + ID + "'" + " and ModelNo='" + ModelNo + "'" + " and StockItemName='" + name + "'" + " order by SLNo"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pttempd = new producttesttemplatedetail(); pttempd.TestDescriptionID = reader.GetString(0); pttempd.TestDescription = reader.GetString(1); if (!reader.IsDBNull(2)) { pttempd.SlNo = reader.GetInt32(2); } pttempd.ExpectedResult = reader.GetString(3); pttempd.Remark = reader.GetString(4); PTestDetail.Add(pttempd); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying PRoduct Test Tesmplate Details"); } return(PTestDetail); }