protected void EmployeeView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
try
{
EmployeeView.PageIndex = e.NewPageIndex;
EmployeeView.DataSource = Brentwood.ListEmployees();
EmployeeView.DataBind();
if (AdminCheckbox.Checked)
RolesList.Visible = false;
else
RolesList.Visible = true;
}
catch (Exception ex)
{
FormMessage.Text = ex.Message;
FormMessage.ForeColor = Color.Red;
}
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsView1.PageIndex = e.NewPageIndex;
mstudent.select();
}
/*protected void btnClockin_Click(object sender, EventArgs e)
{
string clockinDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm tt");
//SqlDataSource2.UpdateParameters["Clock_In"].DefaultValue = clockinDate;
SqlDataSource2.UpdateParameters.Add("clockinDate", clockinDate);
SqlDataSource2.UpdateCommand = "UPDATE Volunteer SET Clock_In =@clockinDate, Volunteers_Worked = @Volunteers_Worked FROM Volunteer INNER JOIN Shift ON Volunteer.Shift_ID = Shift.Shift_ID INNER JOIN Entity ON Volunteer.Entity_ID = Entity.Entity_ID INNER JOIN Entity AS Entity_1 ON Volunteer.Entity_ID = Entity_1.Entity_ID";
SqlDataSource2.Update();
Panel1.Visible = false;
Panel2.Visible = true;
}*/
protected void dtlOrg_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
string clockinDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm tt");
SqlConnection beansdbconnection;
// connection created
beansdbconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Beans_DB_v5ConnectionString"].ToString());
dtlOrg.DataSource = beansdbconnection;
dtlOrg.DataBind();
try
{
beansdbconnection.Open();
// data adapter
SqlDataAdapter bnsdataAdapter = new SqlDataAdapter();
bnsdataAdapter.SelectCommand = new SqlCommand("SELECT Entity.Entity_Organization_Name," +
"Volunteer.Volunteers_Scheduled, Volunteer.Volunteers_Worked, Shift.Shift_Name," +
"Shift.Shift_Date FROM Shift INNER JOIN Volunteer ON Shift.Shift_ID = Volunteer.Shift_ID" +
"INNER JOIN Entity ON Volunteer.Entity_ID = Entity.Entity_ID WHERE" +
"Entity.Entity_ID=@Entity_ID AND Entity.Entity_Organization_Name IS NOT NULL", beansdbconnection);
// dataset
DataSet bnsdataSet = new DataSet();
bnsdataAdapter.Fill(bnsdataSet, "Volunteer");
//data table reference
DataTable bnsdataTable = bnsdataSet.Tables["Volunteer"];
// clock-in command (UPDATE)
SqlCommand cmdClockin = new SqlCommand("UPDATE Volunteer" +
"SET Entity_ID = @EntID, Shift_ID = @ShiftID," +
"Clock_IN = @clockIn, Volunteers_Worked = @VolWorked", beansdbconnection);
cmdClockin.Parameters.Add("@EntID", SqlDbType.Int, 4, "Entity_ID");
cmdClockin.Parameters.Add("@ShiftID", SqlDbType.Int, 4, "Shift_ID");
cmdClockin.Parameters.Add("@clockIn", SqlDbType.Time, 5, "Clock_In");
cmdClockin.Parameters.Add("@VolWorked", SqlDbType.Int, 10, "Volunteers_Worked");
cmdClockin.Parameters["@clockIn"].Value = clockinDate;
bnsdataAdapter.UpdateCommand = cmdClockin;
bnsdataAdapter.Update(bnsdataSet, "Volunteer");
}
catch
{
Response.Write("Could Not Update Database");
}
finally
{
beansdbconnection.Close();
}
/*try
{
beansdbconnection.Open();
//Response.Write("Connection is open!!!");
cmdSchedule.Parameters["@EntID"].Value = EntID;
cmdSchedule.Parameters["@ShiftID"].Value = ShiftID;
cmdSchedule.Parameters["@CommServ"].Value = CommServ;
cmdSchedule.Parameters["@isClient"].Value = isClient;
cmdSchedule.ExecuteNonQuery();
}
catch
{
Response.Write("Could Not Open Database");
}
finally
{
beansdbconnection.Close();
//Response.Write("Connection is now closed");
}
//SqlDataSource2.UpdateParameters.Add("clockinDate", clockinDate);
SqlDataSource2.UpdateParameters["@Clock_In"].DefaultValue = clockinDate;
SqlDataSource2.UpdateCommand = "UPDATE SET Entity_ID= @Entity_ID, Shift_ID=@Shift_ID, Clock-In=@Clock_In, Volunteers_Worked=@Volunteers_Worked";
SqlDataSource2.UpdateCommand = "UPDATE Volunteer SET Clock_In =@clockinDate AND" +
"Volunteers_Worked = @Volunteers_Worked FROM Volunteer INNER JOIN Shift" +
"ON Volunteer.Shift_ID = Shift.Shift_ID INNER JOIN Entity ON Volunteer.Entity_ID = Entity.Entity_ID" +
"INNER JOIN Entity AS Entity_1 ON Volunteer.Entity_ID = Entity_1.Entity_ID";*/
SqlDataSource2.Update();
Panel1.Visible = false;
Panel2.Visible = true;
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DetailsView_search_book_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
bookGridView.DataBind();
}
protected void detailsTrophy_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
CentralLibrary.SyncGridView(ref gridTrophy, detailsTrophy);
}
protected void consumeRecordDetailsView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DetailsView2_PageIndexChanging1(object sender, DetailsViewPageEventArgs e)
{
}
protected void SubmitCustomerList_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
dtList.PageIndex = e.NewPageIndex;
dtList.DataBind();
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
dtlProduct.PageIndex = e.NewPageIndex;
dtlProduct.DataBind();
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsView1.PageIndex = e.NewPageIndex;
mstudent.select();
}
protected void detailsScoreMethod_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
CentralLibrary.SyncGridView(ref gridScoreMethod, detailsScoreMethod);
}
protected void DetailsViewTeacherInfo_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsViewTeacherInfo.PageIndex = e.NewPageIndex;
DetailsViewTeacherInfo.DataBind();
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsView1.PageIndex = e.NewPageIndex;
BookingID = GridView1.SelectedValue.ToString();
BindDetailsView(BookingID);
}
/// <summary>
/// Handles the Page index change event.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
dvRegistrations.PageIndex = e.NewPageIndex;
GetRecords();
}
protected void dvAviso_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void CustAdmin_DetailsView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void dvOrderEdit_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void uxMuestraCliente_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
XmlDocument xdoc = Properties_xml.GetXmlDocument();
XmlDataSource1.XPath = "owners/owner[@land_register_number=" + xdoc.DocumentElement.ChildNodes[e.NewPageIndex].Attributes["land_register_number"].Value + "]";
}
protected void detailsBoat_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
CentralLibrary.SyncGridView(ref gridBoats, detailsBoat);
}
protected void dvPackage_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
dvPackage.PageIndex = e.NewPageIndex;
BindCustDetails();
}
//protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
////{
//// int id = DataAccess.getval("SELECT CategoryID FROM Category where CategoryName ='" + DropDownList1.Text.ToString() + "'");
//// Label3.Text = id.ToString();
//// GridView1.SelectedRow.Cells[4].Text = Label3.Text;
//}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
GridView1.Visible = true;
//Master.ErrorMessage = DataAccess.Error;
}
protected void detailsView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
detailsView.PageIndex = e.NewPageIndex;
this.BindData();
}
protected void dvAddProduct_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DVPhysicalDetail_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void CustomerView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
try
{
CustomerView.PageIndex = e.NewPageIndex;
List<ListCustomers_Result> data = Brentwood.ListCustomers();
CustomerView.DataSource = data;
CustomerView.DataBind();
}
catch (Exception ex)
{
FormMessage.ForeColor = Color.Red;
FormMessage.Text = ex.Message;
}
}
protected void AddSubjectArea_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsView1.PageIndex = e.NewPageIndex;
BindDetailsView();
}
/// <summary>
/// 获取绑定分页控件对应控件的翻页事件Args
/// </summary>
/// <param name="controlMode"></param>
/// <param name="eventName"></param>
/// <param name="commandSource"></param>
/// <param name="newPageIndex"></param>
/// <returns></returns>
/// <remarks>
/// 获取绑定分页控件对应控件的翻页事件Args
/// </remarks>
public object GetPageEventArgs(DataListControlType controlMode, string eventName, object commandSource, int newPageIndex)
{
object obj = null;
switch (controlMode)
{
case DataListControlType.GridView:
switch (eventName)
{
case "EventPageIndexChanged":
EventArgs gvEventArgs = new EventArgs();
obj = (object)gvEventArgs;
break;
case "EventPageIndexChanging":
GridViewPageEventArgs gridViewEventArgs = new GridViewPageEventArgs(newPageIndex);
obj = (object)gridViewEventArgs;
break;
}
break;
case DataListControlType.DeluxeGrid:
switch (eventName)
{
case "EventPageIndexChanged":
EventArgs gvEventArgs = new EventArgs();
obj = (object)gvEventArgs;
break;
case "EventPageIndexChanging":
GridViewPageEventArgs gridViewEventArgs = new GridViewPageEventArgs(newPageIndex);
obj = (object)gridViewEventArgs;
break;
}
break;
case DataListControlType.DetailsView:
//DetailsViewPageEventArgs detailsViewEventArgs = new DetailsViewPageEventArgs(newPageIndex);
//obj = (object)detailsViewEventArgs;
switch (eventName)
{
case "EventPageIndexChanged":
EventArgs detailsViewEventArgs = new EventArgs();
obj = (object)detailsViewEventArgs;
break;
case "EventPageIndexChanging":
DetailsViewPageEventArgs dvEventArgs = new DetailsViewPageEventArgs(newPageIndex);
obj = (object)dvEventArgs;
break;
}
break;
case DataListControlType.FormView:
//DetailsViewPageEventArgs detailsViewEventArgs = new DetailsViewPageEventArgs(newPageIndex);
//obj = (object)detailsViewEventArgs;
switch (eventName)
{
case "EventPageIndexChanged":
EventArgs formViewEventArgs = new EventArgs();
obj = (object)formViewEventArgs;
break;
case "EventPageIndexChanging":
FormViewPageEventArgs fvEventArgs = new FormViewPageEventArgs(newPageIndex);
obj = (object)fvEventArgs;
break;
}
break;
case DataListControlType.DataGrid:
DataGridPageChangedEventArgs dataGridEventArgs = new DataGridPageChangedEventArgs(commandSource, newPageIndex);
obj = (object)dataGridEventArgs;
break;
}
return(obj);
}
protected void detailsFleetSeries_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
CentralLibrary.SyncGridView(ref gridFleetSeries, detailsFleetSeries);
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsView1.PageIndex = e.NewPageIndex;
BindDetail();
}
protected void MembershipUserDetailsView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void dview_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
dview.PageIndex = e.NewPageIndex;
dview.DataBind();
}
protected void DetailsView2_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
Response.Redirect("Login.aspx"); //String is redirected here
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsView1.PageIndex = e.NewPageIndex;
DetailsView1.DataSource = errList;
DetailsView1.DataBind();
}
protected void consumeRecordDetailsView_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DetailsView1_PageIndexChanging1(object sender, DetailsViewPageEventArgs e)
{
//add_trip_info info = new add_trip_info();
//add_trip_sp sp = new add_trip_sp();
//sp.Update(info);
}
protected void uxMuestraDireccion_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
protected void DetailsViewExample_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
DetailsViewExample.PageIndex = e.NewPageIndex;
bindDetailtView();
}