public static BOM.watershed_village_data VillageData(watershed_village_data data)
{
double catchment = data.wateravail;
double evaporation = data.water_sarcacity;
data.watershed_village = DAL.VillageDataDal.getVillageById(data.village_id);
double hectre = data.watershed_village.Area * 100;
double m2 = hectre * 100;
//water available
data.wateravail = (m2 * ((data.rainfall * 1000) - (evaporation * 1000)));//in litres
data.waterreq = GetWaterBudget(data).total;
if (data.wateravail > data.waterreq)
{
data.water_sarcacity = data.wateravail - data.waterreq;
}
else
{
data.water_sarcacity = data.waterreq - data.wateravail;
}
return(data);
}
public static watershed_village_data GetVillageDataList(watershed_village_data vil)
{
BOM.watershed_village_data list = DAL.VillageDataDal.getVillageDataById(vil.vd_id);
return(list);
}
public ActionResult GetCropListArea(watershed_policy vil)
{
List <watershed_crop> clist = DAL.CropDal.GetListCrop();
watershed_village_data data = this.Session["villagedata"] as watershed_village_data;
String str = "<option value=''>select</option>";
double area = vil.cultivated_area;
if (area < data.watershed_village.Area)
{
foreach (watershed_crop cr in clist)
{
double waterreq = (cr.waterreq * area * 1000);
if (waterreq < data.waterreq)
{
str += "<option value='" + cr.crop_id + "'>" + cr.cname + waterreq + "</option>";
}
}
}
try
{
return(Json(new
{
msg = "success ",
list = str
}));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult GetCropList(watershed_village_data vil)
{
List <watershed_crop> clist = DAL.CropDal.GetListCrop();
// watershed_village_data data = this.Session["villagedata"] as watershed_village_data;
watershed_village_data data = DAL.VillageDataDal.getVillageDataById(vil.vd_id);
this.Session.Add("villagedata", data);
String str = "<option value=''></option>";
foreach (watershed_crop cr in clist)
{
double waterreq = (cr.waterreq * data.watershed_village.Area * 1000);
if (waterreq < data.waterreq)
{
str += "<option value='" + cr.crop_id + "'>" + cr.cname + waterreq + "</option>";
}
}
try
{
return(Json(new
{
msg = "success ",
list = str
}));
}
catch (Exception ex)
{
throw ex;
}
}
public static WaterShed.Models.WaterBugest GetWaterBudget(watershed_village_data data)
{
//1 gallon 3.785 liter
//50 bath per gallon
int population = data.population;
WaterBugest refs = new WaterBugest {
Bath = (population * 0.14 * 50 * 3.78541), Toilet = (population * 0.14 * 1.6 * 3.78541), clothwashing = (population * 0.14 * 40 * 3.78541), dishwashing = (population * 0.14 * 8.5 * 3.78541), livestock = ((double)data.livestock * 50)
};
refs.total = (refs.Bath + refs.clothwashing + refs.dishwashing + refs.Toilet + refs.livestock) * 365;//for year
return(refs);
}
public static List <watershed_policy> GetPolicyList(watershed_village_data city)
{
watershedEntities db = new watershedEntities();
try
{
return((from u in db.watershed_policy where u.vd_id == city.vd_id select u).ToList());
}
catch (DbEntityValidationException ex)
{
return(null);
}
}
public static List <watershed_policy> GetPolicyYear(watershed_village_data city)
{
watershedEntities db = new watershedEntities();
String year = Convert.ToString(city.cycle_year.Year);
try
{
return((from u in db.watershed_policy where u.vd_id == city.vd_id && u.year.Equals(year) select u).ToList());
}
catch (DbEntityValidationException ex)
{
return(null);
}
}
public ActionResult AddVillageDetail(watershed_village_data data)
{
watershed_village_data village = WaterShed.Models.WaterModel.VillageData(data);
if (DAL.VillageDataDal.AddVillageData(village) == true)
{
ViewData.Add("AddVillageData", "success");
}
else
{
ViewData.Add("AddVillageData", "fail");
}
return View();
}
public ActionResult GetVillageDataList(watershed_village_data vil)
{
String citylist = StateList.GetVillageDataList(vil.village_id);
try
{
return(Json(new
{
msg = "success ",
list = citylist
}));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddVillageData(watershed_village_data city)
{
int i = 0;
MySqlConnection con = null;
MySqlCommand cmd = null;
watershedEntities db = new watershedEntities();
if (null == getVillageData(city.village_id, city.cycle_year))
{
try
{
con = GetMySqlCon();
cmd = GetMySqlCommand(con);
con.Open();
cmd.CommandText = "insert into watershed_village_data (village_id,population,waterreq,rainfall,wateravail,water_sarcacity,cycle_year,livestock,num_families) values(?village_id,?population,?waterreq,?rainfall,?wateravail,?water_sarcacity,?cycle_year,?livestock,?num_families)";
cmd.Parameters.Add(new MySqlParameter("village_id", city.village_id));
cmd.Parameters.Add(new MySqlParameter("population", city.population));
cmd.Parameters.Add(new MySqlParameter("waterreq", city.waterreq));
cmd.Parameters.Add(new MySqlParameter("rainfall", city.rainfall));
cmd.Parameters.Add(new MySqlParameter("wateravail", city.wateravail));
cmd.Parameters.Add(new MySqlParameter("water_sarcacity", city.water_sarcacity));
cmd.Parameters.Add(new MySqlParameter("cycle_year", city.cycle_year));
cmd.Parameters.Add(new MySqlParameter("livestock", city.livestock));
cmd.Parameters.Add(new MySqlParameter("num_families", city.num_families));
i = cmd.ExecuteNonQuery();
}
catch (DbEntityValidationException ex)
{
return(false);
}
finally
{
if (null != con)
{
con.Close();
}
}
}
if (i > 0)
{
return(true);
}
return(false);
}
public ActionResult GetVillageData(watershed_village_data vil)
{
watershed_village_data citylist = StateList.GetVillageDataList(vil);
citylist.watershed_village = DAL.VillageDataDal.getVillageById(citylist.village_id);
this.Session.Add("villagedata", citylist);
try
{
return(Json(new
{
msg = "success ",
wateravail = citylist.wateravail,
water_sarcacity = citylist.water_sarcacity,
cycle_year = citylist.cycle_year.Year.ToString(),
Area = citylist.watershed_village.Area
}));
}
catch (Exception ex)
{
throw ex;
}
}
