public DataSet populateGreenTableUsingMileage(GoGreen gg)
{
string quertstring = "select top 50 2011,model,cyl,trans,drive,fuel,stnddescription,VehClass,AirPollutionScore,CityMPG,HwyMPG,CmbMPG,GreenHouseScore " +
"from snehav27.FUEL_ECONOMY_DATA_2011 where " + gg.cityappendwhere + gg.highappendwhere + gg.cmbappendwhere +
" UNION ALL " +
"select top 50 2012,model,cyl,trans,drive,fuel,stnddescription,VehClass,AirPollutionScore,CityMPG,HwyMPG,CmbMPG,GreenHouseScore " +
"from snehav27.FUEL_ECONOMY_DATA_2012 where " + gg.cityappendwhere + gg.highappendwhere + gg.cmbappendwhere +
" UNION ALL " +
"select top 50 2013,model,cyl,trans,drive,fuel,stnddescription,VehClass,AirPollutionScore,CityMPG,HwyMPG,CmbMPG,GreenHouseScore " +
"from snehav27.FUEL_ECONOMY_DATA_2013 where " + gg.cityappendwhere + gg.highappendwhere + gg.cmbappendwhere +
" UNION ALL " +
"select top 50 2014,model,cyl,trans,drive,fuel,stnddescription,VehClass,AirPollutionScore,CityMPG,HwyMPG,CmbMPG,GreenHouseScore " +
"from snehav27.FUEL_ECONOMY_DATA_2014 where " + gg.cityappendwhere + gg.highappendwhere + gg.cmbappendwhere +
" UNION ALL " +
"select top 50 2015,model,cyl,trans,drive,fuel,stnddescription,VehClass,AirPollutionScore,CityMPG,HwyMPG,CmbMPG,GreenHouseScore " +
"from snehav27.FUEL_ECONOMY_DATA_2015 where " + gg.cityappendwhere + gg.highappendwhere + gg.cmbappendwhere;
SqlConnection con = new SqlConnection(connstring);
con.Open();
SqlCommand cmd = new SqlCommand(quertstring, con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
return(ds);
}
protected void displayinfo3(object sender, EventArgs e)
{
Boolean greenScore = radiobuttonGrhs.Checked;
Boolean airPolutionScore = radiobuttonArp.Checked;
String score = scoreText.Text;
if (greenScore || airPolutionScore)
{
GoGreen gg = new GoGreen(score, greenScore, airPolutionScore);
DataSet ds = ggDAO.populateGreenTableUsingGreenScore(gg);
if (ds.Tables[0].Rows.Count == 0)
{
GridView3.DataSource = null;
GridView3.DataBind();
GoGreenError.Text = "There is no data available in DB. Please try with other input";
return;
}
else
{
GoGreenError.Text = "";
GridView3.DataSource = ds.Tables[0];
GridView3.DataBind();
}
}
else
{
}
}
public DataTable populateCarnameDropdown(GoGreen gg)
{
string selectString = "SELECT distinct Model FROM snehav27.FUEL_ECONOMY_DATA_" + gg.year;
SqlDataAdapter adpt = new SqlDataAdapter(selectString, connstring);
DataTable dt = new DataTable();
adpt.Fill(dt);
return(dt);
}
public void GoGreenReqNullCheckinTest()
{
DateTime checkIn = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime ggRequest = checkIn.AddDays(2);
GoGreen gg = new GoGreen();
GoGreenRequest ggr = new GoGreenRequest(gg, "Sally Sea", 113, checkIn, null);
Assert.IsTrue(ggr.Under7Days());
}
public void GoGreenReqNullMessageTest()
{
DateTime checkIn = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime ggRequest = checkIn.AddDays(2);
GoGreen gg = new GoGreen();
GoGreenRequest ggr = new GoGreenRequest(gg, "", 113, checkIn, null);
Assert.IsNotNull(ggr.TextHouseKeeping(null));
}
public void GoGreenReqOver7DaysTest()
{
DateTime checkIn = new DateTime(2018, 4, 01, 7, 47, 0);
DateTime lastCleaning = DateTime.Today.AddDays(-8);
DateTime ggRequest = checkIn.AddDays(8);
GoGreen gg = new GoGreen();
GoGreenRequest ggr = new GoGreenRequest(gg, "Sally Sea", 113, checkIn, lastCleaning, "Best hotel ever!");
Assert.IsFalse(ggr.Under7Days());
}
public void GoGreenReqDoNotDisturbTest()
{
DateTime checkIn = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime ggRequest = checkIn.AddDays(2);
GoGreen gg = new GoGreen();
GoGreenRequest ggr = new GoGreenRequest(gg, "Sally Sea", 113, checkIn, null);
ggr.CheckDoNotDisturb("I'm good on towels. Thanks! Do not distrub.");
bool t = gg.DoNotDisturbRooms.Contains(ggr.RoomNumber);
Assert.IsTrue(t);
}
public void GoGreenReqInitTest()
{
//Arrange
DateTime checkIn = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime lastCleaning = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime ggRequest = checkIn.AddDays(2);
GoGreen gg = new GoGreen();
//Act
GoGreenRequest ggr = new GoGreenRequest(gg, "Sally Sea", 113, checkIn, lastCleaning, "Best hotel ever!");
//Assert
Assert.IsTrue(ggr.Under7Days());
}
public void GoGreenReqNullTest()
{
//Arrance
DateTime checkIn = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime lastCleaning = new DateTime(2018, 4, 20, 7, 47, 0);
DateTime ggRequest = checkIn.AddDays(2);
GoGreen gg = new GoGreen();
//Act
GoGreenRequest ggr = new GoGreenRequest(gg, "Sally Sea", 113, checkIn, lastCleaning, "Best hotel ever!");
//Assert
Assert.IsNotNull(ggr);
}
public DataSet populateGreenTable(GoGreen gg)
{
SqlConnection con = new SqlConnection(connstring);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT distinct Model,Cyl,Fuel,VehClass,AirPollutionScore,CityMPG,HwyMPG,CmbMPG,GreenHouseScore FROM snehav27.FUEL_ECONOMY_DATA_" + gg.year + " where Model = @CarName", con);
cmd.Parameters.Add("@CarName", gg.carname);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
return(ds);
}
protected void displayinfo(object sender, EventArgs e)
{
String value = names.SelectedItem.Text;
String value2 = year.SelectedItem.Text;
GoGreen gg = new GoGreen(value, value2);
if (value == "---Select---")
{
// Result.Attributes.Add("style", "visibility: hidden");
}
else
{
DataSet ds = ggDAO.populateGreenTable(gg);
DetailsGridView.DataSource = ds.Tables[0];
DetailsGridView.DataBind();
}
}
protected void displaydropdown2(object sender, EventArgs e)
{
names.Items.Clear();
String value = year.SelectedItem.Text;
Console.WriteLine("cameeee heree");
GoGreen gg = new GoGreen("", value);
if (value == "Select Year")
{
// Result.Attributes.Add("style", "visibility: hidden");
}
else
{
names.DataSource = ggDAO.populateCarnameDropdown(gg);
names.DataTextField = "Model";
names.DataValueField = "Model";
names.DataBind();
names.Items.Insert(0, new ListItem("---Select---", "initial"));
names.SelectedValue = "initial";
}
}
public void GoGreenInitTest()
{
GoGreen gg = new GoGreen();
Assert.IsNotNull(gg.DoNotDisturbRooms);
}
protected void displayinfo2(object sender, EventArgs e)
{
String cityMPG = TextBox1.Text;
String highMPG = TextBox2.Text;
String cmbMPG = TextBox3.Text;
if (cityMPG == "" && highMPG == "" && cmbMPG == "")
{
//Result.Attributes.Add("style", "visibility: hidden");
}
else
{
string cityappendwhere = "";
string highappendwhere = "";
string cmbappendwhere = "";
if (cityMPG != "")
{
cityappendwhere = "cityMPG =" + cityMPG;
}
else
{
cityappendwhere = "";
}
if (highMPG != "" && cityMPG != "")
{
highappendwhere = " and HwyMPG = " + highMPG;
}
else if (highMPG != "")
{
highappendwhere = " HwyMPG = " + highMPG;
}
else
{
highappendwhere = "";
}
if (cmbMPG != "" && (highMPG != "" || cityMPG != ""))
{
cmbappendwhere = " and cmbMPG = " + cmbMPG;
}
else if (cmbMPG != "")
{
cmbappendwhere = " cmbMPG = " + cmbMPG;
}
else
{
cmbappendwhere = "";
}
GoGreen gg = new GoGreen(cityappendwhere, highappendwhere, cmbappendwhere);
DataSet ds = ggDAO.populateGreenTableUsingMileage(gg);
if (ds.Tables[0].Rows.Count == 0)
{
GridView2.DataSource = null;
GridView2.DataBind();
GoGreenError.Text = "There is no data available in DB. Please try with other input";
return;
}
else
{
GoGreenError.Text = "";
GridView2.DataSource = ds.Tables[0];
GridView2.DataBind();
}
}
}
