Notes

private Class1040ScanChecker GetDuplicateItem(int intEngagementID, int intPreProcessing, Class1040ScanChecker.ActivityType enmActivity, bool blnWizardOption)
{
DataSet dsOrg;
DataTable dtOrg;

DataSet dsSrc;
DataTable dtSrc;

Class1040ScanDuplicateData objDuplicateItem;
var objChecker = new Class1040ScanChecker(Class1040ScanChecker.ActivityType.Duplicate);
bool blnMarkDuplicate;
bool blnFieldExists;
var blnDuplicateProcessed = default(bool);

string strInputForm = "";
string strFieldDWPCode = "";

int intEngagementPageID;
int intFaxRowNumber;
int intSourceFaxRowNumber;
int intEngagementFaxFormID;

DataRow[] drOrgRows;
DataRow[] drSrcRows;
string strIsOffShore;

try
{
ServiceLibrary.CommonCode.WriteDBLog("Retreiving Data For Duplicate...", intEngagementID);


DbCommand command = null;
var objDb = ServiceLibrary.DBCommon.SPbinderDB(intEngagementID);
try
{
command = objDb.GetStoredProcCommand("Proc_GetDuplicateData");
ServiceLibrary.DBCommon.SPbinderDB().AddInParameter(command, "@EngagementID", DbType.Int32, intEngagementID);
ServiceLibrary.DBCommon.SPbinderDB().AddInParameter(command, "@PreProcessing", DbType.String, intPreProcessing);
command.CommandTimeout = 0;
dsSrc = objDb.ExecuteDataSet(command);
dsSrc.DataSetName = "DuplicateData";
dsSrc.Tables[0].TableName = "DuplicateData";
dtSrc = dsSrc.Tables["DuplicateData"];
}

finally
{
try
{
if (command.Connection.State == ConnectionState.Open)
{
command.Connection.Close();
}
}
catch (Exception ex)
{
}
finally
{
command = null;
objDb = null;
}
}

objChecker.PWCOrganizerData = GetPWCOrganizerData(intEngagementID);



dsOrg = dsSrc.Copy();
dtOrg = dsOrg.Tables[0];


drOrgRows = dtOrg.Select("FaxFormType = '2' And Identifier = ''", "InputForm");


drSrcRows = dtSrc.Select("FaxFormType = '1' And Identifier = ''", "InputForm");

if (drOrgRows.Length > 0)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectGreater(drOrgRows[0]["DuplicateProcessed"], 0, false)))
{
blnDuplicateProcessed = true;
}
}

if (enmActivity == Class1040ScanChecker.ActivityType.Duplicate | enmActivity == Class1040ScanChecker.ActivityType.NewDuplicate & !blnDuplicateProcessed)
{
for (int intCount = 0, loopTo = drOrgRows.Length - 1; intCount <= loopTo; intCount++)
{
blnMarkDuplicate = false;

strInputForm = Conversions.ToString(ReplaceSP(Conversions.ToString(drOrgRows[intCount]["InputForm"]), "'", "''"));
strFieldDWPCode = Conversions.ToString(drOrgRows[intCount]["FieldDWPCode"]);

if (strInputForm.Length > 0)
{
drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And FieldDWPCode = '", drOrgRows[intCount]["FieldDWPCode"]), "' And Identifier = '' And InputForm = '"), strInputForm), "'")), "InputForm");



blnFieldExists = false;


drSrcRows = dtSrc.Select("FaxFormType = '1' And InputForm = '" + strInputForm + "' And Identifier = ''", "InputForm");


if (drSrcRows.Length > 0)
{
for (int j = 0, loopTo1 = drOrgRows.Length - 1; j <= loopTo1; j++)
{

if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(drOrgRows[j]["FieldType"], "", false)))
{


intEngagementPageID = Conversions.ToInteger(drOrgRows[j]["EngagementPageID"]);
intFaxRowNumber = Conversions.ToInteger(drOrgRows[j]["FaxRowNumber"]);

for (int i = 0, loopTo2 = drSrcRows.Length - 1; i <= loopTo2; i++)
{

drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And FieldDWPCode = '", drSrcRows[i]["FieldDWPCode"]), "' And Identifier = '' And InputForm = '"), ReplaceSP(Conversions.ToString(drSrcRows[i]["InputForm"]), "'", "''")), "' And FaxRowNumber = "), intFaxRowNumber), " And EngagementPageID = "), intEngagementPageID)), "InputForm");
if (drOrgRows.Length > 0)
{
blnFieldExists = true;
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectNotEqual(drOrgRows[0]["FFValue"], "", false)))
{
drOrgRows[0]["DuplicateFieldID"] = drSrcRows[i]["EngagementFaxTaxFormFieldID"];
if (IsEqualValue(Conversions.ToString(drSrcRows[i]["FFValue"]), Conversions.ToString(drOrgRows[0]["FFValue"]), Conversions.ToInteger(drSrcRows[i]["DataType"])))
{
drOrgRows[0]["FieldType"] = "D";
}
else
{
drOrgRows[0]["FieldType"] = "C";
}
}
}
}
}


drOrgRows = dtOrg.Select("FaxFormType = '2' And Identifier = '' And FieldDWPCode = '" + strFieldDWPCode + "' And InputForm = '" + strInputForm + "'", "InputForm");
}

}
drOrgRows = dtOrg.Select("FaxFormType = '2' And Identifier = ''", "InputForm");



if (!blnFieldExists)
{

drOrgRows = dtOrg.Select("FaxFormType = '2' And FieldType = '' And Identifier = '' And InputForm = '" + strInputForm + "'", "InputForm");

if (drOrgRows.Length <= 0)
{

drSrcRows = dtSrc.Select("FaxFormType = '1' And InputForm = '" + strInputForm + "' And Identifier = 'P'", "InputForm");
for (int i = 0, loopTo3 = drSrcRows.Length - 1; i <= loopTo3; i++)
{

drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And FieldDWPCode = '", drSrcRows[i]["FieldDWPCode"]), "' And InputForm = '"), ReplaceSP(Conversions.ToString(drSrcRows[i]["InputForm"]), "'", "''")), "'")), "InputForm");
if (drOrgRows.Length > 0)
{
drOrgRows[0]["DuplicateFieldID"] = drSrcRows[i]["EngagementFaxTaxFormFieldID"];
drOrgRows[0]["FieldType"] = "D";
}
}


drSrcRows = dtSrc.Select("FaxFormType = '1' And InputForm = '" + strInputForm + "' And Identifier = 'S'", "InputForm");
for (int i = 0, loopTo4 = drSrcRows.Length - 1; i <= loopTo4; i++)
{

drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And FieldDWPCode = '", drSrcRows[i]["FieldDWPCode"]), "' And InputForm = '"), ReplaceSP(Conversions.ToString(drSrcRows[i]["InputForm"]), "'", "''")), "'")), "InputForm");
if (drOrgRows.Length > 0)
{
drOrgRows[0]["DuplicateFieldID"] = drSrcRows[i]["EngagementFaxTaxFormFieldID"];
drOrgRows[0]["FieldType"] = "D";
}
}
}


drOrgRows = dtOrg.Select("FaxFormType = '2' And Identifier = '' And FieldType = '' And FieldDWPCode = '" + strFieldDWPCode + "'", "InputForm");
}


drOrgRows = dtOrg.Select("FaxFormType = '2' And Identifier = ''", "InputForm");

drSrcRows = dtSrc.Select("FaxFormType = '1' And Identifier = ''", "InputForm");
}
}

for (int intCount = 0, loopTo5 = drSrcRows.Length - 1; intCount <= loopTo5; intCount++)
{
blnMarkDuplicate = false;


drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And FieldDWPCode = '", drSrcRows[intCount]["FieldDWPCode"]), "' And Identifier = '' And DataType = 1")), "InputForm");

for (int j = 0, loopTo6 = drOrgRows.Length - 1; j <= loopTo6; j++)
{
if (Conversions.ToBoolean(Operators.AndObject(Operators.ConditionalCompareObjectNotEqual(UCase(drOrgRows[j]["InputForm"]), UCase(drSrcRows[intCount]["InputForm"]), false), Operators.ConditionalCompareObjectEqual(drOrgRows[j]["FieldType"], "", false))))
{
if (IsEqualValue(Conversions.ToString(drOrgRows[j]["FFValue"]), Conversions.ToString(drSrcRows[intCount]["FFValue"]), Conversions.ToInteger(drOrgRows[j]["DataType"])))
{
blnMarkDuplicate = false;

intEngagementFaxFormID = Conversions.ToInteger(drSrcRows[intCount]["EngagementFaxFormID"]);

intEngagementPageID = Conversions.ToInteger(drOrgRows[j]["EngagementPageID"]);
intFaxRowNumber = Conversions.ToInteger(drOrgRows[j]["FaxRowNumber"]);
intSourceFaxRowNumber = Conversions.ToInteger(drSrcRows[intCount]["FaxRowNumber"]);


drOrgRows = dtOrg.Select("FaxFormType = '2' And FieldType = '' And FaxRowNumber = " + intFaxRowNumber + " And EngagementPageID = " + intEngagementPageID + " And DataType = 1 And Identifier = ''", "InputForm");

for (int i = 0, loopTo7 = drOrgRows.Length - 1; i <= loopTo7; i++)
{


drSrcRows = dtSrc.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '1' And Identifier = '' And FieldDWPCode = '", drOrgRows[i]["FieldDWPCode"]), "' And EngagementFaxFormID = "), intEngagementFaxFormID), " And DataType = 1")), "InputForm");

blnMarkDuplicate = false;
for (int m = 0, loopTo8 = drSrcRows.Length - 1; m <= loopTo8; m++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectNotEqual(drSrcRows[m]["FFValue"], "", false)))
{
if (IsEqualValue(Conversions.ToString(drOrgRows[i]["FFValue"]), Conversions.ToString(drSrcRows[m]["FFValue"]), Conversions.ToInteger(drOrgRows[i]["DataType"])))
{
blnMarkDuplicate = true;
}
}
}
if (!blnMarkDuplicate)
{
break;
}
}


drSrcRows = dtSrc.Select("FaxFormType = '1' And Identifier = ''", "InputForm");

if (blnMarkDuplicate)
{

drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And Identifier = '' And FieldDWPCode = '", drSrcRows[intCount]["FieldDWPCode"]), "' And DataType = 1")), "InputForm");

if (drOrgRows.Length > 0)
{
if (enmActivity == Class1040ScanChecker.ActivityType.Duplicate)
{
objDuplicateItem = new Class1040ScanDuplicateData(Conversions.ToInteger(drSrcRows[intCount]["EngagementID"]), Conversions.ToInteger(drSrcRows[intCount]["EngagementFaxTaxFormFieldID"]), Conversions.ToInteger(drOrgRows[j]["EngagementFaxTaxFormFieldID"]), Conversions.ToString(drSrcRows[intCount]["FaxFormShortName"]), Conversions.ToString(drSrcRows[intCount]["InputForm"]), Conversions.ToInteger(drSrcRows[intCount]["EngagementFaxFormID"]), Conversions.ToString(drOrgRows[j]["FaxFormShortName"]), Conversions.ToString(drOrgRows[j]["InputForm"]), Conversions.ToInteger(drOrgRows[j]["EngagementFaxFormID"]), Conversions.ToInteger(drSrcRows[intCount]["EngagementPageID"]), Conversions.ToString(drSrcRows[intCount]["FileName"]), Conversions.ToInteger(drOrgRows[j]["EngagementPageID"]), Conversions.ToString(drOrgRows[j]["FileName"]), Conversions.ToString(drSrcRows[intCount]["FaxFieldName"]), Conversions.ToString(drSrcRows[intCount]["FFValue"]), Conversions.ToString(drOrgRows[j]["FaxFieldName"]), Conversions.ToString(drOrgRows[j]["FFValue"]), false, Conversions.ToInteger(drOrgRows[j]["VirtualRotation"]), Conversions.ToInteger(drSrcRows[intCount]["VirtualRotation"]), Conversions.ToInteger(drOrgRows[j]["ClientPageDPI"]), Conversions.ToInteger(drSrcRows[intCount]["ClientPageDPI"]), Conversions.ToString(Interaction.IIf(drOrgRows[j]["FileType"].ToString().ToUpper() == "PDF", "png", drOrgRows[j]["FileType"])), Conversions.ToString(drSrcRows[intCount]["FileType"]), Conversions.ToSingle(drSrcRows[intCount]["SkewAngle"]), Conversions.ToSingle(drOrgRows[j]["SkewAngle"]));
objChecker.AddDuplicateItem(objDuplicateItem);
objDuplicateItem = null;
}

drOrgRows[j]["DuplicateFieldID"] = drSrcRows[intCount]["EngagementFaxTaxFormFieldID"];
drOrgRows[j]["DupFieldType"] = "D";
}
}
}
}


drOrgRows = dtOrg.Select(Conversions.ToString(Operators.ConcatenateObject(Operators.ConcatenateObject("FaxFormType = '2' And FieldType = '' And Identifier = '' And FieldDWPCode = '", drSrcRows[intCount]["FieldDWPCode"]), "' And DataType = 1")), "InputForm");
}
}


drOrgRows = dtOrg.Select("FaxFormType = '2'", "InputForm");


for (int i = 0, loopTo9 = drOrgRows.Length - 1; i <= loopTo9; i++)
{
if (Strings.Len(drOrgRows[i]["FieldType"]) > 0)
{
UpdateDuplicateField(Conversions.ToInteger(drOrgRows[i]["EngagementFaxTaxFormFieldID"]), Conversions.ToString(drOrgRows[i]["FieldType"]), Conversions.ToInteger(drOrgRows[i]["DuplicateFieldID"]), 2, intEngagementID);
}
if (enmActivity == Class1040ScanChecker.ActivityType.NewDuplicate)
{
if (Strings.Len(drOrgRows[i]["DupFieldType"]) > 0)
{
UpdateProbableDuplicateField(Conversions.ToInteger(drOrgRows[i]["EngagementFaxTaxFormFieldID"]), Conversions.ToString(drOrgRows[i]["DupFieldType"]), Conversions.ToInteger(drOrgRows[i]["DuplicateFieldID"]), intEngagementID);
}
}
}

if (drOrgRows.Length > 0)
{
if (dtOrg.Columns.Contains("EngagementFaxTaxFormFieldID"))
{
UpdateDuplicateField(Conversions.ToInteger(drOrgRows[0]["EngagementFaxTaxFormFieldID"]), "", 1, 2, intEngagementID, 1);
}
}
}

if (blnWizardOption == true)
{
if (enmActivity == Class1040ScanChecker.ActivityType.NewDuplicate)
{
objChecker.DuplicateDataSet = GetDuplicateData(intEngagementID);
}

if (enmActivity == Class1040ScanChecker.ActivityType.NewDuplicate)
{
if (!(objChecker.DuplicateDataSet.Tables[0].Rows.Count > 0 & objChecker.DuplicateDataSet.Tables[1].Rows.Count > 0 & objChecker.DuplicateDataSet.Tables[2].Rows.Count > 0))
{
UpdateDuplicateCompleted(intEngagementID);
ServiceLibrary.CommonCode.WriteDBLog("Duplicate Wizard Not Open...", intEngagementID);
}
}
else if (objChecker.GetCollection().Count <= 0)
{
UpdateDuplicateCompleted(intEngagementID);
ServiceLibrary.CommonCode.WriteDBLog("Duplicate Wizard Not Open...", intEngagementID);
}


if (enmActivity == Class1040ScanChecker.ActivityType.NewDuplicate)
{
objChecker.selectedType = Class1040ScanChecker.ActivityType.NewDuplicate;
}
}
else
{

UpdateDuplicateCompleted(intEngagementID);

ServiceLibrary.CommonCode.WriteDBLog("Duplicate Wizard is skipped by user...", intEngagementID);
}
}

catch (Exception ex)
{
int logId = LogWriter.LogEntry("ReviewWizardService", ex.Message + "::" + ex.StackTrace, 0, (int)TraceEventType.Error, intEngagementID);
throw new ServiceLibrary.ServiceLibraryException(logId, CommonConstant.GenricErrorMsg, ex);
}

dtOrg = null;
dsOrg = null;

dtSrc = null;
dsSrc = null;

return objChecker;
}