internal static void AddItemTable(DataForm dataForm, WorkflowDataFields fields)
{
AddItemTable(dataForm.ItemTable, dataForm,fields );
}
internal static void AddItemTable(DataTable itemTable, DataForm dataForm, WorkflowDataFields fields)
{
DataTable dt = new DataTable();
dt.Columns.Add("ExpenseType");
dt.Columns.Add("ItemAmount");
dt.Columns.Add("CostCenter");
dt.Columns.Add("GLAccount");
dt.Columns.Add("PRWorkFlowNumber");
dt.Columns.Add("SubPRNo");
dt.Columns.Add("Title");
dt.Columns.Add("FANO");
dt.Columns.Add("ItemInstallmentAmount");
foreach (DataRow dr in itemTable.Rows)
{
DataRow newdr = dt.Rows.Add();
newdr["ExpenseType"] = dr["ExpenseType"].ToString();
newdr["GLAccount"] = dr["GLAccount"].ToString();
newdr["CostCenter"] = dr["CostCenter"].ToString();
newdr["ItemAmount"] = dr["ItemAmount"].ToString();
newdr["PRWorkFlowNumber"] = fields["Title"].ToString();
newdr["SubPRNo"] = fields["SubPRNo"].ToString();
newdr["Title"] = fields["SubPRNo"].ToString();
newdr["FANO"] = dr["FANO"].AsString();
newdr["ItemInstallmentAmount"] = dr["ItemAmount"].ToString();
}
dataForm.ItemTable = dt;
}
internal static void SaveSAPItemsDetails(DataForm dataForm)
{
BatchInsertSAPItems("PaymentRequestItemDetails", dataForm.ItemTable);
}
