private TripleValue getDataFromTransTable(int tid)
{
TripleValue resultObject = new TripleValue();
string sqlStr = "SELECT NW,METALTYPE,PCS,PCODE FROM TRANS WHERE TID = " + tid;
OleDbDataReader reader = dbUtils.fetch(sqlStr);
if (reader.HasRows)
{
while (reader.Read())
{
resultObject.weight = reader.GetDouble(0);
resultObject.purity = reader.GetString(1);
resultObject.pcs = reader.GetInt16(2);
resultObject.itemDesc = reader.GetString(3);
}
}
reader.Close();
return(resultObject);
}
private void getSalesLineItem(int svno, DataSet ds)
{
DataTable lineItem = getSalesLineItemTable();
lineItem.TableName = "SaleLineItemTable";
ds.Tables.Add(lineItem);
string sqlQry = "SELECT * FROM SALESBILLDETAIL WHERE SVNO = " + svno;
OleDbDataReader reader = dbUtils.fetch(sqlQry);
string path = string.Empty;
DataRow row;
int i = 0;
if (reader.HasRows)
{
while (reader.Read())
{
row = lineItem.NewRow();
path = Application.StartupPath + "//Data//Images//" + reader.GetInt32(1) + ".jpg"; //photo
if (File.Exists(path))
{
row[2] = path;
}
else
{
row[2] = Application.StartupPath + "//Data//Images//blankImage.jpg"; //photo
}
row[0] = ++i;
row[1] = reader.GetInt32(2);
TripleValue valueObject = getDataFromTransTable(reader.GetInt32(1));
row[3] = valueObject.itemDesc;
row[4] = valueObject.weight;
row[5] = valueObject.purity;
row[6] = reader.GetDouble(3);
Dictionary <string, List <double> > diamondStoneDetail = getDiamondandStoneDetail(reader.GetInt32(1));
if (diamondStoneDetail.ContainsKey("D"))
{
List <double> diamondList = diamondStoneDetail["D"];
row[7] = diamondList[0];
row[8] = diamondList[1];
}
else
{
row[7] = 0;
row[8] = 0;
}
if (diamondStoneDetail.ContainsKey("S"))
{
List <double> stoneList = diamondStoneDetail["S"];
row[9] = stoneList[0];
row[10] = stoneList[1];
}
else
{
row[9] = 0;
row[10] = 0;
}
row[11] = valueObject.pcs;
if (reader.GetDouble(10) > 0)
{
row[12] = reader.GetDouble(7).ToString() + Environment.NewLine + reader.GetDouble(10).ToString();
}
else
{
row[12] = reader.GetDouble(7);
}
row[13] = double.Parse(row[7].ToString()) + double.Parse(row[9].ToString()) + reader.GetDouble(7) + reader.GetDouble(10) + reader.GetDouble(4);
lineItem.Rows.Add(row);
}
}
reader.Close();
}
