public Boolean FinalizeProductTestTemp(producttesttemplateheader pttemp) { Boolean status = true; string utString = ""; try { string updateSQL = "update ProductTestTemplateHeader set Status = 1" + " where TemplateNo=" + pttemp.TemplateNo + " and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "ProductTestTemplateHeader", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
//public Boolean updateProductTestTempHeader(producttesttemplateheader pttemp, producttesttemplateheader prevpttemp) //{ // Boolean status = true; // string utString = ""; // try // { // string updateSQL = "update ProductTestTemplateHeader set StockItemId='" + pttemp.StockItemID + "'" + // ", ModelNo='" + pttemp.ModelNo + "'"+ // " where DocumentID='" + prevpttemp.DocumentID + // "' and TemplateNo=" + prevpttemp.TemplateNo + // " and TemplateDate='" + prevpttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; // utString = utString + updateSQL + Main.QueryDelimiter; // utString = utString + // ActivityLogDB.PrepareActivityLogQquerString("update", "ProductTestTemplateHeader", "", updateSQL) + // Main.QueryDelimiter; // if (!UpdateTable.UT(utString)) // { // status = false; // } // } // catch (Exception) // { // status = false; // } // return status; //} //public Boolean insertProductTestTempHeader(producttesttemplateheader pttemp) //{ // Boolean status = true; // string utString = ""; // try // { // string updateSQL = "insert into ProductTestTemplateHeader " + // " (DocumentID,TemplateNo,TemplateDate,StockItemID,ModelNo," + // "CreateUser,CreateTime)" + // "values (" + // "'" + pttemp.DocumentID + "'," + // pttemp.TemplateNo + "," + // "'" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'," + // "'" + pttemp.StockItemID + "'," + // "'" + pttemp.ModelNo + "'," + // "'" + Login.userLoggedIn + "'," + // "GETDATE())"; // //"'" + pheader.ForwardUser + "'," + // //"'" + pheader.ApproveUser + "'," + // utString = utString + updateSQL + Main.QueryDelimiter; // utString = utString + // ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductTestTemplateHeader", "", updateSQL) + // Main.QueryDelimiter; // if (!UpdateTable.UT(utString)) // { // status = false; // } // } // catch (Exception) // { // status = false; // } // return status; //} //public Boolean UpdateProductTestTempDetail(List<producttesttemplatedetail> PTTestDetail, producttesttemplateheader pttemp) //{ // Boolean status = true; // string utString = ""; // try // { // string updateSQL = "Delete from ProductTestTemplateDetail where DocumentID='" + pttemp.DocumentID + "'" + // " and TemplateNo=" + pttemp.TemplateNo + // " and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; // utString = utString + updateSQL + Main.QueryDelimiter; // utString = utString + // ActivityLogDB.PrepareActivityLogQquerString("delete", "ProductTestTemplateDetail", "", updateSQL) + // Main.QueryDelimiter; // foreach (producttesttemplatedetail PTTemp in PTTestDetail) // { // updateSQL = "insert into ProductTestTemplateDetail " + // "(DocumentID,TemplateNo,TemplateDate,TestDescriptionID,SlNo,ExpectedResult,Remarks) " + // "values ('" + PTTemp.DocumentID + "'," + // PTTemp.TemplateNo + "," + // "'" + PTTemp.TemplateDate.ToString("yyyy-MM-dd") + "'," + // "'" + PTTemp.TestDescriptionID + "'," + // PTTemp.SlNo + "," + // "'" + PTTemp.ExpectedResult + "'," + // "'" + PTTemp.Remark + "')"; // utString = utString + updateSQL + Main.QueryDelimiter; // utString = utString + // ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductTestTemplateDetail", "", updateSQL) + // Main.QueryDelimiter; // } // if (!UpdateTable.UT(utString)) // { // status = false; // } // } // catch (Exception ex) // { // status = false; // } // return status; //} //public Boolean deleteProductTestTempDetail(producttesttemplateheader pttemp) //{ // Boolean status = true; // string utString = ""; // try // { // string updateSQL = "delete ProductTestTemplateDetail " + // " where DocumentID='" + pttemp.DocumentID + "'" + // " and TemplateNo=" + pttemp.TemplateNo + // " and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; // utString = utString + updateSQL + Main.QueryDelimiter; // utString = utString + // ActivityLogDB.PrepareActivityLogQquerString("delete", "ProductTestTemplateDetail", "", updateSQL) + // Main.QueryDelimiter; // if (!UpdateTable.UT(utString)) // { // status = false; // } // } // catch (Exception) // { // status = false; // } // return status; //} public Boolean validateProductTestTemp(producttesttemplateheader pttemp) { Boolean status = true; try { if (pttemp.DocumentID.Trim().Length == 0 || pttemp.DocumentID == null) { return(false); } if (pttemp.StockItemID.Trim().Length == 0 || pttemp.StockItemID == null) { return(false); } if (pttemp.ModelNo.Trim().Length == 0 || pttemp.ModelNo == null) { return(false); } if (pttemp.ModelName.Trim().Length == 0 || pttemp.ModelName == null) { return(false); } } catch (Exception ex) { } return(status); }
public static List <producttesttemplateheader> getFilteredProdTemp(int opt) { producttesttemplateheader PTTemp; List <producttesttemplateheader> PTTempList = new List <producttesttemplateheader>(); try { string query1 = "select distinct DocumentID,TemplateNo,TemplateDate,StockItemID, " + " StockitemName,ModelNo,ModelName," + "Status, Createuser,CreatorName, CreateTime " + "from ViewProductTestTemplate where (Createuser='******' and Status = 0 )"; string query2 = "select distinct DocumentID,TemplateNo,TemplateDate,StockItemID, " + " StockitemName,ModelNo,ModelName," + "Status, Createuser,CreatorName, CreateTime " + "from ViewProductTestTemplate where Status = 1"; SqlConnection conn = new SqlConnection(Login.connString); string query = ""; switch (opt) { case 1: query = query1; break; case 2: query = query2; break; default: query = ""; break; } SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { PTTemp = new producttesttemplateheader(); PTTemp.DocumentID = reader.GetString(0); PTTemp.TemplateNo = reader.GetInt32(1); PTTemp.TemplateDate = reader.GetDateTime(2); PTTemp.StockItemID = reader.GetString(3); PTTemp.StockItemName = reader.GetString(4); PTTemp.ModelNo = reader.IsDBNull(5)?"NA":reader.GetString(5); PTTemp.ModelName = reader.IsDBNull(6) ? "NA" : reader.GetString(6); PTTemp.Status = reader.GetInt32(7); PTTemp.CreateUser = reader.GetString(8); PTTemp.CreatorName = reader.GetString(9); PTTemp.CreateTime = reader.GetDateTime(10); PTTempList.Add(PTTemp); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Serviced List Details"); } return(PTTempList); }
public Boolean updatePTHeaderAndDetail(producttesttemplateheader pttemp, List <producttesttemplatedetail> PTTestDetail) { Boolean status = true; string utString = ""; try { string updateSQL = "update ProductTestTemplateHeader set StockItemId='" + pttemp.StockItemID + "'" + ", ModelNo='" + pttemp.ModelNo + "'" + " where DocumentID='" + pttemp.DocumentID + "' and TemplateNo=" + pttemp.TemplateNo + " and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "ProductTestTemplateHeader", "", updateSQL) + Main.QueryDelimiter; updateSQL = "Delete from ProductTestTemplateDetail where DocumentID='" + pttemp.DocumentID + "'" + " and TemplateNo=" + pttemp.TemplateNo + " and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("delete", "ProductTestTemplateDetail", "", updateSQL) + Main.QueryDelimiter; foreach (producttesttemplatedetail PTTemp in PTTestDetail) { updateSQL = "insert into ProductTestTemplateDetail " + "(DocumentID,TemplateNo,TemplateDate,TestDescriptionID,SlNo,ExpectedResult,Remarks) " + "values ('" + PTTemp.DocumentID + "'," + PTTemp.TemplateNo + "," + "'" + PTTemp.TemplateDate.ToString("yyyy-MM-dd") + "'," + "'" + PTTemp.TestDescriptionID + "'," + PTTemp.SlNo + "," + "'" + PTTemp.ExpectedResult + "'," + "'" + PTTemp.Remark + "')"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductTestTemplateDetail", "", updateSQL) + Main.QueryDelimiter; } if (!UpdateTable.UT(utString)) { status = false; MessageBox.Show("Transaction Exception Occured"); } } catch (Exception ex) { status = false; } return(status); }
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 Boolean checkProductAvailability(string StockItemID, string ModelNo) { Boolean status = true; producttesttemplateheader PTTemp; List <producttesttemplateheader> PTTempList = new List <producttesttemplateheader>(); try { string query = "select StockItemID,ModelNo " + "from ProductTestTemplateHeader"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { PTTemp = new producttesttemplateheader(); PTTemp.StockItemID = reader.GetString(0); PTTemp.ModelNo = reader.IsDBNull(1)?"NA":reader.GetString(1); PTTempList.Add(PTTemp); } conn.Close(); foreach (producttesttemplateheader PTheader in PTTempList) { if (PTheader.StockItemID.Equals(StockItemID) && PTheader.ModelNo.Equals(ModelNo)) { MessageBox.Show("Product already Available. select another one."); status = false; } } } catch (Exception ex) { status = false; MessageBox.Show("Error querying Details"); } return(status); }
public Boolean InsertPTHeaderAndDetail(producttesttemplateheader pttemp, List <producttesttemplatedetail> PTTestDetail) { Boolean status = true; string utString = ""; string updateSQL = ""; try { pttemp.TemplateNo = DocumentNumberDB.getNumber(pttemp.DocumentID, 1); if (pttemp.TemplateNo <= 0) { MessageBox.Show("Error in Creating New Number"); return(false); } updateSQL = "update DocumentNumber set TempNo =" + pttemp.TemplateNo + " where FYID='" + Main.currentFY + "' and DocumentID='" + pttemp.DocumentID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "DocumentNumber", "", updateSQL) + Main.QueryDelimiter; updateSQL = "insert into ProductTestTemplateHeader " + " (DocumentID,TemplateNo,TemplateDate,StockItemID,ModelNo," + "CreateUser,CreateTime)" + "values (" + "'" + pttemp.DocumentID + "'," + pttemp.TemplateNo + "," + "'" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'," + "'" + pttemp.StockItemID + "'," + "'" + pttemp.ModelNo + "'," + "'" + Login.userLoggedIn + "'," + "GETDATE())"; //"'" + pheader.ForwardUser + "'," + //"'" + pheader.ApproveUser + "'," + utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductTestTemplateHeader", "", updateSQL) + Main.QueryDelimiter; updateSQL = "Delete from ProductTestTemplateDetail where DocumentID='" + pttemp.DocumentID + "'" + " and TemplateNo=" + pttemp.TemplateNo + " and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("delete", "ProductTestTemplateDetail", "", updateSQL) + Main.QueryDelimiter; foreach (producttesttemplatedetail PTTemp in PTTestDetail) { updateSQL = "insert into ProductTestTemplateDetail " + "(DocumentID,TemplateNo,TemplateDate,TestDescriptionID,SlNo,ExpectedResult,Remarks) " + "values ('" + PTTemp.DocumentID + "'," + pttemp.TemplateNo + "," + "'" + PTTemp.TemplateDate.ToString("yyyy-MM-dd") + "'," + "'" + PTTemp.TestDescriptionID + "'," + PTTemp.SlNo + "," + "'" + PTTemp.ExpectedResult + "'," + "'" + PTTemp.Remark + "')"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductTestTemplateDetail", "", updateSQL) + Main.QueryDelimiter; } if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { status = false; MessageBox.Show("Transaction Exception Occured"); } return(status); }