static void Main(string[] args) { dynamic jobject; ImportFileCDO objCDO = new ImportFileCDO(); ImportDataBL objBl = new ImportDataBL(); // Test if input arguments were supplied. if (args.Length < 2) { Console.WriteLine("Please enter import param in below format."); Console.WriteLine("Usage: import <store> <filePath>"); return; } Console.WriteLine($"The input value is StoreName {args[0]} and File Path - {args[1]}"); string storePath = ConfigurationManager.AppSettings["LocalPath"].ToString(); //string FullPath = @"C:\Store\Capteraa\Data.yaml"; string FullPath = storePath + "/" + args[0].ToString() + "/" + args[1].ToString(); objCDO.StoreName = args[0].ToString(); objCDO.SourcePath = FullPath; objCDO.IsActive = true; objCDO.CreatedBy = "Import Tool"; objCDO.CreatedDate = DateTime.Now; Function classobj = new Function(); if (File.Exists(FullPath)) { if (FullPath.ToUpper().Contains(".JSON")) { string data = File.ReadAllText(FullPath); jobject = JObject.Parse(data); List <ImportFileDataCDO> importfilecdo = new List <ImportFileDataCDO>(); importfilecdo = classobj.ConvertObject(jobject, importfilecdo, false); objCDO.importfilecdo = importfilecdo; } else if (FullPath.ToUpper().Contains(".XML")) { string data = File.ReadAllText(FullPath); XmlDocument doc = new XmlDocument(); doc.LoadXml(data); string jsonText = JsonConvert.SerializeXmlNode(doc); jobject = JObject.Parse(jsonText); List <ImportFileDataCDO> importfilecdo = new List <ImportFileDataCDO>(); importfilecdo = classobj.ConvertObject(jobject, importfilecdo, true); objCDO.importfilecdo = importfilecdo; } else if (FullPath.ToUpper().Contains(".YAML")) { List <ImportFileDataCDO> importfilecdo = new List <ImportFileDataCDO>(); string data = File.ReadAllText(FullPath); var r = new StringReader(data); var deserializer = new Deserializer(); dynamic yamlObject = deserializer.Deserialize(r); var serializer = new Newtonsoft.Json.JsonSerializer(); serializer.Serialize(Console.Out, yamlObject); string jsonText = JsonConvert.SerializeObject(yamlObject); jobject = JObject.Parse(jsonText); importfilecdo = classobj.ConvertObject(jobject, importfilecdo, false); objCDO.importfilecdo = importfilecdo; } else if (FullPath.ToUpper().Contains(".CSV")) { } //Comment out if db is not active // objBl.InsertData((CommonModel)objCDO); } else { Console.WriteLine($"Please check the file if you have placed in the directory {FullPath}"); } }
public DataTable ExcelToDataTable(string filepath) { IImportDataBL import = new ImportDataBL(); return(import.ExcelToDataTable(filepath)); }
public void DataTableToList(int Id, string filepath, bool RUBool) { IImportDataBL List = new ImportDataBL(); List.DataTableToList(Id, filepath, RUBool); }
public bool ImportData(int ID, string FileName) { IImportDataBL import = new ImportDataBL(); return(import.ImportData(ID, FileName)); }