protected CarChangeRateOnDis CarChangeRateOnDisModel()
{
CarChangeRateOnDis carChangeRateOnDis = new CarChangeRateOnDis();
if (IdHid.Value != "0")
{
carChangeRateOnDis.Id = Convert.ToInt32(IdHid.Value);
}
if (Description.Text != "")
{
carChangeRateOnDis.Description = Description.Text;
}
if (SelectedCarId != "")
{
carChangeRateOnDis.CarId = Convert.ToInt32(SelectedCarId);
}
if (SelectedServiceId != "")
{
carChangeRateOnDis.ServiceId = Convert.ToInt32(SelectedServiceId);
}
//Before
if (Before.Text != "")
{
carChangeRateOnDis.Before = Convert.ToDouble(Before.Text);
}
if (DateBefore.Text != "")
{
carChangeRateOnDis.DateBefore = ExtendedMethod.FormatDate(DateBefore.Text);
}
if (AtHourBefore.Text != "")
{
carChangeRateOnDis.AtHourBefore = AtHourBefore.Text;
}
//After
if (After.Text != "")
{
carChangeRateOnDis.After = Convert.ToDouble(After.Text);
}
if (DateAfter.Text != "")
{
carChangeRateOnDis.DateAfter = ExtendedMethod.FormatDate(DateAfter.Text);
}
if (AtHourAfter.Text != "")
{
carChangeRateOnDis.AtHourAfter = AtHourAfter.Text;
}
carChangeRateOnDis.LoginID = ExtendedMethod.LoginedUser.Id;
return(carChangeRateOnDis);
}
protected void NewSearch_Click(object sender, EventArgs e)
{
SearchCarChangeRateOnDisList = new List <CarChangeRateOnDis>();
ClearSearchModel();
myCarChangeRateOnDis = new CarChangeRateOnDis();
CarChangeRateOnDisList = new List <CarChangeRateOnDis>();
CarChangeRateOnDisList = db.CarChangeRateOnDis.ToList();
BindGridList();
}
protected CarChangeRateOnDis SearchModel()
{
CarChangeRateOnDis carChangeRateOnDis = new CarChangeRateOnDis();
if (CarsSearchListtxt.SelectedValue != "0")
{
carChangeRateOnDis.CarId = Convert.ToInt32(CarsSearchListtxt.SelectedValue);
}
if (ServicesSearchListtxt.SelectedValue != "0")
{
carChangeRateOnDis.ServiceId = Convert.ToInt32(ServicesSearchListtxt.SelectedValue);
}
return(carChangeRateOnDis);
}
protected void edit_Command(object sender, CommandEventArgs e)
{
EditFlage = true;
//enable After Part Untill edit
After.Enabled = true;
DateAfter.Enabled = true;
AtHourAfter.Enabled = true;
//Disable Before Part Untill edit
Before.Enabled = false;
DateBefore.Enabled = false;
AtHourBefore.Enabled = false;
CarChangeRateOnDis temCarChangeRateOndis = new CarChangeRateOnDis();
int index = Convert.ToInt32(e.CommandArgument);
if (SearchCarChangeRateOnDisList.Count > 0)
{
temCarChangeRateOndis = SearchCarChangeRateOnDisList[index];
}
else
{
temCarChangeRateOndis = CarChangeRateOnDisList[index];
}
try
{
IdHid.Value = temCarChangeRateOndis.Id.ToString();
Description.Text = temCarChangeRateOndis.Description;
AddCarsListhtml.SelectedValue = temCarChangeRateOndis.CarId.ToString();
AddServicesListhtml.SelectedValue = temCarChangeRateOndis.ServiceId.ToString();
Before.Text = temCarChangeRateOndis.Before.ToString();
DateBefore.Text = ExtendedMethod.ParseDateToString(DateTime.Parse(temCarChangeRateOndis.DateBefore.ToString()));
AtHourBefore.Text = temCarChangeRateOndis.AtHourBefore;
After.Text = temCarChangeRateOndis.After.ToString();
DateAfter.Text = ExtendedMethod.ParseDateToString(DateTime.Parse(temCarChangeRateOndis.DateAfter.ToString()));
AtHourAfter.Text = temCarChangeRateOndis.AtHourAfter;
}
catch (Exception Exec)
{
}
SearchCarChangeRateOnDisList = new List <CarChangeRateOnDis>();
UpdatePanel3.Update();
}
// Operation Part
protected void Save_Click(object sender, EventArgs e)
{
CarChangeRateOnDis carChangeRateOnDis = CarChangeRateOnDisModel();
// to have change rate and alert rate values
var carmaintainceItem = db.CarMaintenance.Where(carmain => carmain.CarId == carChangeRateOnDis.CarId && carmain.ServiceId == carChangeRateOnDis.ServiceId).FirstOrDefault();
////////////
var Dis = IsReachedChangeRate(carChangeRateOnDis.CarId, carChangeRateOnDis.ServiceId);
// low htb2a bra al change rate
if (carChangeRateOnDis.Id == 0)
{
if (Dis <= Convert.ToDouble(carmaintainceItem.ChangeRate))
{
try
{
db.CarChangeRateOnDis.Add(carChangeRateOnDis);
db.SaveChanges();
ClearModel();
Page.Response.Redirect(Page.Request.Url.ToString(), false);
}
catch (Exception except)
{
}
}
else
{
ShowMessage("This Movement Will be More than Change Rate can not Added");
}
}
else
{
try
{
db.CarChangeRateOnDis.AddOrUpdate(carChangeRateOnDis);
db.SaveChanges();
ClearModel();
Page.Response.Redirect(Page.Request.Url.ToString(), false);
}
catch (Exception except)
{
}
}
}
// Search Part
protected void Search_Click(object sender, EventArgs e)
{
CarChangeRateOnDisList = new List <CarChangeRateOnDis>();
myCarChangeRateOnDis = new CarChangeRateOnDis();
myCarChangeRateOnDis = SearchModel();
var CarId = new SqlParameter();
var ServiceId = new SqlParameter();
//
if (myCarChangeRateOnDis.CarId != 0)
{
CarId = new SqlParameter("@CarId", myCarChangeRateOnDis.CarId);
}
else
{
CarId = new SqlParameter("@CarId", DBNull.Value);
}
//
if (myCarChangeRateOnDis.ServiceId != 0)
{
ServiceId = new SqlParameter("@ServiceId", myCarChangeRateOnDis.ServiceId);
}
else
{
ServiceId = new SqlParameter("@ServiceId", DBNull.Value);
}
CarChangeRateOnDisList = db.Database
.SqlQuery <CarChangeRateOnDis>("SP_CarChangeRateOnDis @CarId , @ServiceId", CarId, ServiceId).ToList();
foreach (var item in CarChangeRateOnDisList)
{
item.Cars = db.Cars.Where(c => c.id == item.CarId).FirstOrDefault();
item.Services = db.Services.Where(c => c.Id == item.ServiceId).FirstOrDefault();
}
SearchCarChangeRateOnDisList = CarChangeRateOnDisList;
BindGridList();
ClearSearchModel();
}
