protected void Button2_Click(object sender, EventArgs e)
{
obj.SelectMethod = "SelectInstructorSalary";
obj.SelectParameters.Clear();
obj.Select();
GridView1.DataSource = obj;
GridView1.DataBind();
}
protected void Button_SelectAll_Click(object sender, EventArgs e)
{
obj.SelectMethod = "SelectAllDepartments";
obj.SelectParameters.Clear();
obj.Select();
GridView1.DataSource = obj;
GridView1.DataBind();
}
private void rowForGridService(string gv, string ods, string viewState, string[] col)
{
DataTable dt = new DataTable();
DataTable dtNew = new DataTable();
DataRow drCurrentRow = null;
foreach (string oneCol in col)
{
dtNew.Columns.Add(new DataColumn(oneCol, typeof(string)));
}
GridView GV = (GridView)contactDV.FindControl(gv);
ObjectDataSource ODS = (ObjectDataSource)contactDV.FindControl(ods);
dt = ((DataView)ODS.Select()).ToTable();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
drCurrentRow = dtNew.NewRow();
foreach (string oneCol in col)
{
drCurrentRow[oneCol] = dt.Rows[i][oneCol];
}
dtNew.Rows.Add(drCurrentRow);
}
}
ViewState[viewState] = dt;
GV.DataSource = dt;
GV.DataBind();
}
public object FindControl(Page page, string id)
{
Control found = page.FindControl(id);
if (found == null)
{
found = FindControlExtend(id, page.Controls);
}
if (page.Session[this.DataSourceId + "combo" + GetFileName(page)] == null)
{
object s = found as ObjectDataSource;
if (s == null)
{
s = found as SqlDataSource;
SqlDataSource sqlD = (SqlDataSource)s;
DataView dv = (DataView)sqlD.Select(DataSourceSelectArguments.Empty);
page.Session[this.DataSourceId + "combo" + GetFileName(page)] = dv;
}
else
{
ObjectDataSource objD = (ObjectDataSource)s;
page.Session[this.DataSourceId + "combo" + GetFileName(page)] = objD.Select();
}
}
return(page.Session[this.DataSourceId + "combo" + GetFileName(page)]);
}
protected void DropDownList_Role_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList_Role.SelectedIndex == 0)
{
obj = new ObjectDataSource();
obj.TypeName = "StudentLayer";
obj.SelectMethod = "SelectStudentsIdAndName";
obj.Select();
DropDownList_Names.DataSource = obj;
DropDownList_Names.DataValueField = "St_Id";
DropDownList_Names.DataTextField = "St_Name";
DropDownList_Names.DataBind();
}
else if (DropDownList_Role.SelectedIndex == 1)
{
obj = new ObjectDataSource();
obj.TypeName = "InstructorLayer";
obj.SelectMethod = "SelectInstructorIdAndName";
obj.Select();
DropDownList_Names.DataSource = obj;
DropDownList_Names.DataValueField = "Ins_Id";
DropDownList_Names.DataTextField = "Ins_Name";
DropDownList_Names.DataBind();
}
}
static object GetSelectQueryResult(ObjectDataSource ds, string method, string param, string value)
{
ds.SelectParameters.Clear();
ds.SelectMethod = method;
ds.SelectParameters.Add(param, value);
return(ds.Select());
}
/// <summary>
/// Chooses uses DataSource type and set items style
/// </summary>
void SetItemsStyleFromODS(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.DataCheckField) && string.IsNullOrEmpty(this.ForeColorField) && string.IsNullOrEmpty(this.ToolTipField))
{
return;
}
// Независимо от IsPostBack надо сделать Select - DataBind может быть и на IsPostBack
object dataSource = FindDataSource;
if (dataSource == null)
{
return;
}
Dictionary <int, string[]> itemsStates = new Dictionary <int, string[]>();
if (dataSource is SqlDataSource)
{
SqlDataSource sqlDa = dataSource as SqlDataSource;
DataView dataItems = sqlDa.Select(new DataSourceSelectArguments(base.DataValueField)) as DataView;
if (dataItems == null)
{
return;
}
SetItemsStyleFromODS_Internal(itemsStates, dataItems, (di, i) => ((DataView)di).Table.Rows[i], (di, name) => ((DataRow)di)[name]);
}
else if (dataSource is ObjectDataSource)
{
ObjectDataSource ods = dataSource as ObjectDataSource;
object[] dataItems = ods.Select().Cast <object>().ToArray();
if (dataItems == null || dataItems.Length == 0)
{
return;
}
SetItemsStyleFromODS_Internal(itemsStates, dataItems, (di, i) => ((object[])di)[i], (di, name) => di.GetType().InvokeMember(name, BindingFlags.GetProperty, null, di, null));
}
else if (dataSource is IEnumerable)
{
dataSource = ((IEnumerable)dataSource).Cast <object>().ToList();
SetItemsStyleFromODS_Internal(itemsStates, dataSource, (di, i) => ((IList <object>)di)[i], (di, name) => di.GetType().InvokeMember(name, BindingFlags.GetProperty, null, di, null));
}
else
{
throw new Exception(string.Format("CheckBoxListEx: such dataSource is not supported, {0}", dataSource));
}
if (itemsStates != null && itemsStates.Count > 0)
{
ViewState[ViewStateStateName] = itemsStates;
}
}
public static bool IsPagerVisible(DataPager dPager, ObjectDataSource objDataSrc)
{
bool isVisible = false;
DataView dv = (DataView)objDataSrc.Select();
isVisible = (dv.Count > dPager.PageSize);
// dPager.Visible = isPagerVisible;
return(isVisible);
}
private void SetDdlStateDataSource()
{
var ods = new ObjectDataSource("FlyerMe.StatesBLL", "GetStates")
{
OldValuesParameterFormatString = "original_{0}"
};
ddlState.DataSource = ods.Select();
ddlState.DataBind();
}
private DataSet GetODS_DS(ObjectDataSource ods)
{
dynamic ds = new DataSet();
dynamic dv = (DataView)ods.Select();
if (dv != null && dv.Count > 0)
{
dynamic dt = dv.ToTable();
ds.Tables.Add(dt);
}
return(ds);
}
void cbo_DataBinding(object sender, EventArgs e)
{
cbo.Items.Clear();
IList <iSabaya.NameAffix> listAffix = (IList <iSabaya.NameAffix>)ods.Select();
for (int i = 0; i < listAffix.Count; i++)
{
cbo.Items.Add(listAffix[i].Affix.ToString(base.LanguageCode), listAffix[i].AffixID);
}
cbo.Items.Add("อื่นๆ", 0);
cbo.SelectedIndex = 0;
}
private void SetPricesListDataSource()
{
var key = String.Format("PricesListDataSource_{0}&{1}&{2}", filter.State, filter.Market, filter.Flyer);
pricesListDataSource = cache[key] as DataView;
if (pricesListDataSource == null)
{
marketObjectDataSource = new ObjectDataSource();
marketObjectDataSource.ID = "MarketObjectDataSource";
marketObjectDataSource.OldValuesParameterFormatString = "original_{0}";
marketObjectDataSource.SelectMethod = "GetMarketList";
marketObjectDataSource.TypeName = "FlyerMe.FlyerBLL";
var hfState = new HiddenField()
{
ID = "hfState",
Value = view.State,
Visible = false
};
var hfMarket = new HiddenField()
{
ID = "hfMarket",
Value = filter.GetSelectedMarket(filter.Market),
Visible = false
};
var hfFlyer = new HiddenField()
{
ID = "hfFlyer",
Value = filter.GetSelectedFlyer(filter.Flyer),
Visible = false
};
var p1 = new ControlParameter("stateID", "hfState", "Value");
var p2 = new ControlParameter("markettype", "hfMarket", "Value");
var p3 = new ControlParameter("flyerType", "hfFlyer", "Value");
marketObjectDataSource.SelectParameters.Add(p1);
marketObjectDataSource.SelectParameters.Add(p2);
marketObjectDataSource.SelectParameters.Add(p3);
view.AddControl(marketObjectDataSource);
view.AddControl(hfState);
view.AddControl(hfMarket);
view.AddControl(hfFlyer);
pricesListDataSource = marketObjectDataSource.Select() as DataView;
cache.Add(key, pricesListDataSource, null, DateTime.Now.Add(new TimeSpan(0, 5, 0)), default(TimeSpan), CacheItemPriority.Normal, null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
obj = new ObjectDataSource();
obj.TypeName = "CourseBL";
obj.SelectMethod = "SelectAllCourses";
obj.Select();
GridView1.DataSource = obj;
GridView1.DataBind();
Session.Add("obj", obj);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Role"].ToString() != "Admin")
{
Response.Redirect("../Anonymous/ErrorPage.aspx");
}
obj = new ObjectDataSource();
obj.TypeName = "InstructorLayer";
obj.SelectMethod = "SelectInstructorSalary";
obj.SelectParameters.Clear();
obj.Select();
GridView1.DataSource = obj;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
obj = new ObjectDataSource();
obj.TypeName = "ReportsBusinessLayer";
obj.SelectMethod = "selectAllDepartments";
obj.Select();
DropDownList1.DataSource = obj;
DropDownList1.DataTextField = "Dept_name";
DropDownList1.DataValueField = "Dept_id";
DropDownList1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
OrdenCompra orden = new OrdenCompra();
ObjectDataSource grid1 = ObjectDataSource1;
IEnumerable <Disco> lista1 = (IEnumerable <Disco>)grid1.Select();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
CheckBox check = row.FindControl("Select") as CheckBox;
if (check.Checked)
{
Disco aux = lista1.ElementAt(i);
orden.AgregarDisaco(aux);
}
}
ObjectDataSource grid2 = ObjectDataSource2;
IEnumerable <Cancion> lista2 = (IEnumerable <Cancion>)grid2.Select();
for (int i = 0; i < GridView2.Rows.Count; i++)
{
GridViewRow row = GridView2.Rows[i];
CheckBox check = row.FindControl("Select") as CheckBox;
if (check.Checked)
{
Cancion aux = lista2.ElementAt(i);
orden.AgregarDisaco(aux);
}
}
if (user != null)
{
Session["orden"] = orden;
Server.Transfer("/Pagos.aspx");
}
else
{
Session["orden"] = orden;
Server.Transfer("Account/Login.aspx");
}
}
public override void DataBind()
{
if (_dsCtrl != null)
{
System.Collections.IEnumerator ie = null;
if (_dsCtrl is SqlDataSource)
{
SqlDataSource sqlDs = (SqlDataSource)_dsCtrl;
ie = sqlDs.Select(new DataSourceSelectArguments()).GetEnumerator();
}
if (_dsCtrl is ObjectDataSource)
{
ObjectDataSource objDs = (ObjectDataSource)_dsCtrl;
ie = objDs.Select().GetEnumerator();
}
if (ie != null && _tblUploadedFiles != null && _params != null)
{
while (ie.MoveNext())
{
if (ie.Current is System.Data.DataRowView)
{
System.Data.DataRow aDr = ((System.Data.DataRowView)ie.Current).Row;
TableRow aTblRow = new TableRow();
foreach (Parameter aParam in _params)
{
TableCell aTblCell = new TableCell();
aTblCell.Text = aDr[aParam.Name].ToString();
aTblRow.Cells.Add(aTblCell);
}
_tblUploadedFiles.Rows.Add(aTblRow);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Role"].ToString() != "Admin")
{
Response.Redirect("../Anonymous/ErrorPage.aspx");
}
if (!IsPostBack)
{
obj = new ObjectDataSource();
obj.TypeName = "StudentLayer";
obj.SelectMethod = "SelectStudentsIdAndName";
obj.Select();
DropDownList_Names.DataSource = obj;
DropDownList_Names.DataValueField = "St_Id";
DropDownList_Names.DataTextField = "St_Name";
DropDownList_Names.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
obj = new ObjectDataSource();
obj.TypeName = "ReportsBusinessLayer";
obj.SelectMethod = "selectAllExamIds";
obj.Select();
DropDownList1.DataSource = obj;
DropDownList1.DataTextField = "Ex_id";
DropDownList1.DataValueField = "Ex_id";
DropDownList1.DataBind();
obj1 = new ObjectDataSource();
obj1.TypeName = "ReportsBusinessLayer";
obj1.SelectMethod = "selectAllstudentsIds";
obj1.Select();
DropDownList2.DataSource = obj1;
DropDownList2.DataTextField = "StFullname";
DropDownList2.DataValueField = "St_id";
DropDownList2.DataBind();
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
//Here we have the possiblity to check for certain postbacks and change the date to show
if (this.Context.Request["__EVENTTARGET"] == "BookingInfo")
{
if (this.Context.Request["__EVENTARGUMENT"] == "Selected")
{
//Now we want to select a certain date to show
//This is useful when e.g. showing future bookings for a patient.
string key = "BookingInfo_Result";
int bookingid = -1;
try
{
bookingid = (int)Session[key];
}
catch (Exception exception)
{
throw new ApplicationException("Kan ej visa den valda bokningen, ej giltigt bokningsid");
}
//Lookup the BookingId that was queryed
ObjectDataSource selectedBookingObjectDataSource = new ObjectDataSource("BookingsBLL", "GetBookingsByBookingID");
selectedBookingObjectDataSource.SelectParameters.Add("bookingid", bookingid.ToString());
DataView selectedBookingDataView = (DataView)selectedBookingObjectDataSource.Select();
Rehab.BookingsRow selectedBookingDataRow = (Rehab.BookingsRow)selectedBookingDataView[0].Row;
DateTime selectedBookingStartdatetime = selectedBookingDataRow.startdatetime;
currentDate.CurrentDate = selectedBookingStartdatetime;
}
if (this.Context.Request["__EVENTARGUMENT"] == "Updated")
{
}
}
if (this.Context.Request["__EVENTTARGET"] == "NewBooking" &&
this.Context.Request["__EVENTARGUMENT"] == "Selected")
{
}
if (this.Context.Request["__EVENTTARGET"] == "DateTimePicker")
{
DateTime date = DateTime.Parse(this.Context.Request["__EVENTARGUMENT"]);
currentDate.CurrentDate = date;
}
DayPilotCalendar1.StartDate = currentDate.CurrentDate;
DayPilotCalendar1.DataBind();
LookupPrintBookings.DialogNavigateUrl = "~/Bookings_print.aspx?Date=" + currentDate.CurrentDate.ToShortDateString();
DailyinfoFormView.DataBind();
showNextWeekLinkButton.Text = "Vecka " + currentDate.GetNextWeek().ToString() + " >>";
showPreviousWeekLinkButton.Text = "<< Vecka " + currentDate.GetPreviousWeek().ToString();
showNextMonthLinkButton.Text = currentDate.GetNextMonth() + " >>>";
showPreviousMonthLinkButton.Text = "<<< " + currentDate.GetPreviousMonth();
}
protected object GetObjectByDataSource(string dataSourceId)
{
if (HttpContext.Current.Session[dataSourceId + "combo" + GetFileName()] == null)
{
object s = this.GetControl(dataSourceId) as ObjectDataSource;
if (s == null)
{
s = this.GetControl(dataSourceId) as SqlDataSource;
SqlDataSource sqlD = (SqlDataSource)s;
DataView dv = (DataView)sqlD.Select(DataSourceSelectArguments.Empty);
HttpContext.Current.Session[dataSourceId + "combo" + GetFileName()] = dv;
}
else
{
ObjectDataSource objD = (ObjectDataSource)s;
HttpContext.Current.Session[dataSourceId + "combo" + GetFileName()] = objD.Select();
}
}
return(HttpContext.Current.Session[dataSourceId + "combo" + GetFileName()]);
}
protected void Page_Load(object sender, EventArgs e)
{
Button insertButton = (Button)NewBookingFormView.FindControl("InsertButton");
//KMobile.Web.UI.WebControls.Lookup lookup = (KMobile.Web.UI.WebControls.Lookup)NewBookingFormView.FindControl("LookupChoosePatient");
string scriptString = "";
scriptString += "<script language=JavaScript> ";
scriptString += "function init_shortcuts() {";
scriptString += "shortcut.add('b',function() { document.getElementById('NewBookingFormView_InsertButton').click();},{'disable_in_input':true});";
scriptString += "shortcut.add('v',function() { document.getElementById('NewBookingFormView_LookupChoosePatient').click();},{'disable_in_input':true});";
scriptString += "shortcut.add('n',function() { document.getElementById('NewBookingFormView_LookupNewPatient').click();},{'disable_in_input':true});";
scriptString += "shortcut.add('ESC',function() {window.opener='x';window.close();},{'disable_in_input':false});";
scriptString += "}";
scriptString += " </script>";
RegisterStartupScript("BodyLoadScript", scriptString);
Page.RegisterStartupScript("Shortcut",
"<script language=javascript src='shortcut.js'></script>");
RegisterStartupScript("Shortcut",
"<script language=javascript src='NewBooking.aspx.js'></script>");
if (!Page.IsPostBack)
{
KMobile.Web.UI.WebControls.DateTimePicker dateTimePicker = (KMobile.Web.UI.WebControls.DateTimePicker)NewBookingFormView.Row.FindControl("DateTimePicker1");
if (Page.Request.QueryString["Date"] != null)
dateTimePicker.Value = DateTime.Parse(Page.Request.QueryString["Date"]);
else
dateTimePicker.Value = DateTime.Now.AddDays(1.0);
TextBox starttimeTextBox = (TextBox)NewBookingFormView.Row.FindControl("starttimeTextBox");
if ((Page.Request.QueryString["Hour"] != null) && (Page.Request.QueryString["Minute"] != null))
starttimeTextBox.Text = Page.Request.QueryString["Hour"] + ":" + Page.Request.QueryString["Minute"];
else
starttimeTextBox.Text += "8:30";
if (User.IsInRole("Admin"))
{
TextBox endtimeTextBox = (TextBox)NewBookingFormView.Row.FindControl("endtimeTextBox");
endtimeTextBox.Enabled = true;
endtimeTextBox.Visible = true;
try
{
endtimeTextBox.Text = ((DateTime.Parse(starttimeTextBox.Text)).AddMinutes(30.0)).ToShortTimeString();
}
catch (Exception exception) { }
}
else
{
RegularExpressionValidator endtimeRegularExpressionValidator = (RegularExpressionValidator)NewBookingFormView.Row.FindControl("EndtimeRegularExpressionValidator");
endtimeRegularExpressionValidator.Enabled = false;
}
//Handle the case when a patient already is selected (query string)
//also disbale the possible to choose another patient
if (Page.Request.QueryString["Patientid"] != null)
{
int selectedPatientId = Convert.ToInt32(Page.Request.QueryString["Patientid"]);
//These control are not suppose to be visible if the patient already is given in by the query string
KMobile.Web.UI.WebControls.Lookup lookupChoosePatient = (KMobile.Web.UI.WebControls.Lookup)NewBookingFormView.Row.FindControl("LookupChoosePatient");
lookupChoosePatient.Visible = false;
lookupChoosePatient.Enabled = false;
KMobile.Web.UI.WebControls.Lookup lookupNewPatient = (KMobile.Web.UI.WebControls.Lookup)NewBookingFormView.Row.FindControl("LookupNewPatient");
lookupNewPatient.Visible = false;
lookupNewPatient.Enabled = false;
IsRefreshParentOnCancel = true;
//Get patient data
ObjectDataSource selectedPatientObjectDataSource = new ObjectDataSource("PatientsBLL", "GetPatientsByID");
selectedPatientObjectDataSource.SelectParameters.Add("patientid", selectedPatientId.ToString());
DataView dv = (DataView)selectedPatientObjectDataSource.Select();
Rehab.PatientsDataTable patients = (Rehab.PatientsDataTable)dv.Table;
Rehab.PatientsRow patientsRow = (Rehab.PatientsRow)patients.Rows[0];
Patient selectedPatient = new Patient(patientsRow);
//Fill textboxes with patient info
FillPatientData(selectedPatient);
}
}
}
