//Search Part
protected void Search_Click(object sender, EventArgs e)
{
CarMaintenanceList = new List<CarMaintenance>();
myCarMaintenance = new CarMaintenance();
myCarMaintenance = SearchModel();
var CarId = new SqlParameter();
var ServiceId = new SqlParameter();
//
if (myCarMaintenance.CarId != 0)
{
CarId = new SqlParameter("@CarId", myCarMaintenance.CarId);
}
else { CarId = new SqlParameter("@CarId", DBNull.Value); }
//
if (myCarMaintenance.ServiceId != 0)
{
ServiceId = new SqlParameter("@ServiceId", myCarMaintenance.ServiceId);
}
else { ServiceId = new SqlParameter("@ServiceId", DBNull.Value); }
CarMaintenanceList = db.Database
.SqlQuery<CarMaintenance>("SP_CarMaintenance @CarId , @ServiceId", CarId, ServiceId).ToList();
foreach (var item in CarMaintenanceList)
{
item.Cars = db.Cars.Where(c => c.id == item.CarId).FirstOrDefault();
item.Services = db.Services.Where(c => c.Id == item.ServiceId).FirstOrDefault();
}
SearchCarMaintenanceList = CarMaintenanceList;
BindGridList();
ClearSearchModel();
}
protected CarMaintenance SearchModel()
{
CarMaintenance carMaintenance = new CarMaintenance();
if (CarsSearchListtxt.SelectedValue != "0") { carMaintenance.CarId = Convert.ToInt32(CarsSearchListtxt.SelectedValue); }
if (ServicesSearchListtxt.SelectedValue != "0") { carMaintenance.ServiceId = Convert.ToInt32(ServicesSearchListtxt.SelectedValue); }
return carMaintenance;
}
protected void edit_Command(object sender, CommandEventArgs e)
{
CarMaintenance temCarMaintenance = new CarMaintenance();
int index = Convert.ToInt32(e.CommandArgument);
if (SearchCarMaintenanceList.Count > 0)
{ temCarMaintenance = SearchCarMaintenanceList[index]; }
else { temCarMaintenance = CarMaintenanceList[index]; }
try
{
IdHid.Value = temCarMaintenance.Id.ToString();
ChangeRateTxt.Text = temCarMaintenance.ChangeRate;
AlertRateTxt.Text = temCarMaintenance.AlertRate;
HaveChangeRate.Checked = temCarMaintenance.HaveChangeRate;
if(HaveChangeRate.Checked == false)
{
ChangeRateTxt.Enabled = false;
AlertRateTxt.Enabled = false;
}
AddCarsListhtml.SelectedValue = temCarMaintenance.CarId.ToString();
AddServicesListhtml.SelectedValue = temCarMaintenance.ServiceId.ToString();
}
catch (Exception Exec)
{
}
SearchCarMaintenanceList = new List<CarMaintenance>();
UpdatePanel3.Update();
}
//operation Part
protected void Save_Click(object sender, EventArgs e)
{
CarMaintenance carMaintenance = CarsModel();
if (carMaintenance.Id == 0)
{
try
{
db.CarMaintenance.Add(carMaintenance);
db.SaveChanges();
}
catch (Exception except)
{
}
}
else
{
try
{
db.CarMaintenance.AddOrUpdate(carMaintenance);
db.SaveChanges();
}
catch (Exception except)
{
}
}
ClearModel();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
public CarMaintenance Create(CarMaintenanceViewModel toCreate)
{
Validate(toCreate);
// If the mileage is less than 1, pull the mileage from the car
if (toCreate.Mileage < 1)
{
toCreate.Mileage = _db.Cars.First(c => c.CarId == toCreate.CarId).Mileage ?? 0;
}
var maint = new CarMaintenance()
{
CarId = toCreate.CarId,
Date = toCreate.Date,
Mileage = toCreate.Mileage,
Type = toCreate.Type,
Notes = toCreate.Notes,
Active = true
};
_db.CarMaintenances.Add(maint);
_db.SaveChanges();
return(maint);
}
protected void NewSearch_Click(object sender, EventArgs e)
{
SearchCarMaintenanceList = new List<CarMaintenance>();
ClearSearchModel();
myCarMaintenance = new CarMaintenance();
CarMaintenanceList = new List<CarMaintenance>();
CarMaintenanceList = db.CarMaintenance.ToList();
BindGridList();
}
public static CarMaintenanceViewModel ToViewModel(this CarMaintenance carMaint)
{
var vm = new CarMaintenanceViewModel()
{
Type = carMaint.Type,
Date = carMaint.Date,
CarId = carMaint.CarId,
Mileage = carMaint.Mileage,
CarMaintenanceId = carMaint.CarMaintenanceId,
Notes = carMaint.Notes
};
return(vm);
}
protected CarMaintenance CarsModel()
{
CarMaintenance carMaintenance = new CarMaintenance();
if (IdHid.Value != "0") { carMaintenance.Id = Convert.ToInt32(IdHid.Value); }
if (ChangeRateTxt.Text != "") { carMaintenance.ChangeRate = ChangeRateTxt.Text; } else { carMaintenance.ChangeRate = "0"; }
if (AlertRateTxt.Text != "") { carMaintenance.AlertRate = AlertRateTxt.Text; } else { carMaintenance.AlertRate = "0"; }
carMaintenance.HaveChangeRate = HaveChangeRate.Checked;
if (SelectedCarId != "") { carMaintenance.CarId = Convert.ToInt32(SelectedCarId); }
if (SelectedServiceId != "") { carMaintenance.ServiceId = Convert.ToInt32(SelectedServiceId); }
carMaintenance.LoginID = ExtendedMethod.LoginedUser.Id;
return carMaintenance;
}
