static void Main(string[] args)
{
Factory.CreateObject();
ImportVendorPath = args[0];
string filePath = ImportVendorPath + ImportVendorFile + ".txt";
StreamReader reader;
Console.WriteLine("Opening file Vendor data file.");
try
{
Encoding inputEnc = Encoding.GetEncoding("windows-874");
reader = new StreamReader(filePath, inputEnc);
}
catch (Exception)
{
Console.WriteLine("!!Error!! : Could not find Vendor-Import file path." + filePath);
Console.WriteLine("Program was terminated.");
return;
}
Console.WriteLine("Getting DbVendorService Object.");
IDbVendorTempService vendorTemp = Factory.DbVendorTempService;
Console.WriteLine("Clearing DbVendortemp data...");
vendorTemp.DeleteAll();
string textLine;
//Read file with connectionful/connectionoriented methodlogy.
Console.WriteLine("Importing vendor Data from file to temporary.");
bool firstLine = true;
Int64 count = 0;
while ((textLine = reader.ReadLine()) != null)
{
count++;
if (!firstLine)
{
string[] textFeild = textLine.Split('|');
//Add one by one row to database.
try
{
#region Map data to DTO
DbVendorTemp vendor = new DbVendorTemp();
vendor.Active = true;
vendor.BlockDelete = false;
vendor.BlockPost = false;
vendor.City = textFeild[12].Trim();
vendor.Country = textFeild[14].Trim();
vendor.CreBy = 1;
vendor.CreDate = DateTime.Now.Date;
vendor.PostalCode = textFeild[13].Trim();
vendor.Street = textFeild[6].Trim();
vendor.TaxNo1 = textFeild[28].Trim();
vendor.TaxNo2 = textFeild[29].Trim();
vendor.UpdBy = 1;
vendor.UpdDate = DateTime.Now.Date;
vendor.UpdPgm = "Interface";
vendor.VendorCode = textFeild[0].Trim();
vendor.VendorName1 = textFeild[1].Trim();
vendor.VendorName2 = textFeild[3].Trim();
vendor.VendorTitle = textFeild[2].Trim();
vendor.TaxNo3 = textFeild[30].Trim();
vendor.TaxNo4 = textFeild[31].Trim();
#endregion
//to do Add DTO to database.
//save each row to temp table.
if (vendor.TaxNo3.Length == 13)
{
vendorTemp.Save(vendor);
}
}
catch (Exception ex)
{
//don;t display text for codeoptimiZation.
Console.WriteLine("!!Error!! while fetching data line " + count.ToString() + " : " + ex.ToString());
continue;
}
}
firstLine = false;
}
try
{
vendorTemp.CommitTempToVendor();
}
catch (Exception ex)
{
//don't display text for codeoptimiZation.
//Console.WriteLine("!!Error!! while importing : " + ex.StackTrace);
}
Console.WriteLine("Finished import");
}
public static void CreateObject()
{
DbParameterQuery = (IDbParameterQuery)ObjectManager.GetObject("DbParameterQuery");
DbVendorTempService = (IDbVendorTempService)ObjectManager.GetObject("DbVendorTempService");
}
