internal static void Start(bool isStartUp)
{
LogFileHelper.logList = new ArrayList();
DateTime SyncDate = DateTime.Now;
using (SqlConnection Connection = SQLHelper.GetConnection())
{
Console.WriteLine(string.Format("[{0}] : Start Sync MOF Sync Data..", DateTime.Now.ToString()));
LogFileHelper.logList.Add(string.Format("[{0}] : Start Sync MOF Sync Data...", DateTime.Now.ToString()));
try
{
//READ FROM SPBigFIle:
string SyncedDate = "";
if (!isStartUp)
{
wizardData = SelectACApprovedAccountList(); Console.WriteLine(string.Format("[{0}] : successful retrieved data from spbig file", DateTime.Now.ToString()));
LogFileHelper.logList.Add(string.Format("[{0}] : successful retrieved data from spbig file", DateTime.Now.ToString()));
}
else
{
//READ FROM EXCEL FILE:
string ExcelFileName = getLatestExcelFile();
wizardData = ExcelToDT.exceldata(ExcelFileName); Console.WriteLine(string.Format("[{0}] : successful retrieved MSC4Startup data from excel file", DateTime.Now.ToString()));
LogFileHelper.logList.Add(string.Format("[{0}] : successful retrieved MSC4Startup data from excel file", DateTime.Now.ToString()));
}
if (wizardData.Rows.Count > 0)
{
foreach (DataRow row in wizardData.Rows)
{
ArrayList MSCDataList = new ArrayList();
//No1. FileID
string FileID = row["FileID"].ToString();
MSCDataList.Add(FileID);
int Tier = 0;
if (FileID.Contains("ST"))
{
Tier = 4;
}
else
{
Tier = getTier(FileID);
}
//No2. Tier
MSCDataList.Add(Tier);
//No.3 Submit TYpe
string SubmitType = row["SubmitType"].ToString();
MSCDataList.Add(SubmitType);
//No. 4 CompName
string CompanyName = row["CompanyName"].ToString();
MSCDataList.Add(CompanyName);
//No.5 ROCNumber
string ROCNumber = row["ROCNumber"].ToString();
MSCDataList.Add(ROCNumber);
//No.6 Operational Status
string OperationalStatus = "";
if (row["OperationalStatus"].ToString().ToUpper().Contains("ACTIVE"))
{
OperationalStatus = "1";
}
else
{
OperationalStatus = "0";
}
MSCDataList.Add(OperationalStatus);
//No.7 Core Activities
string CoreActivities = row["CoreActivities"].ToString();
MSCDataList.Add(CoreActivities);
//No.8 URL
string URL = row["URL"].ToString();
MSCDataList.Add(URL);
//No.9 DateofIncorporation
string DateofIncorporation = row["ROCDate"].ToString();
MSCDataList.Add(DateofIncorporation);
//No.10 YearOfApproval
string YearOfApproval = row["Year"].ToString();
MSCDataList.Add(YearOfApproval);
//No.11 ApprovalLetterdate
string ApprovalLetterdate = row["ApprovalLetterdate"].ToString();
MSCDataList.Add(ApprovalLetterdate);
//No.12 ACMeetingDate
string ACMeetingDate = row["DateOfApproval"].ToString();
MSCDataList.Add(ACMeetingDate);
//No.13 FinancialIncentive
string FinancialIncentive = row["FinancialIncentive"].ToString();
MSCDataList.Add(FinancialIncentive);
//No.14 Cluster
string Cluster = row["MainCluster"].ToString();
MSCDataList.Add(Cluster);
//No.15 BusinessPhone
//+60; + 3; + 123086088;
string BusinessPhone = row["PhISDCode"].ToString().Replace(";", "") + row["PhCalAreaCode"].ToString().Replace(";", "") + row["PhoneNumber"].ToString().Replace(";", "");
MSCDataList.Add(BusinessPhone);
//No.16 Fax
string Fax = row["FaxISDCode"].ToString().Replace(";", "") + row["FaxCalAreaCode"].ToString().Replace(";", "") + row["Fax"].ToString().Replace(";", "");
MSCDataList.Add(Fax);
//No.17 BA
string BA = row["BusinestAnalyst"].ToString();
MSCDataList.Add(BA);
//No.18 Acc5YearsTax
Decimal?Acc5YearsTax = SyncHelper.ConvertToDecimal(row["CumulativeTaxLoss"].ToString());
MSCDataList.Add(Acc5YearsTax);
//No.19 MSCCertNo
string MSCCertNo = "";
string MSCFileID = "";
string Unfilter = FileID;
if (Unfilter.Contains("ST"))
{
MSCFileID = Unfilter.Replace("ST/3/", "");
}
if (Unfilter.Contains("CS"))
{
MSCFileID = Unfilter.Replace("CS/3/", "");
}
if (Unfilter.Contains("KWD"))
{
MSCFileID = Unfilter.Replace("KWD-4/", "");
}
if (Unfilter.Contains("MSC-INC"))
{
MSCFileID = Unfilter.Replace("MSC-INC/137/", "");
}
MSCCertNo = getMSCCertNoFromWizard(MSCFileID);
MSCDataList.Add(MSCCertNo);
//No.20 SubmitDate
string SubmitDate = getSubmitDatefromWizard(FileID);
MSCDataList.Add(SubmitDate);
Console.WriteLine(string.Format("[{0}] : Done get all paramerters", DateTime.Now.ToString()));
LogFileHelper.logList.Add(string.Format("[{0}] : Done get all paramerters", DateTime.Now.ToString()));
if (MSCDataList.Count > 0)
{
DateTime LastSync = Convert.ToDateTime(getLastSyncedDate());
if (!CheckRecordExist(FileID, SubmitType, LastSync))
{
InsertIntoMOFMaklumatSyarikat(MSCDataList);
Console.WriteLine(string.Format("[{0}] : successful stored in MOF_MaklumatSyarikat", DateTime.Now.ToString()));
LogFileHelper.logList.Add(string.Format("[{0}] : successful stored in MOF_MaklumatSyarikat", DateTime.Now.ToString()));
}
else
{
Console.WriteLine(string.Format("[{0}] : record already stored, skip...", DateTime.Now.ToString()));
LogFileHelper.logList.Add(string.Format("[{0}] : record already stored, skip...", DateTime.Now.ToString()));
}
}
}
}
}
catch (Exception ex)
{
}
}
}
