protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { //get fuel types FuelTypeBLL fuelTypeBll = new FuelTypeBLL(); DataTable dt = new DataTable(); dt = fuelTypeBll.GetFuelTypes(); //assign to the ddl ddlFuelTypes.DataSource = dt; ddlFuelTypes.DataTextField = "FuelTypeName"; ddlFuelTypes.DataValueField = "FuelTypeID"; ddlFuelTypes.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } finally { } } }
protected void btnSave_Click(object sender, EventArgs e) { if (btnSave.Text == "Save") { // Add new Fuel Types } else { string id = ""; if (string.IsNullOrEmpty(Request.QueryString["id"])) { Response.Redirect("FuleType.aspx?act=list", true); } else { id = Request.QueryString["id"]; //update FuelTypeDTO dto = new FuelTypeDTO(); dto.FuelTypeID = Convert.ToInt32(id); dto.FuleTypeName = txtFuelTypeName.Text; FuelTypeBLL bll = new FuelTypeBLL(); if (bll.UpdateFuelType(dto)) { Session["Info"] = "Date Edited Successfully"; Response.Redirect("FuleType.aspx?act=list", true); } else { Response.Redirect("FuleType.aspx?act=edit&id="+id, true); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string act = ""; if (!string.IsNullOrEmpty(Request.QueryString["act"])) { act = Request.QueryString["act"]; } else { act = "list"; } if (act == "add") ResetControls(); else if (act == "edit") { string id = ""; if (string.IsNullOrEmpty(Request.QueryString["id"])) { Response.Redirect("FuleType.aspx?act=list", true); } else { id = Request.QueryString["id"]; FuelTypeBLL bll = new FuelTypeBLL(); FuelTypeDTO dto = bll.GetFuelType(Convert.ToInt32(id)); txtFuelTypeName.Text = dto.FuleTypeName; btnSave.Text = "Update"; } } else if (act == "del") { string id = ""; if (string.IsNullOrEmpty(Request.QueryString["id"])) { Response.Redirect("FuleType.aspx?act=list", true); } else { id = Request.QueryString["id"]; FuelTypeBLL bll = new FuelTypeBLL(); try { if (bll.DeleteFuelType(Convert.ToInt32(id))) { Session["Info"] = "Fuel Type Sucessfully deleted."; Response.Redirect("FuleType.aspx?act=list", true); } else { Session["Error"] = "Delete Failed."; Response.Redirect("FuleType.aspx?act=list", true); } } catch (Exception ex) { Session["Error"] = "Delete Failed."+ ex.Message; Response.Redirect("FuleType.aspx?act=list", true); } } } else LoadList(); } }
private void LoadList() { FuelTypeBLL fuelTypeBLL = new FuelTypeBLL(); // alt 1 gvTable.DataSource = fuelTypeBLL.GetFuelTypes(); gvTable.DataBind(); //alt 2 DataTable dt = fuelTypeBLL.GetFuelTypes(); string table = "<table id ='data-table'><tr><th>SN</th><th>Name</th><th></th></tr>"; int sn = 0; foreach (DataRow dr in dt.Rows) { sn++; table += "<tr><td>" + sn + "</td>" + "<td><strong>" + dr["FuelTypeName"] + "</strong></td>" + "<td><a href='FuleType.aspx?act=edit&id=" + dr["FuelTypeID"].ToString() + "'>Edit</a></td>" + "<td><a href='FuleType.aspx?act=del&id=" + dr["FuelTypeID"].ToString() + "' onclick=\"return confirm('Do you want to delete?')\">Delete</a></td>" + "</tr>"; } table += "</table>"; lblTable.Text = table; }