protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e) { UpdatePanel up4 = (UpdatePanel)(FormView1.FindControl("UpdatePanel4")); DropDownList dl1 = (DropDownList)(up4.FindControl("DropDownList6")); UpdatePanel up5 = (UpdatePanel)(up4.FindControl("UpdatePanel5")); DropDownList dl2 = (DropDownList)(up5.FindControl("DropDownList7")); UpdatePanel up6 = (UpdatePanel)(up5.FindControl("UpdatePanel6")); DropDownList dl3 = (DropDownList)(up6.FindControl("DropDownList8")); string q = "insert into user_Info (userName, firstName, lastName,userGender,contactNumber, userAddress, userCountry, userState, userCity, postalCode) values (@userName, @firstName, @lastName, @userGender,@contactNumber, @userAddress, @userCountry, @userState, @userCity, @postalCode)"; SqlCommand cmd = new SqlCommand(q, con); cmd.Parameters.Add("@userName", SqlDbType.VarChar, 50).Value = Label3.Text; cmd.Parameters.Add("@firstName", SqlDbType.VarChar, 50).Value = ((TextBox)(FormView1.FindControl("TextBox6"))).Text; cmd.Parameters.Add("@lastName", SqlDbType.VarChar, 50).Value = ((TextBox)(FormView1.FindControl("TextBox7"))).Text; cmd.Parameters.Add("@userGender", SqlDbType.VarChar, 50).Value = (((DropDownList)(FormView1.FindControl("DropDownList5"))).SelectedValue).ToString(); cmd.Parameters.Add("@contactNumber", SqlDbType.BigInt).Value = Convert.ToInt64(((TextBox)(FormView1.FindControl("TextBox8"))).Text); cmd.Parameters.Add("@userAddress", SqlDbType.NVarChar, 50).Value = ((TextBox)(FormView1.FindControl("TextBox9"))).Text; cmd.Parameters.Add("@userCountry", SqlDbType.VarChar, 50).Value = dl1.SelectedValue; cmd.Parameters.Add("@userState", SqlDbType.VarChar, 50).Value = dl2.SelectedValue; cmd.Parameters.Add("@userCity", SqlDbType.VarChar, 50).Value = dl3.SelectedValue; cmd.Parameters.Add("@postalCode", SqlDbType.Int).Value = Convert.ToInt32(((TextBox)(FormView1.FindControl("TextBox10"))).Text); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); FormView1.ChangeMode(FormViewMode.ReadOnly); bind(); }
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e) { UpdatePanel up1 = (UpdatePanel)(FormView1.FindControl("UpdatePanel7")); DropDownList dl1 = (DropDownList)(up1.FindControl("DropDownList9")); UpdatePanel up2 = (UpdatePanel)(up1.FindControl("UpdatePanel8")); DropDownList dl2 = (DropDownList)(up2.FindControl("DropDownList10")); UpdatePanel up3 = (UpdatePanel)(up2.FindControl("UpdatePanel9")); DropDownList dl3 = (DropDownList)(up3.FindControl("DropDownList11")); string q = "update user_Info set firstName=@firstName,lastName=@lastName,userGender=@userGender,contactNumber=@contactNumber,userAddress=@userAddress,userCountry=@userCountry,userState=@userState,userCity=@userCity where userName=@userName"; SqlCommand cmd = new SqlCommand(q, con); cmd.Parameters.Add("@userName", SqlDbType.VarChar, 50).Value = FormView1.DataKey["userName"]; cmd.Parameters.Add("@firstName", SqlDbType.VarChar, 50).Value = ((TextBox)(FormView1.FindControl("TextBox1"))).Text; cmd.Parameters.Add("@lastName", SqlDbType.VarChar, 50).Value = ((TextBox)(FormView1.FindControl("TextBox2"))).Text; cmd.Parameters.Add("@userGender", SqlDbType.VarChar, 50).Value = (((DropDownList)(FormView1.FindControl("DropDownList1"))).SelectedValue).ToString(); cmd.Parameters.Add("@contactNumber", SqlDbType.BigInt).Value = Convert.ToInt64(((TextBox)(FormView1.FindControl("TextBox3"))).Text); cmd.Parameters.Add("@userAddress", SqlDbType.NVarChar, 50).Value = ((TextBox)(FormView1.FindControl("TextBox4"))).Text; cmd.Parameters.Add("@userCountry", SqlDbType.VarChar, 50).Value = dl1.SelectedValue; cmd.Parameters.Add("@userState", SqlDbType.VarChar, 50).Value = dl2.SelectedValue; cmd.Parameters.Add("@userCity", SqlDbType.VarChar, 50).Value = dl3.SelectedValue; cmd.Parameters.Add("@postalCode", SqlDbType.Int).Value = Convert.ToInt32(((TextBox)(FormView1.FindControl("TextBox5"))).Text); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); FormView1.ChangeMode(FormViewMode.ReadOnly); bind(); }
protected void ListViewUsers_ItemEditing(object sender, ListViewEditEventArgs e) { ListViewUsers.EditIndex = e.NewEditIndex; PopulateListViewUsers(); if (this.ListViewUsers.EditIndex != -1) { Panel validationMsg = (Panel)this.ListViewUsers.Items[this.ListViewUsers.EditIndex].FindControl("editNameContainerIsValid"); UpdatePanel updatePanel = (UpdatePanel)this.ListViewUsers.Items[this.ListViewUsers.EditIndex].FindControl("UpdatePanelEdit"); TextBox TextBoxUserNameEdit = (TextBox)updatePanel.FindControl("TextBoxUsernameEdit"); CheckBoxList CheckBoxListRolesOfUser = (CheckBoxList)updatePanel.FindControl("CheckBoxListRolesOfUser"); Literal ListeralApplicationName = (Literal)updatePanel.FindControl("LiteralAppNameEdit"); List <String> userRolesList = RolesBLL.GetRolesForUserByApplication(ListeralApplicationName.Text, TextBoxUserNameEdit.Text); List <String> applicationRolesList = RolesBLL.GetRolesByApplication(ListeralApplicationName.Text); validationMsg.Visible = false; foreach (string applicationRole in applicationRolesList) { System.Web.UI.WebControls.ListItem listItem = new System.Web.UI.WebControls.ListItem(applicationRole, "", true); foreach (string userRole in userRolesList) { if (applicationRole == userRole) { listItem.Selected = true; } } CheckBoxListRolesOfUser.Items.Add(listItem); } } }
protected void Regist_Trigger() { foreach (Control ctl in Page.Master.FindControl("ContentPlaceHolder1").Controls) { //Utility.log(1, ctl.ID.ToString()); if (ctl.GetType().Name == "UpdatePanel") { UpdatePanel p = (UpdatePanel)ctl; string name = p.ID.Replace("panel_", "btn_"); string type = p.ID.Replace("panel_", ""); Button btn = (Button)p.FindControl(name); btn.Text = getStr("upload_file"); //因為fileUpload 在postback 後,上傳功能會鎖住 所以必需要重新註冊 //https://dotblogs.com.tw/stanley14/2016/08/10/173019 參考這篇 重新註冊 trigger PostBackTrigger trigger = new PostBackTrigger(); trigger.ControlID = btn.ID; p.Triggers.Add(trigger); ScriptManager.GetCurrent(Page).RegisterPostBackControl(btn); if (_attach.Rows.Count > 0) { attach_List(type); } } } }
//Method for Booking An Appointment public void MyBookingBtnHanlder(object sender, ImageClickEventArgs e) { HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName]; if (authCookie != null) { //Check if the patient already have any up to date appointment if (CheckPendantBookings() == false) { ImageButton imgbtn = (ImageButton)sender; CultureInfo ci = new CultureInfo("en-US"); DateTime date = Convert.ToDateTime(imgbtn.CommandArgument); TimeSpan time = date.TimeOfDay; date = date.Date; int result = 0; try { var query = from a in db.Appointment where a.Date == date && a.Time == time && a.Status == true select a; result = query.Count(); } catch (Exception) { } //Check if some other patient booked that time before the current patient selected it if (result > 0) { Label label = (Label)UpdatePanel.FindControl("BookingErrorMessage"); label.Text = "Sorry, someone came ahead of you and has booked that time"; label.Visible = true; } //Else book the appointment else { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); //Wait until is safe to enter mutex.WaitOne(); try { var patient = (from p in db.Patient where p.NhsNumber == ticket.Name select p).First(); Appointment appointment = new Appointment { Date = date, Time = time, BookingDateTime = DateTime.Now, Status = true, PatientFk = patient.Id }; db.Appointment.InsertOnSubmit(appointment); db.SubmitChanges(); } catch (Exception) { } //Release the Mutex mutex.ReleaseMutex(); Response.Redirect("PatientPanel.aspx?success=yes"); } } //Else if the patient already has a pendant appointment else { Response.Redirect("PatientPanel.aspx?error=yes"); } } else { Response.Redirect("Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName]; if (authCookie != null) { PageHeader.Text = string.Format("<h3 class='page-header-lg'>{0}</h3>", "Book an Appointment"); Label label = (Label)UpdatePanel.FindControl("BookingErrorMessage"); label.Visible = false; //Check if the page has not been posted back if (!IsPostBack) { DateTime today = DateTime.Today; DateTime nextDay = today.AddDays(1); CultureInfo ci = new CultureInfo("en-US"); //Fill the RadioButtonList with the 5 following days of the week except Saturday and Sunday for (int i = 0; i < 5; i++) { ListItem item = new ListItem(); if (nextDay.ToString("dddd", ci) == DayOfWeek.Saturday.ToString()) { nextDay = nextDay.AddDays(2); item.Text = nextDay.ToString("dddd d MMMM", ci); item.Value = nextDay.ToString("yyyy-MM-dd"); RadioButtonList.Items.Add(item); } else if (nextDay.ToString("dddd", ci) == DayOfWeek.Sunday.ToString()) { nextDay = nextDay.AddDays(1); item.Text = nextDay.ToString("dddd d MMMM", ci); item.Value = nextDay.ToString("yyyy-MM-dd"); RadioButtonList.Items.Add(item); } else { item.Text = nextDay.ToString("dddd d MMMM", ci); item.Value = nextDay.ToString("yyyy-MM-dd"); RadioButtonList.Items.Add(item); } nextDay = nextDay.AddDays(1); } } //Else show Available Hours Table located in the Update Panel (AJAX) else { var selectedDate = RadioButtonList.SelectedValue; //Check if the patient has already selected a day if (selectedDate != "") { int rowCtr, cellCtr; TimeSpan time; DateTime date = Convert.ToDateTime(selectedDate); for (rowCtr = -15; rowCtr <= 45; rowCtr = rowCtr + 15) { TableRow tRow = new TableRow(); Table.Rows.Add(tRow); for (cellCtr = 8; cellCtr <= 18; cellCtr++) { TableCell tCell = new TableCell(); tRow.Cells.Add(tCell); ImageButton btn = new ImageButton(); Image img = new Image(); img.ImageUrl = "NULL"; if (rowCtr == -15) { if (cellCtr != 18) { img.ImageUrl = "./img/" + cellCtr + ".png"; img.CssClass = "img-hour"; } else { img = new Image(); } } else { if (cellCtr == 18) { if (rowCtr == 15) { img.ImageUrl = "./img/15'.png"; } else { img.ImageUrl = "./img/" + rowCtr + ".png"; img.CssClass = "img-hour"; } } else { time = new TimeSpan(cellCtr, rowCtr, 0); var query = from a in db.Appointment where a.Date == date && a.Time == time && a.Status == true select a; if (query.Count() <= 0) { btn.ImageUrl = "./img/book.png"; btn.Attributes.Add("class", "btn-img"); btn.ID = cellCtr + "-" + rowCtr; date = date.Date + time; btn.CommandArgument = date.ToString(); btn.Click += MyBookingBtnHanlder; } else { img.ImageUrl = "./img/booked.png"; img.Attributes.Add("class", "img-hour"); } } } if (img.ImageUrl != "NULL") { tCell.Controls.Add(img); } else { tCell.Controls.Add(btn); } } } } } } else { Response.Redirect("Login.aspx"); } }
private void BindAg_WFP3() { using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { ListView lv; var a = wDataContext.form_wfp3s.Where(w => w.pk_form_wfp3 == PK_FormWfp3).Select(s => s); fvAg_WFP3.DataKeyNames = new string[] { "pk_form_wfp3" }; fvAg_WFP3.DataSource = a; fvAg_WFP3.DataBind(); //lvAg_WFP3_BMPs lv = pnlSubPanels.FindControl("lvAg_WFP3_BMPs") as ListView; var c = from b in wDataContext.vw_form_wfp3_BMPs.Where(w => w.pk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_bmp" }; lv.DataSource = c; lv.DataBind(); //lvAg_WFP3_Bids lv = pnlSubPanels.FindControl("lvAg_WFP3_Bids") as ListView; var d = from b in wDataContext.form_wfp3_bids.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_bid" }; lv.DataSource = d; lv.DataBind(); //lvAg_WFP3_Encumbrances lv = pnlSubPanels.FindControl("lvAg_WFP3_Encumbrances") as ListView; var e = from b in wDataContext.form_wfp3_encumbrances.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_encumbrance" }; lv.DataSource = e; lv.DataBind(); //lvAg_WFP3_Invoices lv = pnlSubPanels.FindControl("lvAg_WFP3_Invoices") as ListView; var i = from b in wDataContext.form_wfp3_invoices.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_invoice" }; lv.DataSource = i; lv.DataBind(); //lvAg_WFP3_Payments lv = pnlSubPanels.FindControl("lvAg_WFP3_Payments") as ListView; var p = from b in wDataContext.form_wfp3_payments.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_payment" }; lv.DataSource = p; lv.DataBind(); //lvAg_WFP3_Modifications lv = pnlSubPanels.FindControl("lvAg_WFP3_Modifications") as ListView; var m = from b in wDataContext.form_wfp3_modifications.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_modification" }; lv.DataSource = m; lv.DataBind(); //lvAg_WFP3_Specifications" lv = pnlSubPanels.FindControl("lvAg_WFP3_Specifications") as ListView; var sp = from b in wDataContext.form_wfp3_specifications.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_specification" }; lv.DataSource = sp; lv.DataBind(); //lvAg_WFP3_Techs lv = pnlSubPanels.FindControl("lvAg_WFP3_Techs") as ListView; var t = from b in wDataContext.form_wfp3_teches.Where(w => w.fk_form_wfp3 == PK_FormWfp3) select b; lv.DataKeyNames = new string[] { "pk_form_wfp3_tech" }; lv.DataSource = t; lv.DataBind(); litAg_WFP3_Header.Text = WACGlobal_Methods.SpecialText_Agriculture_PopUpHeader(FK_FarmBusiness); string sWACRegion = WACGlobal_Methods.SpecialQuery_Agriculture_GetWACRegion_ByFarmBusinessPK(FK_FarmBusiness); Create_Agriculture_WFP3_Basic_Grid(PK_FormWfp3); Create_Agriculture_WFP3_Encumbrance_CurrentlyAssigned_Summary_Grid(PK_FormWfp3); Create_Agriculture_WFP3_Encumbrance_Possible_Summary_Grid(PK_FormWfp3); Create_Agriculture_WFP3_PaymentBMP_PaymentStatus_Grid(PK_FormWfp3); CreateAgWFP3PaymentBMPFundingOverviewGrid(PK_FormWfp3); if (fvAg_WFP3.CurrentMode == FormViewMode.ReadOnly && a.Count() == 1) { UpdatePanel up = (UpdatePanel)pnlAg_WFP3.FindControl("upAg_WFP3"); Utility_WACUT_AttachedDocumentViewer docView = (Utility_WACUT_AttachedDocumentViewer)up.FindControl("WACUT_AttachedDocumentViewerWFP3"); List <WACParameter> parms = new List <WACParameter>(); parms.Add(new WACParameter("pk_farmBusiness", a.First().fk_farmBusiness, WACParameter.ParameterType.MasterKey)); parms.Add(new WACParameter("pk_form_wfp2", a.First().pk_form_wfp3, WACParameter.ParameterType.PrimaryKey)); docView.InitControl(parms); } if (fvAg_WFP3.CurrentMode == FormViewMode.Insert) { WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fvAg_WFP3, "ddlSpecialProvisions", "N"); WACGlobal_Methods.PopulateControl_DatabaseLists_ProcurementType_DDL(fvAg_WFP3, "ddlProcurementType", ""); } if (fvAg_WFP3.CurrentMode == FormViewMode.Edit) { WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fvAg_WFP3, "ddlSpecialProvisions", a.Single().specialProvisions); WACGlobal_Methods.PopulateControl_DatabaseLists_ProcurementType_DDL(fvAg_WFP3, "ddlProcurementType", a.Single().fk_procurementType_code); } } }