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); } } } }
public EngineDTO(long id, int noOfCylinders, int engineSizeCC, int powerKW, CylinderConfigurationDTO config, DriveTypeDTO drive, FuelTypeDTO fuel, double economy, double powerToWeight) { ID = id; NoOfCylinders = noOfCylinders; EngineSizeCC = engineSizeCC; PowerKW = powerKW; CylinderConfigDTO = config; DriveTypeDTO = drive; FuelTypeDTO = fuel; FuelEconomy = economy; PowerToWeight = powerToWeight; }
public bool UpdateFuelType(FuelTypeDTO fuleTypeDTO) { string sql = "update FuelTypes set FuelTypeName='" + fuleTypeDTO.FuleTypeName + @"' where FuelTypeID =" + fuleTypeDTO.FuelTypeID; db = new DBAccess(); int rows_affected = db.ExecuteNonQuery(sql); if (rows_affected == 1) { return(true); } else { return(false); } }
public bool NewFuelType(FuelTypeDTO fuleTypeDTO) { string sql = "Insert into FuleTypes (FuelTypeName) values (" + "'" + fuleTypeDTO.FuleTypeName + @"')"; db = new DBAccess(); int rows_affected = db.ExecuteNonQuery(sql); if (rows_affected == 1) { return(true); } else { return(false); } }
public FuelTypeDTO GetFuelType(int fuelTypeID) { db = new DBAccess(); DataTable dt = new DataTable(); string sql = "Select * from FuelTypes where FuelTypeID=" + fuelTypeID; dt = db.ExecuteDataTable(sql); if (dt.Rows.Count <= 0) { return(null); } else { FuelTypeDTO fuelTypeDTO = new FuelTypeDTO(); fuelTypeDTO.FuelTypeID = int.Parse(dt.Rows[0]["FuelTypeID"].ToString()); fuelTypeDTO.FuleTypeName = dt.Rows[0]["FuelTypeName"].ToString(); return(fuelTypeDTO); } }
public bool UpdateFuelType(FuelTypeDTO fuelTypeDTO) { fuelTypeDLL = new FuelTypeDLL(); return(fuelTypeDLL.UpdateFuelType(fuelTypeDTO)); }
public bool NewFuelType(FuelTypeDTO fuelTypeDTO) { fuelTypeDLL = new FuelTypeDLL(); return(fuelTypeDLL.NewFuelType(fuelTypeDTO)); }
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(); } } }