protected void DetailsView_ItemCommand(object sender, DetailsViewCommandEventArgs e)
{
InfoList.Items.Clear();
switch (e.CommandName)
{
case "TestWeb":
try
{
IBaseDriver drv = null;
switch (mm.DbServer)
{
case DbServer.MySql:
drv = new BaseDriverMySql(((TextBox)(DetailsView.Rows[1].Cells[1].Controls[0])).Text);
break;
case DbServer.MsSql:
drv = new BaseDriverMsSql(((TextBox)(DetailsView.Rows[1].Cells[1].Controls[0])).Text);
break;
}
drv.TestConnection();
InfoList.Items.Add("Connection successful");
}
catch (Exception ew) {
InfoList.Items.Add(ew.Message);
}
break;
case "TestIS":
try
{
IBaseDriver drv = null;
switch (mm.DbServer)
{
case DbServer.MySql:
drv = new BaseDriverMySql(((TextBox)(DetailsView.Rows[3].Cells[1].Controls[0])).Text);
break;
case DbServer.MsSql:
drv = new BaseDriverMsSql(((TextBox)(DetailsView.Rows[3].Cells[1].Controls[0])).Text);
break;
}
drv.TestConnection();
InfoList.Items.Add("Connection successful");
}
catch (Exception ei)
{
InfoList.Items.Add(ei.Message);
}
break;
case "Cancel":
Response.RedirectToRoute("ProjectsRoute");
break;
case "Edit":
DetailsView.ChangeMode(DetailsViewMode.Edit);
break;
}
}
///---------------------------------------------------------------------------------
///---------------------------------------------------------------------------------
protected void dvControl_DataBound(object sender, EventArgs e)
{
DetailsView dv = (DetailsView)sender;
DropDownList ddlUserRoles = (DropDownList)dv.FindControl("ddlUserRoles");
HiddenField hf = (HiddenField)dv.FindControl("hfUserRoleId");
ddlUserRoles.DataSource = BllProxyLookup.GetUserRoles(); // 3:Managers
ddlUserRoles.DataBind();
ListItem item = new ListItem("select user role", "");
ddlUserRoles.Items.Insert(0, item);
if (hf.Value != "")
{
userRoleId = Convert.ToInt32(hf.Value);
}
ListItem currentItem = ddlUserRoles.Items.FindByValue(userRoleId.ToString());
if (currentItem != null)
{
currentItem.Selected = true;
}
else
{
ddlUserRoles.Items.FindByValue("").Selected = true;
}
}
public static void AddRegularExpressionValidator(DetailsView view, int rowIndex, RegexPattern type)
{
string msg = "", patter = "";
if (type == RegexPattern.Number)
{
patter = NUMBER;
msg = NUMBER_MSG;
}
else if (type == RegexPattern.Date)
{
patter = DATE;
msg = DATE_MSG;
}
else if (type == RegexPattern.Mobile)
{
patter = MOBILE;
msg = MOBILE_MSG;
}
DetailsViewRow row = view.Rows[rowIndex];
DataControlFieldCell cell = row.Cells[1] as DataControlFieldCell;
string ctlID = cell.Controls[0].UniqueID;
string clientID = cell.Controls[0].ClientID;
int pos = clientID.LastIndexOf("_");
if (pos > 0)
{
RegularExpressionValidator Reg = new RegularExpressionValidator();
Reg.Text = String.Format("<p style='margin:0;'>{0}</p>", msg);
Reg.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic;
Reg.ControlToValidate = ctlID.Substring((pos + 1));
Reg.ValidationExpression = patter;
cell.Controls.Add(Reg);
}
}
protected void InsertBtn_Click(object sender, EventArgs e)
{
Button ibtn = (Button)sender;
DetailsView d2 = (DetailsView)ibtn.FindControl("DetailsView1");
Label llll = (Label)d2.FindControl("Label_errno");
TextBox tbx1 = (TextBox)d2.FindControl("TextBox1");
DropDownList ddlist2 = (DropDownList)d2.FindControl("DropDownList2");
//IconNum:6 positive、5 negative
try
{
if (llll.Text == "" || tbx1.Text == "")
{
throw new ArgumentNullException();
}
cc1.connectionofc008_modify("insert into ecsfc932_ud(errno,errdsca,type) values('" + llll.Text + "','" + tbx1.Text + "','" + ddlist2.SelectedValue + "')");
GridView2.DataSourceID = "SqlDataSource1";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2('新增成功!!',6)", true);
}
catch (ArgumentNullException ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2('欄位不可有空!!',5)", true);
}
catch (SqlException sqlexcp)
{
//用replace替換掉exception陳述式中出現的換行符號\r\n
//以避免javascript因判斷不出字元而導致function出錯
string SqlExcpStr = sqlexcp.Message.Replace(Environment.NewLine, "");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2('" + SqlExcpStr + "',5)", true);
}
}
public void detail(string tbnm, string colnm, string val, DetailsView dtl)
{
da = new SqlDataAdapter("select * from " + tbnm + " where " + colnm + "=" + val + "", con);
da.Fill(ds);
dtl.DataSource = ds;
dtl.DataBind();
}
public static void AddRequiredFieldValidator(DetailsView view, int rowIndex)
{
DetailsViewRow row = view.Rows[rowIndex];
DataControlFieldCell cell = row.Cells[1] as DataControlFieldCell;
string ctlID = "";
foreach (Control c in cell.Controls)
{
if (c is TextBox)
{
int pos = c.UniqueID.LastIndexOf("$");
ctlID = c.UniqueID.Substring((pos + 1));
break;
}
}
RequiredFieldValidator Reg = new RequiredFieldValidator();
Reg.Text = String.Format("{0}", "*");
Reg.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic;
if (ctlID != string.Empty)
{
Reg.ControlToValidate = ctlID;
cell.Controls.Add(Reg);
}
}
protected void dvOrderEdit_OnItemInserted(object sender, EventArgs e)
{
DetailsView myDetailsView = (DetailsView)sender;
// QOnT.classes.TrackerTools tt = new classes.TrackerTools();
// DateTime dt = tt.GetClosestNextRoastDate(DateTime.Now);
// retrieve values
OrderValues _MyOrderValues = new OrderValues();
// take values from session and set them
DropDownList _ddlCustomers = ((DropDownList)myDetailsView.FindControl(DV_CONTROL_CUSTOMER));
_MyOrderValues.CustomerID = _ddlCustomers.SelectedIndex;
_MyOrderValues.dtOrder = Convert.ToDateTime(((TextBox)myDetailsView.FindControl(DV_CONTROL_ORDER_DATE)).Text);
_MyOrderValues.dtRoast = Convert.ToDateTime(((TextBox)myDetailsView.FindControl(DV_CONTROL_ROAST_DATE)).Text);
_MyOrderValues.dtRequiredBy = Convert.ToDateTime(((TextBox)myDetailsView.FindControl(DV_CONTROL_REQUIRED_BY_DATE)).Text);
_MyOrderValues.DeliverByID = ((DropDownList)myDetailsView.FindControl(DV_CONTROL_DELIVERY_BY)).SelectedIndex;
_MyOrderValues.IsConfirmed = ((CheckBox)myDetailsView.FindControl(DV_CONTROL_CONFIRMED)).Checked;
_MyOrderValues.Notes = ((TextBox)myDetailsView.FindControl(DV_CONTROL_NOTES)).Text;
// save the values
Session[SV_ORDERVALUES] = _MyOrderValues;
ltrlStatus.Text = "Order added for customer: " + _ddlCustomers.SelectedValue;
// now bind the GridView
BindGridViewData(sender, e);
ddlFilterBy.Focus();
this.Form.DefaultButton = btnGo.UniqueID;
}
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DetailsView dv1 = (DetailsView)UpdatePanel1.FindControl("DetailsView1");
int s_id = Int32.Parse(DropDownList1.SelectedValue);
int sec_id = Int32.Parse(DropDownList2.SelectedValue);
var scorelist = campusweb.SelectStudentMarkWithStudentIDAndSemesterAndSection(Session["u_name"].ToString(), s_id, sec_id).ToList();
double sum = 0;
for (int i = 0; i < scorelist.Count; ++i)
{
scorelist[i].sm_percentage *= 100;
scorelist[i].total_percentage = scorelist[i].stum_score / scorelist[i].sm_total * scorelist[i].sm_percentage;
sum += Double.Parse(scorelist[i].total_percentage.ToString());
}
Label6.Text = sum.ToString();
sum /= 100;
if (sum >= 0.9)
{
gred.Text = ("A+").ToString();
}
if (sum >= 0.8 && sum < 0.9)
{
gred.Text = ("A").ToString();
}
if (sum >= 0.7 && sum < 0.8)
{
gred.Text = ("B+").ToString();
}
if (sum >= 0.6 && sum < 0.7)
{
gred.Text = ("B").ToString();
}
if (sum >= 0.55 && sum < 0.6)
{
gred.Text = ("C").ToString();
}
if (sum >= 0.5 && sum < 0.55)
{
gred.Text = ("D").ToString();
}
if (sum >= 0.4 && sum < 0.5)
{
gred.Text = ("E").ToString();
}
if (sum <= 0.39)
{
gred.Text = ("F").ToString();
}
e.Result = scorelist;
}
protected void lnkDownload_Click(object sender, EventArgs e)
{
LinkButton lnkbtn = sender as LinkButton;
DetailsView gvrow = lnkbtn.NamingContainer as DetailsView;
string fileid = DetailsView1.DataKey[gvrow.DataItemIndex].ToString();
using (SqlConnection con1 = new SqlConnection(con))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select [fileName], [recordFile] from [dbo].[PersonalInfo] where [pKId]=@pKId";
cmd.Parameters.AddWithValue("@pKId", fileid);
cmd.Connection = con1;
con1.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
// Response.ContentType = dr["FileType"].ToString();
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + dr["FileName"] + "\"");
Response.BinaryWrite((byte[])dr["recordFile"]);
Response.End();
}
}
}
}
public void FillDetailsView(string querystr, DetailsView list)
{
DataTable dt = GetDataTable(querystr);
list.DataSource = dt;
list.DataBind();
}
protected void OwnerDetailsView_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
DetailsView ClientDetailsView = (DetailsView)sender;
DropDownList ddlClientTypes = (DropDownList)ClientDetailsView.FindControl("ddlClientTypes");
if (ddlClientTypes.SelectedValue == "Private")
{
e.Values["IsLaw"] = false;
e.Values["IsForeigner"] = false;
}
if (ddlClientTypes.SelectedValue == "Law")
{
e.Values["IsLaw"] = true;
e.Values["IsForeigner"] = false;
}
if (ddlClientTypes.SelectedValue == "ForeignPrivate")
{
e.Values["IsLaw"] = false;
e.Values["IsForeigner"] = true;
}
if (ddlClientTypes.SelectedValue == "ForeignLaw")
{
e.Values["IsLaw"] = true;
e.Values["IsForeigner"] = true;
}
}
protected override void OnInit(EventArgs e)
{
objectdatasourceEdit = (ObjectDataSource)this.FindControl("objectdatasourceEdit");
dvControl = (DetailsView)this.FindControl("dvControl");
dvControl.DataSourceID = "objectdatasourceEdit";
dvControl.AutoGenerateRows = false;
dvControl.AllowPaging = false;
dvControl.EnableViewState = true;
dvControl.GridLines = GridLines.Both;
dvControl.Width = Unit.Percentage(100);
dvControl.CssClass = "DetailsView";
dvControl.CellPadding = 4;
dvControl.CellSpacing = 0;
dvControl.EnablePagingCallbacks = false;
dvControl.ItemInserted += DetailsView_ItemInserted;
dvControl.ItemUpdated += DetailsView_ItemUpdated;
objectdatasourceEdit.EnableViewState = true;
objectdatasourceEdit.Inserted += objectdatasource_Inserted;
//---------------------------------------
base.OnInit(e);
}
protected void Page_Load(object sender, EventArgs e)
{
// Create a new DetailsView object.
DetailsView customerDetailsView = new DetailsView();
// Set the DetailsView object's properties.
customerDetailsView.ID = "CustomerDetailsView";
customerDetailsView.DataSourceID = "DetailsViewSource";
customerDetailsView.AutoGenerateRows = true;
customerDetailsView.AllowPaging = true;
customerDetailsView.DataKeyNames = new String[1] {
"CustomerID"
};
// Add a button field to the DetailsView control.
ButtonField field = new ButtonField();
field.ButtonType = ButtonType.Link;
field.CausesValidation = false;
field.Text = "Add to List";
field.CommandName = "Add";
customerDetailsView.Fields.Add(field);
// Programmatically register the event-handling method
// for the ItemDeleting event of a DetailsView control.
customerDetailsView.ItemCommand += new DetailsViewCommandEventHandler(this.CustomerDetailsView_ItemCommand);
// Add the DetailsView object to the Controls collection
// of the PlaceHolder control.
DetailsViewPlaceHolder.Controls.Add(customerDetailsView);
}
protected void dvOrderEdit_OnDataBound(object sender, EventArgs e)
{
DetailsView myDetailsView = (DetailsView)sender;
if (myDetailsView.CurrentMode == DetailsViewMode.Insert)
{
// QOnT.classes.TrackerTools tt = new classes.TrackerTools();
// DateTime dt = tt.GetClosestNextRoastDate(DateTime.Now);
// if there session has lost vars re-initializa
if (Session[SV_ORDERVALUES] == null)
{
InitializeOrderVars();
}
// retrieve values
OrderValues _MyOrderValues = (OrderValues)Session[SV_ORDERVALUES];
// take values from session and set them
((DropDownList)myDetailsView.FindControl(DV_CONTROL_CUSTOMER)).SelectedIndex = _MyOrderValues.CustomerID;
((TextBox)myDetailsView.FindControl(DV_CONTROL_ORDER_DATE)).Text = _MyOrderValues.dtOrder.ToString("d");
((TextBox)myDetailsView.FindControl(DV_CONTROL_ROAST_DATE)).Text = _MyOrderValues.dtRoast.ToString("d");
((TextBox)myDetailsView.FindControl(DV_CONTROL_REQUIRED_BY_DATE)).Text = _MyOrderValues.dtRequiredBy.ToString("d");
((DropDownList)myDetailsView.FindControl(DV_CONTROL_DELIVERY_BY)).SelectedIndex = _MyOrderValues.DeliverByID;
((TextBox)myDetailsView.FindControl(DV_CONTROL_QTY)).Text = "1";
((CheckBox)myDetailsView.FindControl(DV_CONTROL_CONFIRMED)).Checked = _MyOrderValues.IsConfirmed;
((TextBox)myDetailsView.FindControl(DV_CONTROL_NOTES)).Text = _MyOrderValues.Notes;
}
}
void CustomerDetailsView_ItemCommand(Object sender, DetailsViewCommandEventArgs e)
{
// Use the CommandName property to determine which button
// was clicked.
if (e.CommandName == "Add")
{
// Get the DetailsView control that raised the event.
DetailsView customerDetailsView = (DetailsView)sender;
// Add the current customer to the customer list.
// Get the row that contains the company name. In this
// example, the company name is in the second row (index 1)
// of the DetailsView control.
DetailsViewRow row = customerDetailsView.Rows[1];
// Get the company's name from the appropriate cell.
// In this example, the company name is in the second cell
// (index 1) of the row.
String name = row.Cells[1].Text;
// Create a ListItem object with the company name.
ListItem item = new ListItem(name);
// Add the ListItem object to the ListBox, if the
// item doesn't already exist.
if (!CustomerListBox.Items.Contains(item))
{
CustomerListBox.Items.Add(item);
}
}
}
public static void RegisterInsertDefaults(IDynamicDataSource dataSource, DetailsView detailsView, bool hideDefaults)
{
RequestContext requestContext = DynamicDataRouteHandler.GetRequestContext(HttpContext.Current);
MetaTable table = dataSource.GetTable();
if (hideDefaults)
{
var fieldGenerator = detailsView.RowsGenerator as AdvancedFieldGenerator;
if (fieldGenerator != null)
{
fieldGenerator.SkipList.AddRange(BuildSkipList(table, requestContext.RouteData.Values));
}
else
{
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, "Expected a field generator of type {0}", typeof(AdvancedFieldGenerator).FullName));
}
detailsView.ItemInserting += delegate(object sender, DetailsViewInsertEventArgs e) {
SetDefaultInsertValues(table, requestContext.RouteData.Values, e.Values);
};
}
else
{
detailsView.DataBound += delegate(object sender, EventArgs e) {
//In the seperate page version we pull the values from the querystring via routing
SetDefaultInsertControlValues(table, detailsView, requestContext.RouteData.Values);
};
}
}
protected void DetailsView_ModeChanging(object sender, DetailsViewModeEventArgs e)
{
#region ModeChanging Action
DetailsView dv = (DetailsView)sender;
dv.ChangeMode(e.NewMode);
try
{
Int32 donationid = Convert.ToInt32(GridView1.SelectedDataKey.Values[0].ToString());
Int32 donorid = Convert.ToInt32(GridView1.SelectedDataKey.Values[1].ToString());
DetailsView_Data(donationid, donorid, dv);
}
catch (Exception ex)
{
Error_Save(ex, "DetailsView_ModeChanging");
}
if (e.NewMode == DetailsViewMode.Edit)
{
dv.AllowPaging = false;
}
else
{
dv.AllowPaging = true;
}
#endregion ModeChanging Action
}
///---------------------------------------------------------------------------------
///---------------------------------------------------------------------------------
protected void dvControl_DataBound(object sender, EventArgs e)
{
DetailsView dv = (DetailsView)sender;
Control datafield = dv.Rows[0].Controls[1];
HiddenField hf1 = (HiddenField)datafield.FindControl("hfStatusId");
HiddenField hf2 = (HiddenField)datafield.FindControl("hfContactBId");
RadioButtonList rbl = (RadioButtonList)datafield.FindControl("rblStatus");
rbl.DataSource = BllProxyLookup.GetIncidentStatuses();
rbl.DataBind();
statusId = Convert.ToInt32(hf1.Value);
if (statusId != 0)
{
rbl.Items.FindByValue(statusId.ToString()).Selected = true;
}
dv.Rows[4].Visible = !this.isStatusChangeable; // Status Text
dv.Rows[5].Visible = this.isStatusChangeable; // Status Radio buttons
}
public void DetailsViewRow_BubbleEvent()
{
DetailsView dv = new DetailsView();
dv.Page = new Page();
PokerDetailsViewRow row = new PokerDetailsViewRow(2, DataControlRowType.Footer, DataControlRowState.Insert);
Button bt = new Button();
dv.Controls.Add(row);
CommandEventArgs com = new CommandEventArgs(new CommandEventArgs("Delete", null));
dv.ItemDeleting += new DetailsViewDeleteEventHandler(R_DataDeleting);
Assert.AreEqual(false, dataDeleting, "BeforeDeleteBubbleEvent");
row.DoOnBubbleEvent(row, com);
Assert.AreEqual(true, dataDeleting, "AfterDeleteBubbleEvent");
dv.ChangeMode(DetailsViewMode.Insert);
com = new CommandEventArgs(new CommandEventArgs("Insert", null));
dv.ItemInserting += new DetailsViewInsertEventHandler(dv_ItemInserting);
Assert.AreEqual(false, dataInserting, "BeforeInsertBubbleEvent");
row.DoOnBubbleEvent(row, com);
Assert.AreEqual(true, dataInserting, "AfterInsertBubbleEvent");
dv.ChangeMode(DetailsViewMode.Edit);
com = new CommandEventArgs(new CommandEventArgs("Update", null));
dv.ItemUpdating += new DetailsViewUpdateEventHandler(dv_ItemUpdating);
Assert.AreEqual(false, dataUpdating, "BeforeUpdateBubbleEvent");
row.DoOnBubbleEvent(row, com);
Assert.AreEqual(true, dataUpdating, "AfterUpdateBubbleEvent");
dv.ItemUpdating += new DetailsViewUpdateEventHandler(dv_ItemUpdating);
}
protected void vDataset_ItemCreated(object sender, EventArgs e)
{
// Test FooterRow to make sure all rows have been created
DetailsView dv = (DetailsView)sender;
if (dv.FooterRow != null)
{
// The command bar is the last element in the Rows collection
int commandRowIndex = dv.Rows.Count - 1;
if (commandRowIndex > 0)
{
DetailsViewRow commandRow = dv.Rows[commandRowIndex];
// Look for the DELETE button
DataControlFieldCell cell = (DataControlFieldCell)commandRow.Controls[0];
foreach (Control ctl in cell.Controls)
{
ImageButton del = ctl as ImageButton;
if (del != null)
{
if (del.CommandName == "Delete")
{
del.OnClientClick =
"if (!confirm('Er du sikker på at du vil slette denne posten?')) return;";
}
}
}
}
}
}
protected void sign_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["OnlineCourseConnectionString"].ConnectionString);
try
{
connection.Open();
string sql = "UPDATE Users SET Cash = Cash + 50 WHERE UserID={0}";
sql = string.Format(sql, Session["UserID"]);
SqlCommand command = new SqlCommand(sql, connection);
command.ExecuteNonQuery();
HttpCookie signed = new HttpCookie("Signed");
signed.Value = "1";
signed.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(signed);
DetailsView.DataBind();
Response.Write("<script>alert('签到成功！');</script>");
}
catch (Exception)
{
Response.Write("<script>alert('签到失败！');</script>");
}
finally
{
connection.Close();
}
}
protected void ActivitiesDetailsView_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
DetailsView vw = (DetailsView)sender;
DropDownList ddApplicationDetailsTypes = ((DropDownList)vw.FindControl("ddApplicationDetailsTypes")) as DropDownList;
DropDownList ddGroupsDetails = (DropDownList)vw.FindControl("ddGroupsDetails") as DropDownList;
SueetieApplication sueetieApplication = new SueetieApplication();
if (e.Values["ApplicationKey"] == null || e.Values["ApplicationID"] == null)
{
sueetieApplication.ApplicationKey = "ERROR";
sueetieApplication.Description = "All fields required";
}
else
{
sueetieApplication.ApplicationID = int.Parse(e.Values["ApplicationID"].ToString().Trim());
sueetieApplication.ApplicationKey = e.Values["ApplicationKey"].ToString();
sueetieApplication.Description = e.Values["Description"].ToString();
sueetieApplication.GroupID = int.Parse(ddGroupsDetails.SelectedValue);
sueetieApplication.ApplicationTypeID = int.Parse(ddApplicationDetailsTypes.SelectedValue);
}
e.Values.Remove("GroupID");
e.Values.Remove("Description");
e.Values.Remove("ApplicationTypeID");
e.Values.Remove("ApplicationKey");
e.Values.Add("appKey", sueetieApplication.ApplicationKey);
e.Values.Add("appDescription", sueetieApplication.Description);
e.Values.Add("groupID", sueetieApplication.GroupID);
e.Values.Add("appTypeID", sueetieApplication.ApplicationTypeID);
}
/// <summary>
/// Buscar o valor do controle baseado em seu nome
/// </summary>
/// <param name="controlName"></param>
/// <param name="detailsView"></param>
/// <returns></returns>
public static string GetTextFieldValue(string controlName, DetailsView detailsView)
{
object fieldValue = null;
object ctl = detailsView.FindControl(controlName);
if (ctl == null)
{
throw new Exception(string.Format("GetTextFieldValue: could not find {0} control!", controlName));
}
if (ctl.GetType() == typeof(TextBox))
{
fieldValue = ((TextBox)ctl).Text;
}
else if (ctl.GetType() == typeof(DropDownList))
{
fieldValue = ((DropDownList)ctl).SelectedValue;
}
else if (ctl.GetType() == typeof(CheckBox))
{
fieldValue = ((CheckBox)ctl).Checked;
}
else if (ctl.GetType() == typeof(Label))
{
fieldValue = ((Label)ctl).Text;
}
return(fieldValue.ToString());
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
FileUpload fileUpload = (FileUpload)((DetailsView)sender).FindControl("fileUpload");
Label sttUpload = (Label)((DetailsView)sender).FindControl("sttImageUpload");
Binary imageBinary = ImageHelper.getUploadImage(fileUpload, sttUpload);
if (imageBinary != null)
{
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
var hinhanh = (from tx in context.TRAM_XEs where tx.MaTramXe == int.Parse((string)e.Keys["MaTramXe"].ToString()) select tx.HinhAnh).Single();
if (hinhanh == null || hinhanh < 1)
{
e.NewValues["HinhAnh"] = ImageHelper.insertImage(imageBinary);
}
else
{
ImageHelper.updateImage(imageBinary, (int)hinhanh);
}
}
DetailsView detail = (DetailsView)sender;
DropDownList ddlNhanViens = (DropDownList)detail.FindControl("ddlNhanViens");
e.NewValues["MaTruongTram"] = ddlNhanViens.SelectedValue;
}
protected void dvControl_DataBound(object sender, EventArgs e)
{
DetailsView dv = (DetailsView)sender;
if (this.AllowManagement)
{
Control cntrl = dv.Rows[3].FindControl("lbManageGroups");
LinkButton lb = cntrl as LinkButton;
if (lb != null)
{
lb.Visible = true;
}
cntrl = dv.Rows[4].FindControl("lbManageSkills");
lb = cntrl as LinkButton;
if (lb != null)
{
lb.Visible = true;
}
cntrl = dv.Rows[5].FindControl("lbManageLanguages");
lb = cntrl as LinkButton;
if (lb != null)
{
lb.Visible = true;
}
}
dv.Rows[6].Visible = UcConfParameters.UcPublicCallEnabled; // Public Enabled checkbox
}
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
DetailsView detail = (DetailsView)sender;
DropDownList ddlNhanViens = (DropDownList)detail.FindControl("ddlNhanViens");
ddlNhanViens.SelectedValue = ((TRAM_XE)detail.DataItem).MaTruongTram.ToString();
}
protected void dvControl_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
DetailsView dv = (DetailsView)sender;
//-------------------------------------------------------------------------
e.NewValues["time_zone"] = timeZone;
//-------------------------------------------------------------------------
TextBox txtNewPassword = (TextBox)dv.FindControl("txtNewPassword");
TextBox txtConfirmPassword = (TextBox)dv.FindControl("txtConfirmPassword");
if (txtNewPassword.Text.CompareTo(txtConfirmPassword.Text) == 0)
{
e.NewValues["password"] = txtNewPassword.Text;
}
else
{
this.showErrorMessage("Passwords do not match, please retype!");
e.Cancel = true;
}
if (e.Cancel)
{
e.NewValues["password"] = e.OldValues["password"];
}
}
private static void SetDefaultInsertControlValues(MetaTable table, DetailsView detailsView, IDictionary <string, object> parameterValues)
{
foreach (MetaColumn column in table.Columns)
{
string controlValue = null;
var fkColumn = column as MetaForeignKeyColumn;
if (fkColumn != null)
{
IList <object> list = new List <object>();
foreach (string fkName in fkColumn.ForeignKeyNames)
{
object val;
if (parameterValues.TryGetValue(fkName, out val))
{
list.Add(val);
}
}
if (list.Count != fkColumn.ForeignKeyNames.Count)
{
continue;
}
controlValue = fkColumn.ParentTable.GetPrimaryKeyString(list);
}
else if (column.ColumnType == typeof(bool))
{
object val;
if (parameterValues.TryGetValue(column.Name, out val))
{
controlValue = Convert.ToString(val);
}
}
if (controlValue == null)
{
continue;
}
var ftuc = detailsView.FindFieldTemplate(column.Name) as FieldTemplateUserControl;
if (ftuc == null)
{
continue;
}
if (ftuc.DataControl is ListControl)
{
var ddl = ftuc.DataControl as ListControl;
ListItem item = ddl.Items.FindByValue(controlValue);
if (item != null)
{
item.Selected = true;
}
}
else if (ftuc.DataControl is CheckBox)
{
var cb = ftuc.DataControl as CheckBox;
cb.Checked = string.Compare(controlValue, "true", true) == 0;
}
}
}
// set the page to be displayed
private void setPage(string direction, int page, int count, DetailsView dtv)
{
switch (direction)
{
case "Prev":
// if changing to the previous page of page 1, display the last page
if (page == 0)
{
page = count - 1;
dtv.PageIndex = page;
}
else
{
// display the previous page
dtv.PageIndex--;
}
break;
case "Next":
// if changing to the next page of the last page, display the first page
if (page == count - 1)
{
page = 0;
dtv.PageIndex = page;
}
else
{
// display the next page
dtv.PageIndex++;
}
break;
}
}
protected void dvService_DataBound(object sender, EventArgs e)
{
DetailsView dv = sender as DetailsView;
if (dv.DataItem != null)
{
DataRow dr = ((DataRowView)dv.DataItem).Row;
string imagePath = String.Format("~/Upload/ExpertPhoto/{0}.jpg", dr["ExpertId"]);
if (File.Exists(Server.MapPath(imagePath)))
{
imgPhoto.ImageUrl = imagePath;
}
if (dv.CurrentMode == DetailsViewMode.Edit)
{
DropDownList ddlServiceType = dv.FindControl("ddlServiceType") as DropDownList;
Label lblServiceType = dv.FindControl("lblServiceType") as Label;
ddlServiceType.SelectedValue = lblServiceType.Text;
// Check if this service belong to current logon expert, if no, deny edit mode.
int serviceExpertId = Convert.ToInt32(dr["ExpertId"]);
int currentExpertId = Convert.ToInt32(Session["ExpertId"]);
if (serviceExpertId != currentExpertId)
{
dv.ChangeMode(DetailsViewMode.ReadOnly);
}
}
}
}
void lblID_DataBinding(object sender, EventArgs e)
{
Label lblID = (Label)sender;
DetailsView container = (DetailsView)lblID.NamingContainer;
lblID.Text = ((DataRowView)container.DataItem)["CustomerID"].ToString();
}
public GUI(WinMovieRack.Controller.Controller c, MainWindow mw, IMDBBrowser browser, DetailsView dv, ActorsView av, ListView lv,TodoList todoList)
{
this.controller = c;
this.imdbBrowser = browser;
this.mainWindow = mw;
this.detailsView = dv;
this.actorsView = av;
this.listView = lv;
this.todoList = todoList;
mainWindow = mw;
mainWindow.Show();
}
public static void AddRequiredFieldValidator(DetailsView view, int rowIndex)
{
DetailsViewRow row = view.Rows[rowIndex];
DataControlFieldCell cell = row.Cells[1] as DataControlFieldCell;
string ctlID = "";
foreach (Control c in cell.Controls)
{
if (c is TextBox)
{
int pos = c.UniqueID.LastIndexOf("$");
ctlID = c.UniqueID.Substring((pos + 1));
break;
}
}
RequiredFieldValidator Reg = new RequiredFieldValidator();
Reg.Text = String.Format("{0}", "*");
Reg.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic;
if (ctlID != string.Empty)
{
Reg.ControlToValidate = ctlID;
cell.Controls.Add(Reg);
}
}
public void setDetailsView(DetailsView dv)
{
this.view = dv;
view.listBoxMovies.ItemsSource = movieList;
Dispatcher disp = Dispatcher.CurrentDispatcher;
addToListFunction = (MRListData movie) => disp.BeginInvoke(DispatcherPriority.Background, (new Action(() =>
{
Thread.Sleep(0);
BitmapImage posterBitmap = new BitmapImage();
posterBitmap.BeginInit();
posterBitmap.UriSource = new Uri(PictureHandler.getMoviePosterPath(movie.dbItemID, PosterSize.LIST));
posterBitmap.CreateOptions = BitmapCreateOptions.DelayCreation;
posterBitmap.CacheOption = BitmapCacheOption.OnDemand;
posterBitmap.EndInit();
MRListBoxItem item = new MRListBoxItem(movie.dbItemID, movie.titleName, movie.yearAge.ToString(), movie.editableCharakter, posterBitmap);
movieList.Add(item);
movieListItems.Add(movie.dbItemID, item);
})));
/*
var context = SynchronizationContext.Current;
addToListFunction = (MRListData movie) => context.Send(delegate(object sender) {
BitmapImage posterBitmap = new BitmapImage();
posterBitmap.BeginInit();
posterBitmap.UriSource = new Uri(PictureHandler.getMoviePosterPath(movie.dbItemID, PosterSize.LIST));
posterBitmap.CreateOptions = BitmapCreateOptions.DelayCreation;
posterBitmap.CacheOption = BitmapCacheOption.OnDemand;
posterBitmap.EndInit();
MRListBoxItem item = new MRListBoxItem(movie.dbItemID, movie.titleName, movie.yearAge.ToString(), movie.editableCharakter, posterBitmap);
movieList.Add(item);
movieListItems.Add(movie.dbItemID, item);
}, null);
*/
}
private void initializeGUI()
{
browserController = new ImdbBrowserController(this);
IMDBBrowser browser = new IMDBBrowser(browserController);
browserController.setBrowser(browser);
todoListController = new TodoListController(this, dbTodo);
TodoList todoList = new TodoList(todoListController);
todoListController.setTodoList(todoList);
windowController = new MainWindowController();
MainWindow mw = new MainWindow(windowController);
mw.Width = 1024;
mw.Height = 600;
windowController.setMainWindow(this, mw);
detailsViewController = new DetailsViewController(this, db);
DetailsView dv = new DetailsView(detailsViewController);
detailsViewController.setDetailsView(dv);
detailsViewController.loadCompleteMovieList();
actorsViewController = new ActorsViewController(this, db);
ActorsView av = new ActorsView(actorsViewController);
actorsViewController.setActorsView(av);
listViewController = new ListViewController(this, db);
ListView lv = new ListView(listViewController);
listViewController.setListView(lv);
gui = new WinMovieRack.GUI.GUI(this, mw, browser, dv, av, lv, todoList);
}
public Profile(MyProfile myProfile = null)
{
Title = "Profile";
NavigationPage.SetHasNavigationBar(this, true);
BackgroundColor = Color.White;
var backgroundImage = new Image()
{
BackgroundColor = Color.FromHex("#F57C00"),
Aspect = Aspect.AspectFill,
//IsOpaque = false,
//Opacity = 0.8,
};
var shader = new BoxView()
{
Color = Color.FromHex("#F57C00").MultiplyAlpha(.5)
};
var face = new CircleImage
{
BorderColor = Color.White,
BorderThickness = 2,
HeightRequest = 100,
WidthRequest = 100,
Aspect = Aspect.AspectFill,
HorizontalOptions = LayoutOptions.Center,
VerticalOptions = LayoutOptions.Center,
Source =
new UriImageSource { Uri = new Uri(myProfile.avatar), CacheValidity = TimeSpan.FromDays(15) },
};
var dome = new Image()
{
Aspect = Aspect.AspectFill,
Source = new FileImageSource() { File = "dome.png" }
};
var twitterimage = new Image()
{
Source = new FileImageSource() { File = "twitter.png" }
};
var tapGestureTwitterRecognizer = new TapGestureRecognizer();
tapGestureTwitterRecognizer.Tapped +=
(sender, e) =>
{
var profile = new WebViewPage("Twitter", myProfile.twitterName.TwitterUrl());
Navigation.PushAsync(profile);
};
twitterimage.GestureRecognizers.Add(tapGestureTwitterRecognizer);
var linkedinimage = new Image()
{
Source = new FileImageSource() { File = "linkedin.png" }
};
var tapGestureLinkedInRecognizer = new TapGestureRecognizer();
tapGestureLinkedInRecognizer.Tapped +=
(sender, e) =>
{
var profile = new WebViewPage("LinkedIn", myProfile.linkedInProfile);
Navigation.PushAsync(profile);
};
linkedinimage.GestureRecognizers.Add(tapGestureLinkedInRecognizer);
var details = new DetailsView(myProfile);
var slideshow = new ShowProfileDetailsView();
RelativeLayout relativeLayout = new RelativeLayout()
{
HeightRequest = 100,
};
relativeLayout.Children.Add(
backgroundImage,
Constraint.Constant(0),
Constraint.Constant(0),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Height * .35;
})
);
relativeLayout.Children.Add(
shader,
Constraint.Constant(0),
Constraint.Constant(0),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Height * .35;
})
);
relativeLayout.Children.Add(
dome,
Constraint.Constant(-10),
Constraint.RelativeToParent((parent) =>
{
return (parent.Height * .35) - 50;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width + 10;
}),
Constraint.Constant(75)
);
relativeLayout.Children.Add(
twitterimage,
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .05;
}),
Constraint.RelativeToParent((parent) =>
{
return (parent.Height * .35);
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
})
);
relativeLayout.Children.Add(
linkedinimage,
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .95 - (parent.Width * .15);
}),
Constraint.RelativeToParent((parent) =>
{
return (parent.Height * .35);
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
})
);
relativeLayout.Children.Add(
face,
Constraint.RelativeToParent((parent) =>
{
return ((parent.Width / 2) - (face.Width / 2));
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Height * .1;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .5;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .5;
})
);
relativeLayout.Children.Add(
details,
Constraint.Constant(0),
Constraint.RelativeToView(dome, (parent, view) =>
{
return view.Y + view.Height + 10;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.Constant(200)
);
relativeLayout.Children.Add(
slideshow,
Constraint.Constant(0),
Constraint.RelativeToView(details, (parent, view) =>
{
return view.Y + view.Height;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.RelativeToView(details, (parent, view) =>
{
var detailsbottomY = view.Y + view.Height;
return parent.Height - detailsbottomY;
})
);
face.SizeChanged += (sender, e) =>
{
relativeLayout.ForceLayout();
};
this.Content = relativeLayout;
}
/// <summary>
/// Write to 'lbl' (consisted in 'dv') param value if it exists,
/// else set invisible to row with number 'row'.
/// </summary>
/// <param name="dv">Control DetailsViev.</param>
/// <param name="row">Control row number.</param>
/// <param name="lbl">Label, consisted in this row.</param>
/// <param name="value">New content for this label.</param>
/// <returns>Status of assigment value.</returns>
private Boolean SetValueOrInvisible(DetailsView dv, Int32 row, Label lbl, String value)
{
if (value != null && lbl != null && value != string.Empty)
{
lbl.Text = value;
return true;
}
else
{
dv.Rows[row].Visible = false;
return false;
}
}
public Profile(MyProfile myProfile = null)
{
Title = "Profile";
NavigationPage.SetHasNavigationBar(this, true);
BackgroundColor = Color.White;
var backgroundImage = new Image()
{
BackgroundColor = Color.Red,
Aspect = Aspect.AspectFill,
IsOpaque = true,
Opacity = 0.8,
};
var shader = new BoxView()
{
Color = Color.Black.MultiplyAlpha(.5)
};
var face = new CircleImage
{
BorderColor = Color.White,
BorderThickness = 2,
HeightRequest = 100,
WidthRequest = 100,
Aspect = Aspect.AspectFill,
HorizontalOptions = LayoutOptions.Center,
VerticalOptions = LayoutOptions.Center,
Source =
new UriImageSource { Uri = new Uri(myProfile.avatar), CacheValidity = TimeSpan.FromDays(30) },
};
var dome = new Image()
{
Aspect = Aspect.AspectFill,
Source = new FileImageSource() { File = "dome.png" }
};
var chatimage = new Image()
{
Source = new FileImageSource() { File = "chat.png" }
};
var pindropimage = new Image()
{
Source = new FileImageSource() { File = "pindrop.png" }
};
var details = new DetailsView(myProfile);
var slideshow = new ShowProfileDetailsView(myProfile);
RelativeLayout relativeLayout = new RelativeLayout()
{
HeightRequest = 100,
};
relativeLayout.Children.Add(
backgroundImage,
Constraint.Constant(0),
Constraint.Constant(0),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Height * .35;
})
);
relativeLayout.Children.Add(
shader,
Constraint.Constant(0),
Constraint.Constant(0),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Height * .35;
})
);
relativeLayout.Children.Add(
dome,
Constraint.Constant(-10),
Constraint.RelativeToParent((parent) =>
{
return (parent.Height * .35) - 50;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width + 10;
}),
Constraint.Constant(75)
);
relativeLayout.Children.Add(
chatimage,
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .05;
}),
Constraint.RelativeToParent((parent) =>
{
return (parent.Height * .35);
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
})
);
relativeLayout.Children.Add(
pindropimage,
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .95 - (parent.Width * .15);
}),
Constraint.RelativeToParent((parent) =>
{
return (parent.Height * .35);
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .15;
})
);
relativeLayout.Children.Add(
face,
Constraint.RelativeToParent((parent) =>
{
return ((parent.Width / 2) - (face.Width / 2));
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Height * .1;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .5;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width * .5;
})
);
relativeLayout.Children.Add(
details,
Constraint.Constant(0),
Constraint.RelativeToView(dome, (parent, view) =>
{
return view.Y + view.Height + 10;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.Constant(200)
);
relativeLayout.Children.Add(
slideshow,
Constraint.Constant(0),
Constraint.RelativeToView(details, (parent, view) =>
{
return view.Y + view.Height;
}),
Constraint.RelativeToParent((parent) =>
{
return parent.Width;
}),
Constraint.RelativeToView(details, (parent, view) =>
{
var detailsbottomY = view.Y + view.Height;
return parent.Height - detailsbottomY;
})
);
face.SizeChanged += (sender, e) =>
{
relativeLayout.ForceLayout();
};
this.Content = relativeLayout;
}
/***********************************************************************
* Set Default value to Date and UserName to Details View
**********************************************************************/
protected void SetDefaultValue(DetailsView dw, string MyView)
{
if (dw.CurrentMode == DetailsViewMode.Insert || dw.CurrentMode == DetailsViewMode.Edit)
{
TextBox EditDate = dw.FindControl("TextBox1") as TextBox;
EditDate.Text = DateTime.Now.ToShortDateString();
string[] strs = Master.PropertyMasterlblUser.Text.Split(' ');
TextBox EditBy = dw.FindControl("TextBox2") as TextBox;
EditBy.Text = strs[2];
/* for insert of DetailsView1, default value for SubmitDate and Submit by are needed */
if ((dw.CurrentMode == DetailsViewMode.Insert) && (MyView == "view1"))
{
TextBox SubmitDate = dw.FindControl("TextBox4") as TextBox;
SubmitDate.Text = DateTime.Now.ToShortDateString();
TextBox SubmitBy = dw.FindControl("TextBox3") as TextBox;
SubmitBy.Text = strs[2];
DropDownList SectionDropDown = dw.FindControl("DropDownList5") as DropDownList;
SectionDropDown.SelectedValue = "83";
}
/* the DetailsView2 can only be Updated, insert is not relivant, so, Turn it Off */
if (MyView == "view1")
{
DetailsView2.Visible = false;
}
}
else
{
DetailsView2.Visible = true;
}
}
