private static string MakeInputFromJSonAndExcelFile(string fileName, string content64, string sJSonDatabase64, DataTable dt) { StringBuilder sBuilder = new StringBuilder(); var jsonSerializer = new JavaScriptSerializer(); byte[] bJSonData = Convert.FromBase64String(sJSonDatabase64); string RawJsonData = ASCIIEncoding.ASCII.GetString(bJSonData); PMSA.Framework.Log.CLogManager.WriteSL("JsonRawInput", RawJsonData); var objtest = jsonSerializer.Deserialize<CTradeInterfaceList>(RawJsonData); // if(objtest is CTradeInterfaceList) // { CTradeInterfaceList oCTradeInterfaceList = (CTradeInterfaceList)objtest; //string CSVContent = "ID;Code;Name;Phone;BirthDate\n1;'KH01';'Tuong';'0989876666';'2013-12-01'\n2;'KH02';'Nam';'0102001111';'2013-12-20'" + // "\n3;'KH03';'Thien';'0102001111';'2013-12-24'" + // "\n###\nID;Code;Name;Phone;BirthDate\n1;'KH01';'Tuong';'0989876666';'2013-12-01'\n2;'KH02';'Nam';'0102001111';'2013-12-20'"; int sheetsNumber = 1; string fileContent = CreateExcelSampleContent(fileName, content64, ref sheetsNumber); List<CTradeInterface>[] lTemp = new List<CTradeInterface>[1]; lTemp[0] = new List<CTradeInterface>(); //lTemp[1] = new List<CTradeInterface>(); //lTemp[2] = new List<CTradeInterface>(); /* foreach (var item in oCTradeInterfaceList.ListTrade) { if (item.IsFixedIncome == "1") lTemp[2].Add(item); } foreach (var item in oCTradeInterfaceList.ListTrade) { if (item.IsPreferredShare == "1") lTemp[1].Add(item); } foreach (var item in oCTradeInterfaceList.ListTrade) { if (item.IsFixedIncome != "1" && item.IsPreferredShare != "1") lTemp[0].Add(item); } */ int i = 1; foreach (DataRow r in dt.Rows) { CTradeInterface item = new CTradeInterface(); item.ID = i++; item.Address = r["Address"] != null ? r["Address"].ToString() : ""; item.Name = r["Name"] != null ? r["Name"].ToString() : ""; item.AvailableArea = r["AvailableArea"] != null ? r["AvailableArea"].ToString() : ""; item.PriceDescription = r["PriceDescription"] != null ? r["PriceDescription"].ToString() : ""; item.VATTax = r["VATTax"] != null ? r["VATTax"].ToString() : ""; item.ServiceFee = r["ServiceFee"] != null ? r["ServiceFee"].ToString() : ""; item.Description = r["Description"] != null ? r["Description"].ToString() : ""; lTemp[0].Add(item); } //ltemp[1].add(item); // ltemp[2].add(item); string JSONContent = FormatCSV(lTemp, sheetsNumber); JSONContent = Convert.ToBase64String(ASCIIEncoding.UTF8.GetBytes(JSONContent)); string inputXML = string.Format("<InputValue FileName=\"{0}\" FileStructContent=\"{1}\" FileCSVContent=\"{2}\"/>", fileName, fileContent, JSONContent); sBuilder.Append(MakeExcelOnlineEx(inputXML)); // } return sBuilder.ToString(); }
private static string MakeInputFromJSonAndExcelFile(string fileName, string content64, string sJSonDatabase64, DataTable dt) { StringBuilder sBuilder = new StringBuilder(); var jsonSerializer = new JavaScriptSerializer(); byte[] bJSonData = Convert.FromBase64String(sJSonDatabase64); string RawJsonData = ASCIIEncoding.ASCII.GetString(bJSonData); PMSA.Framework.Log.CLogManager.WriteSL("JsonRawInput", RawJsonData); var objtest = jsonSerializer.Deserialize <CTradeInterfaceList>(RawJsonData); // if(objtest is CTradeInterfaceList) // { CTradeInterfaceList oCTradeInterfaceList = (CTradeInterfaceList)objtest; //string CSVContent = "ID;Code;Name;Phone;BirthDate\n1;'KH01';'Tuong';'0989876666';'2013-12-01'\n2;'KH02';'Nam';'0102001111';'2013-12-20'" + // "\n3;'KH03';'Thien';'0102001111';'2013-12-24'" + // "\n###\nID;Code;Name;Phone;BirthDate\n1;'KH01';'Tuong';'0989876666';'2013-12-01'\n2;'KH02';'Nam';'0102001111';'2013-12-20'"; int sheetsNumber = 1; string fileContent = CreateExcelSampleContent(fileName, content64, ref sheetsNumber); List <CTradeInterface>[] lTemp = new List <CTradeInterface> [1]; lTemp[0] = new List <CTradeInterface>(); //lTemp[1] = new List<CTradeInterface>(); //lTemp[2] = new List<CTradeInterface>(); /* foreach (var item in oCTradeInterfaceList.ListTrade) * { * if (item.IsFixedIncome == "1") * lTemp[2].Add(item); * } * * foreach (var item in oCTradeInterfaceList.ListTrade) * { * if (item.IsPreferredShare == "1") * lTemp[1].Add(item); * } * * foreach (var item in oCTradeInterfaceList.ListTrade) * { * if (item.IsFixedIncome != "1" && item.IsPreferredShare != "1") * lTemp[0].Add(item); * } */ int i = 1; foreach (DataRow r in dt.Rows) { CTradeInterface item = new CTradeInterface(); item.ID = i++; item.Address = r["Address"] != null ? r["Address"].ToString() : ""; item.Name = r["Name"] != null ? r["Name"].ToString() : ""; item.AvailableArea = r["AvailableArea"] != null ? r["AvailableArea"].ToString() : ""; item.PriceDescription = r["PriceDescription"] != null ? r["PriceDescription"].ToString() : ""; item.VATTax = r["VATTax"] != null ? r["VATTax"].ToString() : ""; item.ServiceFee = r["ServiceFee"] != null ? r["ServiceFee"].ToString() : ""; item.Description = r["Description"] != null ? r["Description"].ToString() : ""; lTemp[0].Add(item); } //ltemp[1].add(item); // ltemp[2].add(item); string JSONContent = FormatCSV(lTemp, sheetsNumber); JSONContent = Convert.ToBase64String(ASCIIEncoding.UTF8.GetBytes(JSONContent)); string inputXML = string.Format("<InputValue FileName=\"{0}\" FileStructContent=\"{1}\" FileCSVContent=\"{2}\"/>", fileName, fileContent, JSONContent); sBuilder.Append(MakeExcelOnlineEx(inputXML)); // } return(sBuilder.ToString()); }