示例#1
0
        protected void gvTimeSheet_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            //Get the new Values.
            GridViewRow row              = gvTimeSheet.Rows[e.RowIndex];
            Label       lblWorkDate      = (Label)row.FindControl("lblWorkDate");
            Label       lblHours         = (Label)row.FindControl("lblHours");
            Label       lblPartnerHours  = (Label)row.FindControl("lblPartnerHours");
            TextBox     tbPartnerHours   = (TextBox)row.FindControl("tbPartnerHours");
            Label       lblOpportunityID = (Label)row.FindControl("lblOpportunityID");
            Label       lblStudentID     = (Label)row.FindControl("lblStudentID");

            // Code to update the DataSource.
            StudentTimeEntry Ste = new StudentTimeEntry();

            Ste.PartnerApprovedHours = Convert.ToInt32(tbPartnerHours.Text);
            Ste.OpportunityID        = Convert.ToInt32(Session["OpportunityID"]);
            Ste.StudentID            = Convert.ToInt32(Session["StudentID"]);
            Ste.WorkDate             = lblWorkDate.Text;

            Ste.UpdatePartnerHours();

            //Reset the edit index.
            gvTimeSheet.EditIndex = -1;
            //Bind data to the GridView control.
            DataBind();
        }
        public List <StudentTimeEntry> GetTimeEntries(int studentId, int opportunityId)
        {
            var reader = dbHelper.GetTimeEntries(Constant.SP_GetTimeEntries, studentId, opportunityId);

            List <StudentTimeEntry> studentTimeEntryList = new List <StudentTimeEntry>();
            StudentTimeEntry        studentTimeEntry     = null;

            while (reader.Read())
            {
                studentTimeEntry = new StudentTimeEntry();

                studentTimeEntry.WorkDate             = reader["WorkDate"].ToString();
                studentTimeEntry.HoursVolunteered     = Convert.ToInt32(reader["HoursVolunteered"]);
                studentTimeEntry.PartnerApprovedHours = Convert.ToInt32(reader["PartnerApprovedHours"]);
                studentTimeEntryList.Add(studentTimeEntry);
            }

            return(studentTimeEntryList);
        }
        private void DataBind()
        {
            int studentId     = Convert.ToInt32(Session["Student_StudentID"]);
            int opportunityId = Convert.ToInt32(Session["Student_SelectedOpportunityID"]);
            StudentTimeEntry        studentTimeEntry     = new StudentTimeEntry();
            List <StudentTimeEntry> studentTimeEntryList = studentTimeEntry.GetStudentTimeEntriesByOpportunityId(studentId, opportunityId);

            if (studentTimeEntryList.Count == 0)
            {
                StudentTimeEntry timeEntry = new StudentTimeEntry();
                studentTimeEntryList.Add(timeEntry);
                gvTimeEntry.DataSource = studentTimeEntryList;
                gvTimeEntry.DataBind();
                gvTimeEntry.Rows[0].Visible = false;
            }
            else
            {
                gvTimeEntry.DataSource = studentTimeEntryList;
                gvTimeEntry.DataBind();
            }
        }
示例#4
0
        public void DataBind()
        {
            // int OpportunityID = Convert.ToInt32(Session["OpportunityID"]);
            //int StudentID = Convert.ToInt32(Session["StudentID"]);
            //int CPPID = Convert.ToInt32(Session["CPPID"]);
            StudentTimeEntry        Ste  = new StudentTimeEntry();
            List <StudentTimeEntry> Lste = Ste.GetTimeEntries(12, 1);

            if (Lste.Count == 0)
            {
                StudentTimeEntry TimeEntry = new StudentTimeEntry();
                Lste.Add(TimeEntry);
                gvTimeSheet.DataSource = Lste;
                gvTimeSheet.DataBind();
                gvTimeSheet.Rows[0].Visible = false;
            }
            else
            {
                gvTimeSheet.DataSource = Lste;
            }
            gvTimeSheet.DataBind();
        }
        protected void validation()
        {
            if (tboxDateVolunteered.Text == "" || tboxHoursVolunteered.Text == "")
            {
                lblTimeEntryWarning.Text = "Please entry a date and volunteered hour(s)";
            }
            else
            {
                lblTimeEntryWarning.Text = "";

                StudentTimeEntry studentTimeEntry = new StudentTimeEntry();
                studentTimeEntry.WorkDate             = tboxDateVolunteered.Text;
                studentTimeEntry.OpportunityID        = Convert.ToInt32(Session["Student_SelectedOpportunityID"]);
                studentTimeEntry.StudentID            = Convert.ToInt32(Session["Student_StudentID"]);
                studentTimeEntry.CPPID                = 2;
                studentTimeEntry.PartnerApprovedHours = 0;
                studentTimeEntry.TimeEntryDate        = DateTime.Today.ToShortDateString();
                studentTimeEntry.HoursVolunteered     = Convert.ToInt32(tboxHoursVolunteered.Text);

                studentTimeEntry.SubmitStudentTimeEntry(studentTimeEntry);
            }
        }
 public void SubmitStudentTimeEntry(StudentTimeEntry studentTimeEntry)
 {
     dbHelper.SubmitStudentTimeEntry(Constant.SP_AddTimeEntries, studentTimeEntry.WorkDate, studentTimeEntry.OpportunityID, studentTimeEntry.StudentID,
                                     studentTimeEntry.CPPID, studentTimeEntry.PartnerApprovedHours, studentTimeEntry.TimeEntryDate, studentTimeEntry.HoursVolunteered);
 }