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);
}
