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