protected void Button1_Click(object sender, EventArgs e)
{
filter.Service fil = new filter.Service();
gv.DataSource = fil.GetStud(GlobalData.sKey, sy.Text, term.Text);
gv.DataBind();
BIZenrollee db = new BIZenrollee();
Session.Clear();
DataTable forward;
if (Session["ToDB"] == null)
{
forward = new DataTable("ToDB");
forward.Columns.Add("SchoolYearTermsID");
forward.Columns.Add("StudentID");
forward.Columns.Add("DegreeProgramID");
forward.Columns.Add("YearLevelID");
}
else
{
forward = (DataTable)Session["ToDB"];
}
for (int i = 0; i < gv.Rows.Count; i++)
{
DataRow drwForward = forward.NewRow();
string schyr = gv.Rows[i].Cells[1].Text;
string Term = gv.Rows[i].Cells[2].Text;
string degree = gv.Rows[i].Cells[3].Text;
string school = gv.Rows[i].Cells[4].Text;
int yrlvl = 1;
int StudId = int.Parse(gv.Rows[i].Cells[0].Text);
drwForward["SchoolYearTermsID"] = db.setSyTerm(schyr, Term);
drwForward["StudentID"] = gv.Rows[i].Cells[0].Text;
drwForward["DegreeProgramID"] = db.setDegree(school, degree);
drwForward["YearLevelID"] = yrlvl;
forward.Rows.Add(drwForward);
GlobalData.totalRec = gv.Rows.Count;
}
Session.Add("ToDB", forward);
gv.DataSource = forward;
gv.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
filter.Service fil = new filter.Service();
Session.Clear();
numRows.Text = "";
Label2.Text = "";
stud.DataSource = fil.GetBatch(GlobalData.bKey, tb1.Text);
stud.DataBind();
numRows.Text = stud.Rows.Count.ToString();
//dtb values
int cStatusID;
int religionID;
int cityID;
int ethID;
int studID = 0;;
string fname = "";
string mname = "";
string lname = "";
int hsID = 1;
string sex = "";
int scholarshipID = 1;
string strAddress = "";
//filter.Service fil = new filter.Service();
DataTable forward;
BIZ db = new BIZ();
Label2.Text = "";
if (Session["ToDB"] == null)
{
forward = new DataTable("ToDB");
// forward.Columns.Add("Batch");
forward.Columns.Add("Idno");
forward.Columns.Add("Fname");
forward.Columns.Add("Mname");
forward.Columns.Add("Lname");
forward.Columns.Add("Studtypein");
forward.Columns.Add("HighschoolID");
forward.Columns.Add("Sex");
forward.Columns.Add("ScholarshipID");
forward.Columns.Add("Religion");
forward.Columns.Add("Ethnicity");
forward.Columns.Add("Nostreet");
forward.Columns.Add("CityProv");
}
else
{
forward = (DataTable)Session["ToDB"];
}
for (int i = 0; i < stud.Rows.Count; i++)
{
int k = int.Parse(stud.Rows[i].Cells[1].Text);
int p = db.checkid(int.Parse(stud.Rows[i].Cells[1].Text));
DataRow drwForward = forward.NewRow();
drwForward["Idno"] = stud.Rows[i].Cells[1].Text;
studID = int.Parse(stud.Rows[i].Cells[1].Text);
drwForward["Fname"] = stud.Rows[i].Cells[2].Text;
fname = stud.Rows[i].Cells[2].Text;
drwForward["Mname"] = stud.Rows[i].Cells[4].Text;
mname = stud.Rows[i].Cells[4].Text;
drwForward["Lname"] = stud.Rows[i].Cells[3].Text;
lname = stud.Rows[i].Cells[3].Text;
drwForward["Studtypein"] = db.getcStatusID(stud.Rows[i].Cells[9].Text);
cStatusID = db.getcStatusID(stud.Rows[i].Cells[9].Text);
drwForward["HighSchoolID"] = 1;
hsID = 1;
drwForward["Sex"] = stud.Rows[i].Cells[6].Text;
sex = stud.Rows[i].Cells[6].Text;
drwForward["ScholarshipID"] = 1;
scholarshipID = 1;
drwForward["Religion"] = db.getRelID(stud.Rows[i].Cells[8].Text.ToUpper());
religionID = db.getRelID(stud.Rows[i].Cells[8].Text.ToUpper());
drwForward["Ethnicity"] = db.getethID(stud.Rows[i].Cells[5].Text);
ethID = db.getethID(stud.Rows[i].Cells[5].Text);
drwForward["Nostreet"] = stud.Rows[i].Cells[15].Text;
strAddress = stud.Rows[i].Cells[15].Text;
drwForward["CityProv"] = db.getCity(stud.Rows[i].Cells[16].Text, stud.Rows[i].Cells[17].Text);
cityID = db.getCity(stud.Rows[i].Cells[16].Text, stud.Rows[i].Cells[17].Text);
forward.Rows.Add(drwForward);
}
Session.Add("ToDB", forward);
stud.DataSource = forward;
stud.DataBind();
Label2.Text = forward.Rows.Count.ToString();
GlobalData.totalRec = int.Parse(Label2.Text);
}