public ProcessMsg ExportTraySumPartCSV(List <string> trayIds, string filename, List <string> fieldNames)
{
ProcessMsg msg = new ProcessMsg()
{
result = false
};
try
{
List <TrayPackView> tpv = TrayPackViewHelper.GetTPVByTrayIdsGropSumPartNr(trayIds);
// List<TrayPackView> ts = tpv.ToList();
List <string> updateTrayIds = new List <string>();
CSVDataSet ds = new CSVDataSet();
foreach (TrayPackView v in tpv)
{
CSVDataRecord r = new CSVDataRecord();
List <string> values = ClassUtil.GetModelValues(fieldNames, v);
if (values != null)
{
foreach (string value in values)
{
r.Add(value);
}
}
//r.Add(v.partNr);
//r.Add(v.capa.ToString());
if (TrayPackStatusHelper.CanAddPrefix(v.tstatus))
{
r.Add(v.TsStatusCN);
}
ds.Add(r);
if (TrayPackStatusHelper.CanUpdateToExported(v.tstatus))
{
updateTrayIds.Add(v.trayId);
}
}
CSVUtil.GenCSVFile(ds, filename);
if (updateTrayIds.Count > 0)
{
TraysHelper.UpdateTraysStatus(updateTrayIds, TrayStatus.Exported);
}
msg.result = true;
msg.AddMessage(ReturnCode.OK, "成功导出CSV文件");
}
catch (Exception e)
{
msg.AddMessage(ReturnCode.Error, e.Message);
}
return(msg);
}
public ProcessMsg ExportTraySumPartCSV(List<string> trayIds, string filename, List<string> fieldNames)
{
ProcessMsg msg = new ProcessMsg() { result = false };
try
{
List<TrayPackView> tpv = TrayPackViewHelper.GetTPVByTrayIdsGropSumPartNr(trayIds);
// List<TrayPackView> ts = tpv.ToList();
List<string> updateTrayIds = new List<string>();
CSVDataSet ds = new CSVDataSet();
foreach (TrayPackView v in tpv)
{
CSVDataRecord r = new CSVDataRecord();
List<string> values = ClassUtil.GetModelValues(fieldNames, v);
if (values != null)
foreach (string value in values)
r.Add(value);
//r.Add(v.partNr);
//r.Add(v.capa.ToString());
if (TrayPackStatusHelper.CanAddPrefix(v.tstatus))
r.Add(v.TsStatusCN);
ds.Add(r);
if (TrayPackStatusHelper.CanUpdateToExported(v.tstatus))
updateTrayIds.Add(v.trayId);
}
CSVUtil.GenCSVFile(ds, filename);
if (updateTrayIds.Count > 0)
TraysHelper.UpdateTraysStatus(updateTrayIds, TrayStatus.Exported);
msg.result = true;
msg.AddMessage(ReturnCode.OK, "成功导出CSV文件");
}
catch (Exception e)
{
msg.AddMessage(ReturnCode.Error, e.Message);
}
return msg;
}
public int import_contacts(string filename)
{
var dialer_configuration = new DialerConfigurationManager(Application.ICSession);
var data = new CSVDataSet(filename);
var fields = data.Fields;
var columns = configuration.GetColumns();
var mapping = new Dictionary <DBColumn, DBColumn>();
foreach (var field in fields)
{
var column = fields.First(item => string.Compare(item.Name, field.Name) == 0);
if (column != null)
{
mapping.Add(field, column);
}
}
if (mapping.Keys.Count <= 0)
{
throw new ArgumentException(string.Format("No mapping available between Contact List {0} and CSV filename {1}", DisplayName, filename), filename);
}
return(configuration.BulkImport(dialer_configuration.GetHttpRequestKey(configuration.ConfigurationId), data, mapping));
}
static void Main(string[] args)
{
string payer = "Providence Health Plan";
string policyStartDt = "4/1/2019";
string policyEndDt = "6/1/2019";
//string path = @"C:\Users\Pradeep\Downloads\tabula-PHP_prior_authorization_code_list_short (2).csv";
string path = @"D:\Cennest\tabula-PHP_prior_authorization_code_list_new.csv";
string indexColumn = "Code";
int headerSpan = 2;
var csvSet = new CSVDataSet <Dictionary <string, string> >(path, ',', headerSpan: headerSpan);
var rows = csvSet.ToList();
Dictionary <int, SafeObject <string, string> > processedRows = new Dictionary <int, SafeObject <string, string> >();
int counter = 0;
foreach (var row in rows)
{
if (row[indexColumn].ToString().Length > 0)
{
counter++;
}
if (processedRows.ContainsKey(counter) == false)
{
processedRows[counter] = SafeObject <string, string> .Create();
}
SafeObject <string, string> line = processedRows[counter];
foreach (var key in row.Keys)
{
string value = row[key];
if (value.StartsWith("\"") && value.EndsWith("\""))
{
value = value.Replace("\"", "");
}
line[key] += value.Trim();
}
}
var providencePriorAuthSet = new PriorAuthorizationList();
providencePriorAuthSet.PayerName = payer;
providencePriorAuthSet.BillingPolicyDocumentStartDate = policyStartDt;
providencePriorAuthSet.BillingPolicyDocumentEndDate = policyEndDt;
foreach (SafeObject <string, string> csvRow in processedRows.Values)
{
CPT cpt = new CPT();
cpt.Code = csvRow["Code"];
cpt.AuthorizationEffectiveDate = csvRow["Prior AuthorizationEffective Date"];
cpt.AuthorizationTerminationDate = csvRow["Prior AuthorizationTermination Date"];
cpt.PlanNames = csvRow["Combined PA List"];
providencePriorAuthSet.CPTList.Add(cpt);
}
string xml = ToXML(providencePriorAuthSet);
string exportfile = Path.ChangeExtension(path, ".xml");
using (var writer = new FileWriter(exportfile, false))
{
writer.WriteText(xml, false);
}
}
public int import_contacts(string filename)
{
var dialer_configuration = new DialerConfigurationManager(Application.ICSession);
var data = new CSVDataSet(filename);
var fields = data.Fields;
var columns = configuration.GetColumns();
var mapping = new Dictionary<DBColumn, DBColumn>();
foreach(var field in fields)
{
var column = fields.First(item => string.Compare(item.Name, field.Name) == 0);
if (column != null)
{
mapping.Add(field, column);
}
}
if (mapping.Keys.Count <= 0) throw new ArgumentException(string.Format("No mapping available between Contact List {0} and CSV filename {1}", DisplayName, filename), filename);
return configuration.BulkImport(dialer_configuration.GetHttpRequestKey(configuration.ConfigurationId), data, mapping);
}
