protected void ddlYrmoList() { ImportDAL iobj = new ImportDAL(); string prevYRMO; for (int i = 0; i < 6; i++) { prevYRMO = iobj.getPrevYRMO(i); ddlYrmo.Items.Add(prevYRMO); } ddlYrmo.Items.Add("New Yrmo"); }
protected void ddlYrmoList() { ImportDAL iobj = new ImportDAL(); string prevYRMO, filterexp; for (int i = 0; i < 6; i++) { prevYRMO = iobj.getPrevYRMO(i); ddlYrmo.Items.Add(prevYRMO); } ddlYrmo.Items.Add("New Yrmo"); filterexp = "yrmo='" + ddlYrmo.SelectedItem.Text + "'"; SqlDataSourceAdj.FilterExpression = filterexp; }
DataSet ExecuteStoredProc(string spName, string yrmo, string plancode, string source) { SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); ds.Clear(); ImportDAL iobj = new ImportDAL(); command = new SqlCommand(spName, connect); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@yrmo", SqlDbType.VarChar).Value = yrmo; command.Parameters.Add("@plancode", SqlDbType.VarChar).Value = plancode; if (source.Equals("ADJ") || source.Equals("COBDET")) { command.Parameters.Add("@prevyrmo", SqlDbType.VarChar).Value = iobj.getPrevYRMO(yrmo); } da.SelectCommand = command; da.Fill(ds); command.Dispose(); return(ds); }
public static int importADPDetail(string _yrmo, string _fileName) { string _Reportyrmo = null; int _count = 0; int _recCount = 0; string line = string.Empty; string _PatternDate = @"(?<month>\d{1,2})\/(?<year>\d{4})[ \t]*\*(All Plans)"; TextReader reader = new StreamReader(File.OpenRead(_fileName)); Regex r = new Regex(_PatternDate); ImportDAL iobj = new ImportDAL(); string _prevyrmo = iobj.getPrevYRMO(_yrmo); DataSet dsADP = new DataSet(); dsADP.Clear(); try { while ((line = reader.ReadLine()) != null && _count == 0) { Match parsed = Regex.Match(line, _PatternDate); if (parsed.Success) { string _pyear = parsed.Groups["year"].Value.ToString(); int _pmonth = Int32.Parse(parsed.Groups["month"].Value.ToString()); string _monthnew; if (_pmonth < 10) { _monthnew = "0" + Convert.ToString(_pmonth); } else { _monthnew = Convert.ToString(_pmonth); } _Reportyrmo = _pyear + _monthnew; _count++; } } if (_Reportyrmo.Equals(_prevyrmo)) { dsADP = parseADPDetails(_fileName, _prevyrmo); _recCount = IPBAImportDAL.insertADP(dsADP, _yrmo); } else { throw (new Exception("YRMO entered doesnt match with Report, Please check the Report.")); } } catch (Exception ex) { throw ex; } finally { reader.Close(); } return(_recCount); }