//public DataTable GetZerolevelProcess(PL_ApplicationProgress pl)
//{
// SqlCommand cmd = new SqlCommand("SPApplicationEntry", con);
// cmd.CommandType = CommandType.StoredProcedure;
// SqlDataAdapter ad = new SqlDataAdapter();
// DataTable dt = new DataTable();
// ad.Fill(dt);
// return dt;
//}
public DataTable GetZerolevelProcess(PL_ApplicationProgress pl)
{
SqlCommand cmd = new SqlCommand("SPApplicationEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ad = new SqlDataAdapter();
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
}
//for entry process
public DataSet GetEntryProcess(PL_ApplicationProgress pl)
{
DataSet ds = new DataSet();
try
{
SqlCommand cmd = new SqlCommand("SPApplicationEntry", con);
cmd.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
}
catch (Exception
ex) { msg = ex.Message; }
return(ds);
}
