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);
}
