public DataTable dtTrnasfer(DataTable dtTransferSaleCert)
{
DataTable dtSearTable = new DataTable();
dtSearTable = dtTransferSaleCert;
dtSearTable.TableName = "Search";
DataTable dtTarget = new DataTable();
dtTarget = dtSearchTable(dtTransferSaleCert);
dtTarget.TableName = "Target";
int qty = 0;
string certificate = "";
DataTable dtTrnasfer = opendMFDAO.getTableTransfer();
DataRow drTransfer;
// string SL_NO = "";
ArrayList rowIndex = new ArrayList();
bool flag = false;
//int looper = 0;
for (int loop = 0; loop < dtTarget.Rows.Count; loop++)
{
for (int looper = 0; looper < dtSearTable.Rows.Count; looper++)
{
if (dtTarget.Rows[loop]["SALE_NO"].ToString().ToUpper() == dtSearTable.Rows[looper]["SL_NO"].ToString().ToUpper())
{
if (certificate == "")
{
certificate = dtSearTable.Rows[looper]["CERTIFICATE"].ToString();
}
else
{
certificate = certificate + "," + dtSearTable.Rows[looper]["CERTIFICATE"].ToString();
}
qty = qty + Convert.ToInt32(dtSearTable.Rows[looper]["QTY"].ToString());
rowIndex.Add(looper);
flag = true;
}
}
if (flag)
{
drTransfer = dtTrnasfer.NewRow();
drTransfer["QTY"] = qty;
drTransfer["SL_NO"] = dtTarget.Rows[loop]["SALE_NO"].ToString().ToUpper();
drTransfer["CERTIFICATE"] = certificate.ToString();
dtTrnasfer.Rows.Add(drTransfer);
dtSearTable = opendMFDAO.dtRemoveRow(dtSearTable, rowIndex);
dtSearTable.TableName = "Search";
rowIndex.Clear();
qty = 0;
certificate = "";
flag = false;
}
if (dtSearTable.Rows.Count == 0)
{
break;
}
}
return(dtTrnasfer);
}