public ImportCDO.CommonReturnCDO InsertDate(ImportCDO.CommonModel commonPassParameter)
{
CommonReturnCDO objReturnCDO = new CommonReturnCDO();
DataSet ds = new DataSet();
SqlCommand cmd = null;
ImportFileCDO objcdo = null;
try
{
objcdo = (ImportFileCDO)commonPassParameter;
cmd = GetCommand();
cmd.CommandText = "USPInsertImport";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("StoreName", objcdo.StoreName);
cmd.Parameters.AddWithValue("SourcePath", objcdo.SourcePath);
cmd.Parameters.AddWithValue("CreatedBy", objcdo.CreatedBy);
cmd.Parameters.AddWithValue("CreatedOn", objcdo.CreatedDate);
cmd.Parameters.AddWithValue("IsActive", objcdo.IsActive);
cmd.ExecuteNonQuery();
foreach (var importfiledata in objcdo.importfilecdo)
{
cmd.CommandText = "USPInsertImportData";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Name", importfiledata.Name);
cmd.Parameters.AddWithValue("TwitterId", importfiledata.TwitterId);
cmd.Parameters.AddWithValue("CategoryGUID", importfiledata.CategoryGUID);
cmd.ExecuteNonQuery();
foreach (var category in importfiledata.Categories)
{
cmd.CommandText = "USPInsertImportDataCategory";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Name", category);
cmd.Parameters.AddWithValue("@CategoryGUID", importfiledata.CategoryGUID);
cmd.ExecuteNonQuery();
}
}
cmd.Transaction.Commit();
objReturnCDO.IsSuccess = true;
return(objReturnCDO);
}
catch (Exception ex)
{
return(objReturnCDO);
}
finally { cmd.Connection.Close(); }
}
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}");
}
}
