public static _List <string> getValIntiligent(string k, _Dictionary <string, string> dic)
{
_List <string> retkeyval = new _List <string>();
bool notfound = true;
string containkey = "0";
string retkey = k;
string retval = "";
if (dic.ContainsKey(k))
{
notfound = false;
retval = dic[k];
containkey = "1";
}
if (notfound)
{
// _v1
Match m1 = Regex.Match(k, @"(.+)\s*\(v(\d)\)", RegexOptions.IgnoreCase);
if (m1.Success)
{
string newkey = m1.Groups[1].ToString().Trim() + "-" + m1.Groups[2].ToString();
if (dic.ContainsKey(newkey) && notfound)
{
notfound = false;
retval = dic[newkey];
retkey = newkey;
containkey = "2";
}
//lgstr.deb("matched " + k + ":" + newkey+": "+notfound.ToString());
newkey = m1.Groups[1].ToString().Trim();
if (dic.ContainsKey(newkey) && notfound)
{
notfound = false;
retval = dic[newkey];
retkey = newkey;
containkey = "3";
}
//lgstr.deb("matched " + k + ":" + newkey + ": " + notfound.ToString());
}
}
if (notfound)
{
//FDDIV
Match m1 = Regex.Match(k, @"[FT]DD\s*(\w+)", RegexOptions.IgnoreCase);
string newkey = m1.Groups[1].ToString().Trim();
if (dic.ContainsKey(newkey))
{
notfound = false;
retval = dic[newkey];
retkey = newkey;
containkey = "4";
}
}
retkeyval.Add(containkey);
retkeyval.Add(retkey);
retkeyval.Add(retval);
retkeyval.Add(k);
return(retkeyval);
}
public void gettable_tcno_spec_id_band(string spec)
{
//tc_band_sheet = new TwoKeyDictionary<string, string, string>();
tc_band_id = new TwoKeyDictionary <string, string, string>();
tc_band_status = new TwoKeyDictionary <string, string, string>();
tc_bandapplicability = new _Dictionary <string, string>();
tc_des = new _Dictionary <string, string>();
try
{
dbobj.tablename = "v_comb_serv_info";
string Conditionstring = String.Format("(spec = \"{0}\" and ver_gcf_ptcrb_op = \"{1}\")", spec, gcfver);
List <string> colnames = new List <string>()
{
"testcase", "band", "id", "bandapplicability", "tcstatus", "sheetname", "Description"
};
DataTable retdt = dbobj.getdatatble(colnames, Conditionstring);
foreach (DataRow row in retdt.Rows)
{
string tcno = row[0].ToString().Replace(" ", "").ToLower();
if (tc_band_id.ContainsKey(tcno, row[1].ToString()))
{
//lgstr.cri(String.Format("{GenericParser:gettable_tcno_spec_id_band} duplicate of {0} and {1} found in spec {2} ", row[0].ToString(), row[1].ToString(), spec));
lgstr.cri("{ FORMUpload:gettable_tcno_spec_id_band} duplicate tc/band combination. TC: " + tcno + " Band: " + row[1].ToString());
}
if (!tc_bandapplicability.ContainsKey(tcno))
{
tc_bandapplicability[tcno] = row[3].ToString();
}
if (!tc_des.ContainsKey(tcno))
{
tc_des[tcno] = row[6].ToString();
}
tc_band_id[tcno, row[1].ToString()] = row[2].ToString();
tc_band_status[tcno, row[1].ToString()] = row[4].ToString();
//tc_band_sheet[tcno, row[1].ToString()] = row[5].ToString();
}
//lgstr.inf("tc_bandapplicability");
//lgstr.inf(tc_bandapplicability.ToString());
//lgstr.inf("tcbandstatus");
//lgstr.inf(tc_band_status.ToString());
}
catch (Exception ex)
{
Debug.Print("Exception from gettable : " + ex.ToString());
lg.war("{FORMUpload:gettable_tcno_spec_id_band} Exception: " + ex.Message.ToString());
}
//return tc_band_id;
}
/// <summary>
/// This function will be used to get value from a dictionary. no key found treated as False.
/// </summary>
/// <param name="a">
/// this is the string will be searched in the dictionary
/// </param>
/// <param name="b">
/// The dictionary
/// </param>
/// <returns></returns>
public static string convertBoolHelper(string a)
{
string c;
if (!fmnemonic && picssupport.ContainsKey(a))
{
c = picssupport[a];
}
else if (fmnemonic && PICSmnemonicDic.ContainsKey(a))
{
c = PICSmnemonicDic[a];
}
else
{
c = "False";
lgstr.war("{convertBoolHelper} KeyNotFound " + "-> " + a);
}
return(c);
}
public void getbandicesupport(string icebandsupportall)
{
dbobj.tablename = "testbandconfig";
DataTable dt = dbobj.getdatatble();
band_vs_icesupport.Clear();
foreach (DataRow row in dt.Rows)
{
string ba = row["band2"].ToString();
//string icesupport = bandSupportHelper(ba, icebandsupportall) ?"S":"NS";
_List <string> icebandalllst = new _List <string>(icebandsupportall.Split(' ').ToList());
string icesupport = StringProcess.bandSupportHelper(ba, icebandalllst) ? "S" : "NS";
if (!band_vs_icesupport.ContainsKey(ba))
{
band_vs_icesupport.Add(ba, icesupport);
}
}
lg.deb("band vs customer band support: \n\t\t\t" + band_vs_icesupport.ToString());
//Debug.Print(band_vs_icesupport.ToString());
// return band_vs_icesupport;
}
//public static _Dictionary<string, string> getBandListTc(string tcno, string spec)
//{
// //dbobj.DatabaseName = "testplandb";
// //dbobj.connectToDatabase();
// _Dictionary<string, string> returnval = new _Dictionary<string, string>();
// try
// {
// List<string> colnames = new List<string>() { "Band", "ID" };
// string Conditionstring = String.Format("TCNumber = {0} and standards = {1}", tcno, spec);
//
// returnval = dbquery("tcconfigtable", colnames, Conditionstring);
// }
// catch (Exception ex)
// {
// Debug.Print("Exception: " + ex.ToString());
// }
// return returnval;
//}
private void picsreco(string recostring)
{
string idk;
if (picsBandRecoStr.ContainsKey(recostring))
{
idk = picsBandRecoStr[recostring];
}
else
{
dbobj.insertdata(new List <string>()
{
recostring
}, new List <string>()
{
"TCR_BandR_Rel"
});
string condrecostring = String.Format(" TCR_BandR_Rel = \"{0}\"", recostring);
idk = dbobj.getid("ID", condrecostring).ToString();
//returndictreco = dbquery(dbobj.tablename, reconame, condrecostring);
picsBandRecoStr.Add(recostring, idk.ToString());
}
}
//public static Logging lg;
//public static void mainprocess(string filePICSFullPath, _List<string> specTVAFiles, _List<string> specCVLFiles, Logging lg, MySqlDb dbobj, FormUpload frm)
public static void mainprocess(string filePICSFullPath, _List <string> specTRLFiles, Logging lg, MySqlDb dbobj, FormUpload frm)
{
frm.SetProgress(0);
frm.apendlog("Started PICS process", 4);
lg.deb(" ++++ PICS Process started ++++ ");
lg.deb("PICS User File : " + filePICSFullPath);
lg.deb("List of CSV files on server spec data: \n\t\t" + specTRLFiles.ToString());
progressint = Convert.ToInt32(progress);
//lg.inf("progress: " + progress.ToString() + " t : " + DateTime.Now.ToString("h:mm:ss tt"));
// START
string curDir = System.Environment.CurrentDirectory;
string outputfilename = Path.Combine(curDir, "combinedOutput.csv");
string file_picsmapping = Path.Combine(curDir, "_picsmapping.csv");
string file_picsstatus = Path.Combine(curDir, "_picsstatus.csv");
string icebandall = "";
string icebandulca = "";
string ice4x4MIMO = "";
GenericParser gp = new GenericParser(@filePICSFullPath);
List <string> excelsheetlist = MySqlDb.GetExcelsheetslist(@filePICSFullPath);
Debug.Print("all sheet name: " + string.Join(" , ", excelsheetlist));
gp.lg = lg;
List <int> x = new List <int> {
1, 6
};
//itemno vs [support, pnemonic]
Dictionary <string, object> PICSoutput = gp.readwholepics();
//
//lg.inf("PICS file Data: itemno vs [support,pnemonic]");
//lg.inf(PICSoutput.ToString());
TwoKeyDictionary <string, string, string> pics_reco_dic = new TwoKeyDictionary <string, string, string>();
_Dictionary <string, string> pics_reco_table;
_Dictionary <string, string> PICSFormattedSupportOutput = gp.PICSFormatChangeSupport(PICSoutput);
//lg.deb("PICS file Data. calculated to True/False with #");
//lg.deb(PICSFormattedSupportOutput.ToString());
_Dictionary <string, string> PICSmnemonicDic = gp.PICSFormatMnemonicsChangeSupport(PICSoutput);
StringProcess.PICSmnemonicDic = PICSmnemonicDic;
lg.inf("PICSmnemonicDic only for spec 12 = 102 230 :\n" + PICSmnemonicDic.ToString());
picsSupBandList = gp.PICSSupportedBands(PICSFormattedSupportOutput, PICSoutput);
lg.inf("picsSupBandList :\n" + picsSupBandList.ToString());
progress = 2;
//lg.inf("progress: " + progress.ToString() + "t : " + DateTime.Now.ToString("h:mm:ss tt"));
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
Dictionary <string, object> RFBandListD = gp.RFBandTableD(PICSFormattedSupportOutput);
Dictionary <string, object> RFBandListE = gp.RFBandTableE(PICSFormattedSupportOutput, PICSoutput);
TwoKeyDictionary <string, string, string> user_bs_rb_pics = new TwoKeyDictionary <string, string, string>();
dbobj.tablename = "user_bs_rb_pics";
DataTable dt = dbobj.getdatatble();
Debug.Print("Reading Data Table");
foreach (DataRow dr in dt.Rows)
{
user_bs_rb_pics[dr["bandsupport"].ToString(), dr["requiredband"].ToString()] = dr["id"].ToString();
}
//lg.inf("user_bs_rb_pics" + user_bs_rb_pics.ToString());
// user_picsver | picsver -> picssupportedbandlist -> id#gcfver
// write user_picsver and get id. this will return picsversionid too.
string idpicsver = frm.insertpicsver(picsSupBandList.toCommaList());
DataTable icebanddt = dbobj.getDtFromSqlSt(String.Format("Select icebands, icebands_ulca, 4x4_mimo from user_picsver where id = {0}", idpicsver));
foreach (DataRow row in icebanddt.Rows)
{
//returnval[row[0].ToString(),row[1].ToString()] = row[2].ToString();
//Debug.Print(row[0].ToString());
icebandall = row[0].ToString();
icebandulca = row[1].ToString();
ice4x4MIMO = row[2].ToString();
break;
}
lg.inf("customer band from db: (all) " + icebandall);
lg.inf("customer band from db:(ulca) " + icebandulca);
frm.getbandicesupport(icebandall);
//string servDir = @"\\sd-ct-opiot.sn.intel.com\Dropbox\tools\TPG\sampleinput\Specs";
//New Code End
progress = 3;
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
int specfilescount = specTRLFiles.Count();
double progressinc = 97 / specfilescount;
for (int i = 0; i < specfilescount; i++)
{
//lg.inf("progress: " + progress.ToString() + " t : " + DateTime.Now.ToString("h:mm:ss tt"));
string status = "Processing : " + specTRLFiles[i];
frm.SetLabelstat(status);
//string fileNameTVA = specTVAFiles[i];
//string fileNameCVL = specCVLFiles[i];
string filenameTRL = specTRLFiles[i];
string fileTRLPath = Path.Combine(servDir, filenameTRL);
gp.clearVar();
// Getting a portion of string:
string patt = @"(.+?)_\w+";
var mc = Regex.Match(filenameTRL, patt);
string spec = mc.Groups[1].ToString();
//string fileCVLPath = Path.Combine(servDir, fileNameCVL);
//string fileTVAPath = Path.Combine(servDir, fileNameTVA);
lg.deb("{MainProcess} Processing -> spec: " + spec + "\tfiles: " + filenameTRL.ToString());
frm.apendlog("Processing spec = " + spec, 4);
//_Dictionary<string, string> condVsLogicDic = gp.getdictionaryRowCol(1, 0, fileCVLPath);
// this function will change condDict make adding hash. (not sure)
// itemProcess is not needed for new algo
//itemProcess(condVsLogicDic, spec);
//lg.inf("{MainProcess} Condition vs. logical exp from server csv for Spec: " + spec);
//lg.inf(condVsLogicDic.ToString());
//this will convert item to true false as per PICS
// Here, we are changing the conDict according to spec. It is different only for Spec:102.230.
//combinedCond(condVsLogicDic, PICSFormattedSupportOutput);
//lg.deb(@"{MainProcess} Condition vs T/F after using PICS for Spec: " + spec);
//lg.deb(condVsLogicDic.ToString());
// filter spec string to address spec confusion for 51.010
//string spec = spec;
//if (spec.StartsWith("51.010"))
//{
// spec = "51.010";
//}
//lg.inf("tempdebug: spec: " + spec +" new spec: "+ spec);
frm.SetLabelstat(status + " db query to get test configuration");
// Database query to get all the info for the spec. from tcconfig table
frm.gettable_tcno_spec_id_band(spec);
//TwoKeyDictionary<string, string, string> tc_band_sheet = frm.tc_band_sheet;
_Dictionary <string, string> tc_des = frm.tc_des;
TwoKeyDictionary <string, string, string> tc_band_id = frm.tc_band_id;
TwoKeyDictionary <string, string, string> tc_band_status = frm.tc_band_status;
_Dictionary <string, string> tc_bandapplicability = frm.tc_bandapplicability;
//lg.deb("sheetname from db"+tc_band_sheet.ToString());
//lg.deb("testconfig from DB");
//lg.deb(tc_band_id.ToString());
//lg.deb("tc_bandapplicability from DB");
//lg.deb(tc_bandapplicability.ToString());
//lg.deb("tc_band_status from DB");
//lg.deb(tc_band_status.ToString());
_Dictionary <string, string> TCvsApp = new _Dictionary <string, string>();
_Dictionary <string, string> TCvsAppFiltered = new _Dictionary <string, string>();
_Dictionary <string, string> csvTCvsRel = new _Dictionary <string, string>();
_Dictionary <string, object> TCvsBand = new _Dictionary <string, object>();
TwoKeyDictionary <string, string, string> bsrbidxdic = new TwoKeyDictionary <string, string, string>();
if (File.Exists(fileTRLPath))
{
_Dictionary <string, string> dict_logic = new _Dictionary <string, string>();
_Dictionary <string, string> dict_logic_TF = new _Dictionary <string, string>();
_Dictionary <string, string> dict_rel = new _Dictionary <string, string>();
_Dictionary <string, string> dict_de = new _Dictionary <string, string>();
_Dictionary <string, string> dict_pnemonic = new _Dictionary <string, string>();
StringProcess.specDash1 = spec;
StringProcess.readconfigpics();
//StringProcess.
gp.dict_de = dict_de;
gp.dict_logic = dict_logic;
gp.dict_logic_TF = dict_logic_TF;
gp.dict_pnemonic = dict_pnemonic;
gp.dict_rel = dict_rel;
GenericParser.picssupport = PICSFormattedSupportOutput;
//this will generate logic to TF
gp.processlogic(fileTRLPath);
if (GenericParser.missingpicsitem.Count > 0)
{
lg.inf("{MainProcess} Missing Item in pics file:");
lg.war(GenericParser.missingpicsitem.ToString());
}
lg.inf("{MainProcess} TC vs True False TRL + pics file:");
lg.inf(dict_logic_TF.ToString());
lg.inf("{MainProcess} TC vs Logic from TRL:");
lg.inf(dict_logic.ToString());
//_Dictionary<string, string> csvTCvsCond;
//_Dictionary<string, string> dict_de;
//frm.SetLabelstat(status + " process tc vs cond");
//csvTCvsCond = new _Dictionary<string, string>(gp.getdictionaryRowCol(1, 0, fileTVAPath,true));
//frm.SetLabelstat(status + " process tc vs rel");
//csvTCvsRel = new _Dictionary<string, string>(gp.getdictionaryRowCol(2, 0, fileTVAPath,true));
//frm.SetLabelstat(status + " process tc vs Band cond");
//dict_de = new _Dictionary<string, string>(gp.getdictionaryRowCol(3, 0, fileTVAPath,true));
//lg.inf("{MainProcess} TC vs Condion from server csv file:");
//lg.inf(csvTCvsCond.ToString());
// This loop iterates over the configurations obtained from the database
progress += progressinc * 0.1;
progressint = Convert.ToInt32(progress);
double progressinc2 = progressinc * 0.8;
int tccount = tc_band_id.getCount();
double progressinc3 = progressinc2 / tccount;
//lg.inf(String.Format("progress: {0} ,progressinc: {1}, progressinc2: {2},progressinc3: {3} tccount: {4}", progress, progressinc, progressinc2, progressinc3, tccount));
StringProcess.mismatchedbandbandsupporthelper.Clear();
//read new csv file here
//string picslogic = "";
foreach (KeyValuePair <string, Dictionary <string, string> > temp in tc_band_id)
{// reading database test case - band vs id start
string ms1 = DateTime.Now.Millisecond.ToString();
string s1 = DateTime.Now.Second.ToString();
string tc = temp.Key.Replace(" ", "").ToLower();
string oldTC = tc;
string picstmpstr = "";
string picsBand = "";
string picsRel = "Rel: NF";
string picsTCReco = "";
_Dictionary <string, string> band_id = new _Dictionary <string, string>(temp.Value);
_List <string> bandsPerTC = new _List <string>(band_id.Keys.ToList());
lg.inf("{MainProcess} List of bands from db for TestCase: " + tc);
lg.inf(bandsPerTC.ToString());
// Start: For Remving V1 or V2 from TC
string TCvsAppFilteredTempSingle = "";
string pattTC = @"(.*)\s\(v\d+\)";
Match mcTC = Regex.Match(tc, pattTC);
if (mcTC.Success)
{
tc = mcTC.Groups[1].ToString().Trim();
lg.war("TC Converted from old " + oldTC + " to " + tc);
frm.apendlog("TC Converted from old " + oldTC + " to " + tc);
}
// End: For Remving V1 or V2 from TC
// for spec 37.901 to match test case after the dash everything should be removed
if (spec == "37.901")
{
tc = tc.Split('-')[0];
}
//var tctemplist = dict_logic_TF.Keys.Where(t => t.Trim().Replace(" ", "").ToLower() == tc.Trim().Replace(" ", "").ToLower());
string tcapplicability = "";
foreach (string tctemp in dict_logic_TF.Keys)
{
if (tctemp.Trim().Replace(" ", "").ToLower() == tc.Trim().Replace(" ", "").ToLower())
{
tcapplicability = dict_logic_TF[tctemp];
if (dict_rel.ContainsKey(tctemp))
{
picsRel = dict_rel[tctemp];
}
//if (dict_logic.ContainsKey(tctemp))
// picslogic = dict_logic[tctemp];
break;
}
}
// checking if csvTCvsCond has the tc(after removing v1/v2)
if (tcapplicability != "")
{
//string tcapplicability = dict_logic_TF[tc].Trim();
if (tcapplicability == "R")
{
TCvsApp.Add(tc, "R");
picsTCReco = "TC: R";
}
else if (tcapplicability == "m")
{
TCvsApp.Add(tc, "R");
picsTCReco = "TC: R";
}
else if (tcapplicability != "")
{
string dbgexception = " TC = " + tc;
//string condCurTC = "";
string resCurTC = tcapplicability;
try
{
// Pass it through a function: addressing special case 51.010-4...
//condCurTC = csvTCvsCond[tc];
//dbgexception += "\tcondCurTC = " + condCurTC;
// Pass it through a function:
//resCurTC = tcapplicability;//dict_logic_TF[tc];
//resCurTC = StringProcess.TCVsTF(condCurTC, condVsLogicDic);
dbgexception += "\tresCurTC = " + resCurTC;
//lg.deb("Result from condition map: " + resCurTC + "for TestCase: " + tc);
if (!TCvsApp.ContainsKey(tc))
{
TCvsApp.Add(tc, resCurTC);
}
TCvsAppFilteredTempSingle = gp.TCvsAppRefined(resCurTC);
if (!TCvsAppFiltered.ContainsKey(tc))
{
TCvsAppFiltered.Add(tc, TCvsAppFilteredTempSingle);
}
dbgexception += "\tresCurTCFiltered = " + TCvsAppFilteredTempSingle;
picsTCReco = "TC: " + TCvsAppFilteredTempSingle;
}
catch (Exception ex)
{
lg.err("{MainProcess} Exception: " + ex.Message + "\n\t\t\t" + dbgexception);
picsTCReco = "TC: X";
frm.apendlog(ex.Message, 2);
}
}
}
else
{ // tc is not in the dictionary. csvTCvsCond.ContainsKey(tc)
if (spec == "tty")
{
picsTCReco = "TC: R";
}
else
{
picsTCReco = "TC: -";
lg.war("{MainProcess} CSVOutputTCApp KeyNotFound = " + tc);
frm.apendlog("TC missing : " + tc, 3);
}
}
_List <string> bandListDE = new _List <string>();
//_List<string> keyInTCvsRel = new _List<string>(csvTCvsRel.Keys.ToList());
//if (csvTCvsRel.ContainsKey(tc))
// picsRel = csvTCvsRel[tc];
if (spec == "36.521-1")
{
if (dict_de.ContainsKey(tc))
{
patt = @"([DE])\d+";
var mc1 = Regex.Match(dict_de[tc], patt);
string res = mc1.Groups[1].ToString();
if (res == "D")
{
List <string> bandListD = new List <string>();
if (RFBandListD.ContainsKey(dict_de[tc]))
{
bandListD = (List <string>)RFBandListD[dict_de[tc]];
}
TCvsBand.Add(tc, bandListD);
foreach (string bandVal in bandListD)
{
bandListDE.Add(bandVal);
}
}
else if (res == "E")
{
List <string> bandListE = new List <string>();
if (RFBandListE.ContainsKey(dict_de[tc]))
{
bandListE = (List <string>)RFBandListE[dict_de[tc]];
}
TCvsBand.Add(tc, bandListE);
foreach (string bandVal in bandListE)
{
bandListDE.Add(bandVal);
}
}
}
else
{
lg.war("{MainProcess} CSVOutputTCBand KeyNotFound = " + tc);
frm.apendlog("TC missing :: " + tc, 3);
}
lg.inf("DE Check: " + tc + " band list: " + bandListDE.ToString());
//frm.apendlog("bandlist error " + tc, 1);
}
_Dictionary <string, string> band_status = new _Dictionary <string, string>(frm.tc_band_status[oldTC]);
lg.inf(" " + band_status.ToString());
bandHO = frm.rb_order_ho_str.Split(',');
bandOther = frm.rb_order_other_str.Split(',');
_Dictionary <string, string> band_rb = processRequiredBand(band_status, tc_bandapplicability[oldTC]);
foreach (KeyValuePair <string, string> kvp in band_id)
{
string band_id_key = kvp.Key;
string band_id_val = kvp.Value;
string band_rb_val = "E";
_List <string> modifiedband = StringProcess.getValIntiligent(band_id_key, band_rb);
band_rb_val = modifiedband[2];
if (modifiedband[0] != "1")
{
lg.inf("bandchange" + modifiedband.ToString());
}
string pics_reco_str = picstmpstr;
picsBand = "";
bool isSuppBand = StringProcess.bandSupportHelper(band_id_key, picsSupBandList);
if ((frm.testcat == "rf") || (frm.testcat == "att") || (frm.testcat == "vzw") || (frm.testcat == "cmcc"))
{
band_rb_val = "";
}
if (spec == "36.521-1")
{
//string PICSRecoBand = "";
bool PICSRecoBand = StringProcess.bandSupportHelper(band_id_key, bandListDE);
//lg.cri("After call: " + tc + " band list: " + bandListDE.ToString());
if (PICSRecoBand)
{
//picsBand = "Band: R";
picsBand = "";
}
else
{
picsBand = "Band: NR";
}
if (tc.StartsWith("8") | tc.StartsWith("9"))
{
picsBand = "";
}
//if ((tc_band_sheet[tc, band_id_key] == "LTE_UL_CA") || ((tc_band_sheet[tc, band_id_key] == "64QAM")))
string desc = tc_des[tc].ToLower();
if (desc.Contains("64qam") || desc.Contains("dl ca and ul ca"))
{
string pattULCA = @"CA_(\d+[A-E])";
Match mcULCA = Regex.Match(band_id_key, pattULCA);
if (mcULCA.Success)
{
string band_id_key_mod = "UL" + band_id_key;
if (picsSupBandList.Contains(band_id_key_mod))
{
isSuppBand = true;
}
}
}
}
picsRel = picsRel.Replace(",", " ");
if (picsTCReco != "")
{
if (pics_reco_str == "")
{
pics_reco_str += picsTCReco;
}
else
{
pics_reco_str += ", " + picsTCReco;
}
}
if (picsRel != "")
{
if (pics_reco_str == "")
{
pics_reco_str += picsRel;
}
else
{
pics_reco_str += ", " + picsRel;
}
}
if (picsBand != "")
{
if (pics_reco_str == "")
{
pics_reco_str += picsBand;
}
else
{
pics_reco_str += ", " + picsBand;
}
}
//if (picsRel.ToLower().Contains("only"))
// pics_reco_str += ",Rel:NR";
//r(?:el)?(?:ease)?[-\s]?\d+\s*(?:to|and)\s*r(?:el)?(?:ease)?[-\s]?(\d+)\s*only
//\s*r(?:el)?(?:ease)?[-\s]?(\d+)\s*only
// rel 2 to rel 6
// string relpatt = @"(?:r(?:el)?(?:ease)?[-\s]?\d+\s*(?:to|and)\s*)?r(?:el)?(?:ease)?[-\s]?(\d+)\s*only";
// Match relm = Regex.Match(picsRel, relpatt,RegexOptions.IgnoreCase);
// if (relm.Success)
// {
// int rel = int.Parse(relm.Groups[1].ToString());
// if ((rel < 90) && (rel < int.Parse(uerelease)))
// {
// pics_reco_str += ", Rel:NR";
// }
//
// }
string PICSSuppBand = "NS";
if (isSuppBand)
{
PICSSuppBand = "S";
}
string idstr = "-1";
if (user_bs_rb_pics.ContainsKey(PICSSuppBand, band_rb_val))
{
idstr = user_bs_rb_pics[PICSSuppBand, band_rb_val];
}
else
{
lg.cri("no key found: picssupband" + PICSSuppBand + " requiredband " + band_rb_val + "\n" + user_bs_rb_pics.ToString());
frm.apendlog("pics support band and requiredband process failed for band:" + band_id_key, 1);
}
if (!bsrbidxdic.ContainsKey(oldTC, band_id_key))
{
bsrbidxdic[oldTC, band_id_key] = idstr;
}
// user_picsstatus | picsstatus
//
//string idstr = FormUpload.getid_Reco(pics_reco_table, PICSOutputStr);
if (!pics_reco_dic.ContainsKey(oldTC, band_id_val))
{
pics_reco_dic[oldTC, band_id_val] = pics_reco_str;
}
GenericParser.writetocsv(file_picsstatus, pics_reco_str + "\t");
pics_reco_str = String.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}", band_id_key, oldTC, band_id_val, pics_reco_str, PICSSuppBand, idstr);
GenericParser.writetocsv(outputfilename, pics_reco_str);
lg.deb("FinalOutput: " + tc + " Result: " + pics_reco_str);
}
progress += progressinc3;
if (progressint < Convert.ToInt32(progress))
{
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
}
progressint = Convert.ToInt32(progress);
}// reading database test case - band vs id end
lg.war("Missing Bands from 'picsSupBandList':\n\t\t " + string.Join(" ", StringProcess.mismatchedbandbandsupporthelper));
// GET user_picsstatus table here. as a dictionary.
dbobj.tablename = "user_picsstatus";
file_picsstatus = file_picsstatus.Replace(@"\", @"/");
dbobj.insertfile(file_picsstatus, "picsstatus");
pics_reco_table = frm.getfulltable("user_picsstatus", "picsstatus");
//lg.deb("PICS Reco String table from DB");
//lg.deb(pics_reco_table.ToString());
//lg.deb("rb_sb");
//lg.deb(bsrbidxdic.ToString());
//lg.deb("tcr: " + pics_reco_table["TC: R, REL-8"]);
foreach (KeyValuePair <string, Dictionary <string, string> > temp in tc_band_id)
{
string tc = temp.Key.Replace(" ", "");
_Dictionary <string, string> band_id = new _Dictionary <string, string>(temp.Value);
foreach (KeyValuePair <string, string> kvp in band_id)
{
string picsrecoid = "-1";
string bsrbidx = "-1";
string band_id_key = kvp.Key;
string band_id_val = kvp.Value;
string pics_reco_str = pics_reco_dic[tc, band_id_val];
string picslogic = "";
if (dict_logic.ContainsKey(tc))
{
picslogic = dict_logic[tc];
}
else
{
picslogic = "";
lg.war("logicstring error" + tc);
}
//------converting REL to Rel - start---------
foreach (KeyValuePair <string, string> kvp1 in pics_reco_table)
{
string picsstringdb = kvp1.Key;
if (picsstringdb.ToLower().Trim() == pics_reco_str.ToLower().Trim())
{
picsrecoid = kvp1.Value;
}
}
//if (pics_reco_table.ContainsKey(pics_reco_str))
//{
// picsrecoid = pics_reco_table[pics_reco_str];
//}
//else
if (picsrecoid == "-1")
{
lg.cri("No Key for " + pics_reco_str);
lg.deb(pics_reco_table.ToString());
}
if (bsrbidxdic.ContainsKey(tc, band_id_key))
{
bsrbidx = bsrbidxdic[tc, band_id_key];
}
else
{
lg.cri(String.Format("Missing ID for BS: {0} and RB : {1}", tc, band_id_key));
lg.deb(bsrbidxdic.ToString());
}
string picsbs = frm.band_vs_icesupport[band_id_key];
if (spec == "36.521-1")
{
//if ((tc_band_sheet[tc, band_id_key] == "LTE_ UL_CA") || ((tc_band_sheet[tc, band_id_key] == "64QAM")))
string desc = tc_des[tc].ToLower();
if (desc.Contains("64qam") || desc.Contains("dl ca and ul ca"))
{
string band_id_key_mod = band_id_key.ToUpper().Replace("CA_", "");
if (BandProcess.containstheword(icebandulca, band_id_key_mod))
{
picsbs = "S";
}
else
{
picsbs = "NS";
}
}
if (desc.Contains("x4") || desc.Contains("4 rx"))
{
string band_id_key_mod = band_id_key.ToUpper().Replace("CA_", "");
if (BandProcess.containstheword(ice4x4MIMO, band_id_key_mod))
{
picsbs = "S";
}
else
{
picsbs = "NS";
}
}
}
string map_str = String.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t", idpicsver, bsrbidx, picsrecoid, band_id_val, picsbs, picslogic);
GenericParser.writetocsv(file_picsmapping, map_str);
}
}
progress += progressinc * 0.1;
progressint = Convert.ToInt32(progress);
//lg.inf("progress: " + progress.ToString() + "t : " + DateTime.Now.ToString("h:mm:ss tt"));
frm.SetProgress(progressint);
dbobj.tablename = "user_picsmappingtable";
file_picsmapping = file_picsmapping.Replace(@"\", @"/");
frm.SetLabelstat(status + " uploading pics information to db");
dbobj.insertfile(file_picsmapping, String.Format("`{0}`,`{1}`,`{2}`,`{3}`,`{4}`,`{5}`", "id#pics", "id#bsrb", "id#picsstat", "id#v_comb_serv_info", "icebs", "PICSLogic"));
frm.SetLabelstat(status + " Uploading pics Complete");
}
else
{
lg.cri("{MainProcess} File Does not exist ! =>" + filenameTRL);
Debug.Print("File " + filenameTRL + " NOT found!");
frm.apendlog("File " + filenameTRL + " NOT found!", 1);
}
//////lg.inf("{MainProcess} TC (from db) vs App: RAW");
//////lg.inf("======================");
//////lg.inf(TCvsApp.ToString());
//////lg.deb("{MainProcess} TC (from db) vs App: FILTERED");
//////lg.deb("======================");
//////lg.deb(TCvsAppFiltered.ToString());
//////lg.cri("Band Support: Verification:");
//////lg.cri(TCBandSupport.ToString());
// End of the Loop:
}
progress = 100;
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
frm.SetLabelstat("Idle");
// END
}
// it returns a dictionary from a csv file with key and value column index passed.
public _Dictionary <string, string> getdictionaryRowCol(int val_id, int key_id = 0, string CSVName = "", bool remspacefrmkey = false)
{
lg.deb("FILE: " + CSVName);
_Dictionary <string, string> dictcsv = new _Dictionary <string, string>();
using (var fs = File.OpenRead(CSVName))
{
using (var reader = new StreamReader(fs))
{
while (!reader.EndOfStream)
{
_List <string> valTot = new _List <string>();
var line = reader.ReadLine();
if (line != "")
{
var values = line.Split('\t');
int colidx = 0;
foreach (string val in values)
{
string val2 = val.Replace("\"", "");
if ((colidx == key_id) && (remspacefrmkey))
{
val2 = val2.Replace(" ", "");
}
valTot.Add(val2);
colidx++;
}
string dctkey = valTot[key_id];
string fn = Path.GetFileName(CSVName);
if (fn.Contains("TVA"))
{
dctkey = dctkey.ToLower();
}
if ((values.Count() > val_id) && (values.Count() > key_id))
{
try
{
if (dictcsv.ContainsKey(dctkey))
{
lg.war("\t{gp:getdictionary} duplicate entry in " + CSVName + " " + valTot[key_id] + " " + valTot[val_id]);
}
else
{
dictcsv.Add(dctkey, valTot[val_id]);
}
}
catch
{
lg.err("\t{gp:getdictionary} " + valTot[key_id] + " \n\t\t\t" + valTot[val_id]);
}
}
else
{
//lg.war("{gp:getdictionary} "+ line);
if (values.Count() > key_id)
{
dictcsv.Add(dctkey, @"N/A");
}
}
}
}
}
}
return(dictcsv);
}
public void getalldictfromTRLfile(string CSVName, bool remspacefrmkey = false)
{
int key_id = 0;
int logic_id = 4;
int rel_id = 2;
int de_id = 3;
int pnemonic_id = 5;
lg.deb("TRL FILE: " + CSVName);
using (var fs = File.OpenRead(CSVName))
{
using (var reader = new StreamReader(fs))
{
while (!reader.EndOfStream)
{
_List <string> valTot = new _List <string>();
var line = reader.ReadLine();
if (line != "")
{
var values = line.Split('\t');
int colidx = 0;
foreach (string val in values)
{
string val2 = val.Replace("\"", "");
if ((colidx == key_id) && (remspacefrmkey))
{
val2 = val2.Replace(" ", "");
}
valTot.Add(val2);
colidx++;
}
string dctkey = valTot[key_id];
dctkey = dctkey.ToLower();
if (dctkey.Trim() == "")
{
continue;
}
if (values.Count() > 5)
{
try
{
if (dict_logic.ContainsKey(dctkey))
{
//lg.war("\t{gp:getdictionary} duplicate entry in " + CSVName + " " + valTot[key_id] + " " + valTot[logic_id]);
dict_logic[dctkey] = valTot[logic_id];
dict_de[dctkey] = valTot[de_id];
dict_rel[dctkey] = valTot[rel_id];
dict_pnemonic[dctkey] = valTot[pnemonic_id];
}
else
{
dict_logic.Add(dctkey, valTot[logic_id]);
dict_de.Add(dctkey, valTot[de_id]);
dict_rel.Add(dctkey, valTot[rel_id]);
dict_pnemonic.Add(dctkey, valTot[pnemonic_id]);
}
}
catch
{
lg.err("\t{gp:getdictionary} " + valTot[key_id] + " \n\t\t\t" + valTot[logic_id]);
}
}
else
{
lg.war("{gp:getdictionary} line has few elements " + line);
//if (values.Count() > key_id)
//{
// dict_logic.Add(dctkey, @"N/A");
//}
}
}
}
}
}
//List<_Dictionary<string, string>> alldict = new List<_Dictionary<string, string>>();
//alldict.Add(dict_logic);
//alldict.Add(dict_rel);
//alldict.Add(dict_pnemonic);
//alldict.Add(dict_de);
}
// public static string condSimple(string condVal, _Dictionary<string, string> pics_support)
// {
// // this method must return true or false only.
// string boolstr = condVal;
// string strPatt = @"if([(\bA\.\S+|\bB\.\S+|\bD\.\S+|\bG\.\S+|\bX\.\S+|AND|OR|NOT|\s+)]+)then\s+[roam]\s+else\s+n\/a";
// Match matchPartGr = Regex.Match(condVal, strPatt, RegexOptions.IgnoreCase);
// if (matchPartGr.Success)
// {
// boolstr = logicstrProcess(matchPartGr.Groups[1].ToString(), pics_support);
// }
// else
// {
// lgstr.err(" {condSimple} LogicalExprError: " + condVal);
// }
// lgstr.inf(" {condSimple} " + condVal + " => " + boolstr);
// return boolstr;
// }
public static string condCompl(string cstring, _Dictionary <string, string> c_logic_map, _Dictionary <string, string> pics_support)
{
//update c_logic map
//
string logicstring = c_logic_map[cstring];
//lgstr.deb("\t{condCompl} eval start for " + String.Format("[{0}] -> {1}", cstring,logicstring));
string outstr = "";
string condResRecur = "";
string condResRecur2 = "";
//Debug.Print(cstring);
//Debug.Print("xxxx: " + logicstring);
if (logicstring.ToLower() == "true")
{
outstr = "True";
}
else if (logicstring.ToLower() == "false")
{
outstr = "False";
}
else if ((logicstring.Trim().ToLower() == "void") || (logicstring.Trim().ToLower() == @"n/a") || (logicstring.Trim().ToLower().Contains("ffs")))
{
// lgstr.inf("Void Information: " + logicstring);
outstr = "False";
}
else
{
var regex = new Regex(@"(and|or|not)", RegexOptions.IgnoreCase);
logicstring = regex.Replace(logicstring, m => m.ToString().ToUpper());
//simple pattern need to correct
string pattSimple = @"^if(?:(?:\d+#\S+)|AND|OR|NOT|\(|\)|\s)+then\s+[RAM]\s+else\s+n\/a";
Match mcSimple = Regex.Match(logicstring, pattSimple, RegexOptions.IgnoreCase);
string pattMnemonic = @"if((?:(?:O_\S+)|AND|OR|NOT|\(|\)|\s)+)then";
Match mcMnemonic = Regex.Match(logicstring, pattMnemonic, RegexOptions.IgnoreCase);
//string pattMnemonic = @"if(?:(?:O_\S+)|AND|OR|NOT|\(|\)|\s)+then\s+[RAM]\s+else\s+n\/a";
//@"if\s*(.+)\s+then\s+o\s+else\s+(?:\()?(?:\s+)?if\s*(.+)\s+then(.+)"; //07-25-2017
string pattComplGen = @"if\s * (.+)\s + then\s + o\s +else\s + (?:\() ? (?:\s +)?if\s *\(?\s * (.+?)\s *\)?\s + then(.+)";
Match mcComplGen = Regex.Match(logicstring, pattComplGen, RegexOptions.IgnoreCase);
string pattComplCTPSExtra = @"if((?:(?:c\S+)|(?:\d+#\S+)|AND|OR|NOT|\(|\)|\s)+)then\s+[MORA]\s+else\s+n\/a";
Match mcComplCTPSxtra = Regex.Match(logicstring, pattComplCTPSExtra, RegexOptions.IgnoreCase);
if (mcSimple.Success)
{
//outstr = condSimple(logicstring, pics_support);
lgstr.inf("\t{condCompl} pattern mcComplGen # " + logicstring);
}
else if (mcComplGen.Success)
{
// if the logic string is a complex type
condResRecur = mcComplGen.Groups[1].ToString();
condResRecur2 = mcComplGen.Groups[2].ToString();
lgstr.inf("\t{condCompl} pattern mcComplGen # " + condResRecur + " # " + condResRecur2 + " # " + logicstring);
// After processing condResRecur, get true/false
if (condResRecur != "")
{
string pattIn = @"C(?:\%\d+\%)?[\w-_]+";
var mcIn = Regex.Matches(condResRecur, pattIn);
//string tempres ;
foreach (var mcInTemp in mcIn)
{
string tempres = c_logic_map[mcInTemp.ToString()];
lgstr.inf("\t{condCompl}" + condResRecur + " match: " + mcInTemp.ToString() + " 1stResult: " + tempres);
if ((tempres != "True") && (tempres != "False"))
{
lgstr.inf("\tRecursive call: " + mcInTemp.ToString());
tempres = condCompl(mcInTemp.ToString(), c_logic_map, pics_support);
}
condResRecur = condResRecur.Replace(mcInTemp.ToString(), tempres);
string boolstrverify = condResRecur.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match m = Regex.Match(boolstrverify, @"\w+");
if (!(m.Success))
{
lgstr.inf("\t{condCompl} part1Change1: " + condResRecur + " match: " + m.ToString());
if (tempres.Trim() != "")
{
condResRecur = evalBooleanExpr(tempres).ToString();
}
}
lgstr.inf("\t{condCompl} part1change2:" + condResRecur);
}
}
if (condResRecur.ToLower() == "true")
{
outstr = "True";
}
else if (condResRecur.ToLower() == "false")
{
//evaluate 2nd part
outstr = logicstrProcess(condResRecur2, pics_support);
}
else
{
//return the problematic string.
lgstr.cri("\t{condcompl} Improper Condition" + condResRecur);
outstr = condResRecur;
}
}
else if (mcComplCTPSxtra.Success)
{
condResRecur = mcComplCTPSxtra.Groups[1].ToString();
lgstr.inf("\t{condcompl} pattern mcComplCTPSxtra # " + condResRecur + " # " + logicstring);
if (condResRecur != "")
{
string pattIn = @"C(?:\%\d+\%)?[\w-_]+";
string pattItem = @"\d+#\b[AEG]\.\d[\d\-\/\.a-z]+\b";
var mcIn = Regex.Matches(condResRecur, pattIn);
var mcItem = Regex.Matches(condResRecur, pattItem);
foreach (var mcItemTemp in mcItem)
{
string tempres = convertToBoolExpr(pics_support, mcItemTemp.ToString());
//condResRecur = convertToBoolExpr(pics_support, condResRecur);
condResRecur = condResRecur.Replace(mcItemTemp.ToString(), tempres);
lgstr.inf("\t{condcompl} tempres: " + tempres + "#" + condResRecur);
//logicstring = convertToBoolExpr(pics_support, logicstring);
}
lgstr.inf("\t{condCompl} replace item with TF# " + condResRecur);
//c_logic_map[cstring] = logicstring;
//string tempres ;
foreach (var mcInTemp in mcIn)
{
lgstr.inf("\tregexmatch" + mcInTemp.ToString());
if (!c_logic_map.ContainsKey(mcInTemp.ToString()))
{
lgstr.inf(c_logic_map.ToString());
}
string tempres = c_logic_map[mcInTemp.ToString()];
lgstr.inf("\t{condCompl}" + condResRecur + "C match: " + mcInTemp.ToString() + " 1stResult: " + tempres);
if ((tempres != "True") && (tempres != "False"))
{
lgstr.inf("\trecursive call: " + mcInTemp.ToString());
tempres = condCompl(mcInTemp.ToString(), c_logic_map, pics_support);
}
condResRecur = condResRecur.Replace(mcInTemp.ToString(), tempres);
string boolstrverify = condResRecur.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match m = Regex.Match(boolstrverify, @"\w+");
if (!(m.Success))
{
lgstr.inf("\t{condCompl} part1Change1: " + condResRecur + " match: " + m.ToString());
if (tempres.Trim() != "")
{
condResRecur = evalBooleanExpr(tempres).ToString();
}
}
//lgstr.inf(" {condCompl} part1change2:" + condResRecur);
}
lgstr.inf("\t{condCompl} Final val TF# " + condResRecur);
outstr = condResRecur;
}
}
else if (mcMnemonic.Success)
{
condResRecur = mcMnemonic.Groups[1].ToString();
lgstr.inf("\t{condcompl} pattern mcMnemonic # " + condResRecur + " # " + logicstring);
if (condResRecur != "")
{
string patMnemonic = @"\bO_\S+\b";
var mcItem = Regex.Matches(condResRecur, patMnemonic);
Regex itemRegex = new Regex(patMnemonic, RegexOptions.IgnoreCase);
condResRecur = itemRegex.Replace(condResRecur, m => convertBoolHelper(m.ToString(), PICSmnemonicDic));
lgstr.inf("\t{condCompl} mnemonic replace item with TF# " + condResRecur);
string boolstrverify = condResRecur.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match mtmp = Regex.Match(boolstrverify, @"\w+");
if (!(mtmp.Success))
{
lgstr.inf("\t{condCompl} pnemonic: " + condResRecur + " match: " + mtmp.ToString());
if (condResRecur.Trim() != "")
{
condResRecur = evalBooleanExpr(condResRecur).ToString();
}
}
outstr = condResRecur;
}
lgstr.inf("\t{condCompl} final: " + condResRecur + " match: " + outstr);
}
else
{
lgstr.err("\t{condCompl} no matching pattern: " + logicstring);
outstr = "False";
}
}
// For End:
c_logic_map[cstring] = outstr;
return(outstr);
}