private IList <ImportQVariableData> GetDataRow(DataSet ds) { DataRepository.CloseSession(); int rowno = 0; IList <ImportQVariableData> rdlist = new List <ImportQVariableData>(); double usagerate; _modifiedQuantifyMenus = new Dictionary <int, QuantifyMenu>(); _listofQmenus = null; foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; if (!DatarowValueToDouble(dr[1], out usagerate)) { usagerate = 1; } ImportQVariableData rd = new ImportQVariableData(Convert.ToString(dr[0]), usagerate, Convert.ToString(dr[2]), Convert.ToString(dr[3]), rowno); rdlist.Add(rd); } foreach (ImportQVariableData rd in rdlist) { if (!string.IsNullOrEmpty(rd.ProductName)) { rd.Product = DataRepository.GetProductByName(rd.ProductName); if (rd.Product != null) { if (!string.IsNullOrEmpty(rd.QuantifyMenu)) { QuantifyMenu qm = GetQuantifyMenuByTitle(rd.QuantifyMenu); if (qm != null) { if (qm.IsProductSelected(rd.Product.Id)) { rd.IsExist = true; rd.ErrorDescription = "Already this quantification variable is existed"; } else { QuantificationMetric qmetric = new QuantificationMetric(); qmetric.ClassOfTest = qm.ClassOfTest; qmetric.CollectionSupplieAppliedTo = rd.AppliedTo; qmetric.Product = rd.Product; qmetric.QuantifyMenu = qm; qmetric.UsageRate = rd.UsageRate; qm.QuantificationMetrics.Add(qmetric); AddModifiedQMenu(qm); } } else { rd.HasError = true; rd.ErrorDescription = "Error: unable to found Quantification variable"; } } else { rd.HasError = true; rd.ErrorDescription = "Error: Quantify according to is empty"; } } else { rd.HasError = true;; rd.ErrorDescription = "Error: unable to found a Product"; } } else { rd.HasError = true; rd.ErrorDescription = "Error: Product name is empty"; } } return(rdlist); }
private IList<ImportQVariableData> GetDataRow(DataSet ds) { DataRepository.CloseSession(); int rowno = 0; IList<ImportQVariableData> rdlist = new List<ImportQVariableData>(); double usagerate; _modifiedQuantifyMenus = new Dictionary<int, QuantifyMenu>(); _listofQmenus = null; foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; if (!DatarowValueToDouble(dr[1], out usagerate)) usagerate = 1; ImportQVariableData rd = new ImportQVariableData(Convert.ToString(dr[0]), usagerate, Convert.ToString(dr[2]), Convert.ToString(dr[3]), rowno); rdlist.Add(rd); } foreach (ImportQVariableData rd in rdlist) { if (!string.IsNullOrEmpty(rd.ProductName)) { rd.Product = DataRepository.GetProductByName(rd.ProductName); if (rd.Product != null) { if (!string.IsNullOrEmpty(rd.QuantifyMenu)) { QuantifyMenu qm = GetQuantifyMenuByTitle(rd.QuantifyMenu); if (qm != null) { if (qm.IsProductSelected(rd.Product.Id)) { rd.IsExist = true; rd.ErrorDescription = "Already this quantification variable is existed"; } else { QuantificationMetric qmetric = new QuantificationMetric(); qmetric.ClassOfTest = qm.ClassOfTest; qmetric.CollectionSupplieAppliedTo = rd.AppliedTo; qmetric.Product = rd.Product; qmetric.QuantifyMenu = qm; qmetric.UsageRate = rd.UsageRate; qm.QuantificationMetrics.Add(qmetric); AddModifiedQMenu(qm); } } else { rd.HasError = true; rd.ErrorDescription = "Error: unable to found Quantification variable"; } } else { rd.HasError = true; rd.ErrorDescription = "Error: Quantify according to is empty"; } } else { rd.HasError = true; ; rd.ErrorDescription = "Error: unable to found a Product"; } } else { rd.HasError = true; rd.ErrorDescription = "Error: Product name is empty"; } } return rdlist; }