Exemple #1
0
        //protected void Button2_Click(object sender, EventArgs e)
        //{
        //    //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);
        //}

        protected void Button3_Click(object sender, EventArgs e)
        {
            GlobalData.batch = tb1.Text;
            BIZ       plus    = new BIZ();
            DataTable forward = (DataTable)Session["ToDB"];

            //Add.AddStudBatch(forward);
            plus.Add(forward);
            msg.Text = "Records from batch: " + tb1.Text + "has been added to the database";
            Session.Clear();
            Response.Redirect("AfterAdd.aspx");
        }
Exemple #2
0
        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);
        }