public List <SRM> getSRMGTNOUTdata() { SRM srm; List <SRM> SRMlist = new List <SRM>(); try { string query = "SELECT StockItemID,StockReferenceNo,DocumentID,DOCUMENTNO ,DOCUMENTDATE ,QUANTITYRECEIPT,QUANTITYISSUE ,STOREID ,FYID FROM ViewSRMGTNOUT"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { srm = new SRM(); srm.StockItmID = reader.GetString(0); srm.StockReferenceNo = reader.GetInt32(1); srm.DOCUMENTID = reader.GetString(2); srm.DOCUMENTNO2 = reader.GetInt32(3); srm.DOCUMENTDATE = reader.GetDateTime(4); srm.GTNIN = reader.GetDouble(5); srm.QUANTITYISSUE = reader.GetDouble(6); srm.STOREID = reader.GetString(7); srm.FYID = reader.GetString(8); SRMlist.Add(srm); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying SMRN Data"); } return(SRMlist); }
public List <SRM> getSRMdata() { SRM srm; List <SRM> SRMlist = new List <SRM>(); try { string query = "SELECT a.StockItemID, a.RowID AS StockReferenceNo, a.InwardDocumentID AS DOCUMENTID, " + "a.InwardDocumentNo AS DOCUMENTNO, a.InwardDocumentDate AS DOCUMENTDATE, a.InwardQuantity AS OB," + "cast(0 as float) MRN, cast(0 as float) GTNIN, cast(0 as float) AS INVOICE,cast(0 as float) as GTNOUT, " + "a.StoreLocation AS STOREID,PresentStock,issuequantity, " + "b.Name,a.FYID " + "FROM dbo.Stock AS a, stockitem b, FinancialYear c " + "where StoreLocation = 'NVPSTORE'and a.StockItemID=b.StockItemID and a.FYID=c.FYID and c.IsCurrentFY=1"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { srm = new SRM(); srm.StockItmID = reader.GetString(0); srm.StockReferenceNo = reader.GetInt32(1); srm.DOCUMENTID = reader.GetString(2); srm.DOCUMENTNO = reader.GetString(3); srm.DOCUMENTDATE = reader.GetDateTime(4); srm.OB = reader.GetDouble(5); srm.MRN = reader.GetDouble(6); srm.GTNIN = reader.GetDouble(7); srm.INVOICE = reader.GetDouble(8); srm.GTNOUT = reader.GetDouble(9); srm.STOREID = reader.GetString(10); srm.PresentStock = reader.GetDouble(11); srm.issuequantity = reader.GetDouble(12); srm.Name = reader.GetString(13); srm.FYID = reader.GetString(14); SRMlist.Add(srm); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Stock Data"); } return(SRMlist); }