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();
}