protected void btnAddRoad_Click(object sender, EventArgs e) { string NoRujukanTempah = ""; DataTable jalan = JalanInfomation.getRoadByID(Convert.ToInt32(ddlJalan.SelectedValue)); JalanTempahInfo tempah = new JalanTempahInfo(); if (!string.IsNullOrEmpty(txtJumHarga.Text)) { tempah.Jumlah = Convert.ToDouble(txtJumHarga.Text); } if (!string.IsNullOrEmpty(txtJumTiang.Text)) { tempah.JumlahTiangTempah = Convert.ToInt32(txtJumTiang.Text); } if (!string.IsNullOrEmpty(txtTarikhMula.Text)) { tempah.TarikhMula = Convert.ToDateTime(txtTarikhMula.Text); } if (!string.IsNullOrEmpty(txtTarikhTamat.Text)) { tempah.TarikhTamat = Convert.ToDateTime(txtTarikhTamat.Text); } JalanTempahInfo.AddTempah(jalan, tempah, out NoRujukanTempah); Session["EventOverall"] = null; Session["SelectedDates"] = null; SetCalendar(tempah.TarikhMula, tempah.TarikhTamat); string sScript0 = "window.alert('Jalan telah ditambah.');"; ScriptManager.RegisterClientScriptBlock(Page, GetType(), "Page_Load", sScript0, true); }
private void BindGridView(int SelectedRoad) { ClearParameters(); dtJalanInfo = JalanInfomation.getRoadByID(SelectedRoad); gvRoadList.DataSource = dtJalanInfo; gvRoadList.DataBind(); Available = Convert.ToInt32(dtJalanInfo.Rows[0]["Tersedia"].ToString()); hdHargaSeunit.Value = dtJalanInfo.Rows[0]["HargaSeunit"].ToString(); }
private void GetAvailableDate(DateTime tarikhMula, DateTime tarikhTamat, int SelectedMonth, int SelectedYear, out List <EventDetails> EventDates) { EventDates = new List <EventDetails>(); dtJalanInfo = JalanInfomation.getRoadByID(Convert.ToInt32(ddlJalan.SelectedValue)); DataTable dtJalanBooked = JalanInfomation.getBookedByIDAndDates(SelectedRoad, tarikhMula, tarikhTamat); EventDates = EventDetails.getAll(dtJalanBooked, dtJalanInfo, SelectedMonth, SelectedYear); //Session["EventList"] = EventList; }
protected void btnSearch_Click(object sender, EventArgs e) { int RoadID = Convert.ToInt32(ddlJalan.SelectedValue); DataTable dtJalanList = JalanInfomation.getRoadByID(RoadID); gvRoadList.DataSource = dtJalanList; gvRoadList.DataBind(); lblRecord.Text = dtJalanList.Rows.Count.ToString(); }
private void BindToControls(int roadID) { DataTable dtJalan = JalanInfomation.getRoadByID(roadID); if (dtJalan != null) { txtNamaJalan.Text = dtJalan.Rows[0]["NamaJalan"].ToString(); txtJumlahTiang.Text = dtJalan.Rows[0]["JumlahTiang"].ToString(); txtJumTiangRosak.Text = dtJalan.Rows[0]["Rosak"].ToString(); txtJumTiangTersedia.Text = dtJalan.Rows[0]["Tersedia"].ToString(); txtKosSeunit.Text = dtJalan.Rows[0]["HargaKosSeunit"].ToString(); txtHargaSeuinit.Text = dtJalan.Rows[0]["HargaSeunit"].ToString(); txtJumArm.Text = dtJalan.Rows[0]["JumlahArm"].ToString(); txtSaizGegantung.Text = dtJalan.Rows[0]["SaizGegantung"].ToString(); } }
private void BindGridView(string SelectedRoad) { dtJalanInfo = JalanInfomation.getRoadByID(Convert.ToInt32(SelectedRoad)); gvRoadList.DataSource = dtJalanInfo; gvRoadList.DataBind(); }