public int FarmerCount(string code)
{
DataTable dt = Farmer_DL.FarmerCount(code);
DataRow dr = dt.Rows[0];
return(Convert.ToInt32(dr[0]));
}
public decimal AvaliablePlotArea(string FarmerId, int SeasonID, int Year, int FarmID)
{
DataTable dtFarm = Farmer_DL.AvaliablePlotArea(FarmerId, SeasonID, Year, FarmID);
decimal APA = 0;
if (dtFarm.Rows.Count > 0)
{
APA = Convert.ToDecimal(dtFarm.Rows[0][0].ToString());
}
return(APA);
}
public List <string> FarmerNameCodeArea(string Value)
{
List <string> list = new List <string>();
DataTable dt = Farmer_DL.FarmerNameCodeArea(Value);
foreach (DataRow dr in dt.Rows)
{
list.Add(dr[0].ToString());
}
return(list);
}
private DataTable Questiondata(string Category, string FarmerID, int year)
{
DataTable dtTempp = new DataTable();
DataRow[] drRow = Farmer_DL.GetCheckpointQuestions(FarmerID).Select("Qcategory='" + Category + "' and Year='" + year + "'");
if (drRow.Length > 0)
{
dtTempp = Farmer_DL.GetCheckpointQuestions(FarmerID).Clone();
foreach (DataRow pdr in drRow)
{
DataRow newdr = dtTempp.NewRow();
for (int count = 0; count < pdr.ItemArray.Length; count++)
{
newdr[count] = pdr[count];
}
dtTempp.Rows.Add(newdr);
}
}
return(dtTempp);
}
public DataTable FarmDetails(string FarmerId, bool IsParent)
{
DataTable dtFarm = Farmer_DL.FarmDetails(FarmerId);
DataTable dtFarmResult = dtFarm.Clone();
if (dtFarm.Rows.Count > 0)
{
string condtion = string.Empty;
if (IsParent)
{
condtion = " ParentFarmID = 0";
}
else
{
condtion = " ParentFarmID > 0";
}
DataRow[] drs = dtFarm.Select(condtion);
foreach (DataRow dr in drs)
{
dtFarmResult.ImportRow(dr);
}
}
return(dtFarmResult);
}
//code ends
public DataTable ApprovedFamer_Inspection(bool Approved)
{
return(Farmer_DL.ApprovedFamer_Inspection(Approved));
}
public DataTable GetFarmerDetailsonID(string farmerID)
{
return(Farmer_DL.GetFarmerDetailsonID(farmerID));
}
public DataTable GetAllICSCodes()
{
return(Farmer_DL.GetAllICSCodes());
}
public DataTable FamerDetails(string farmerCode)
{
return(Farmer_DL.FamerDetails(farmerCode));
}
public DataTable GetICSVillagelist(string ICS)
{
return(Farmer_DL.GetICSVillagelist(ICS));
}
public bool FieldRisk_Exist(string FarmerID)
{
return(Farmer_DL.FieldRisk_Exist(FarmerID));
}
public bool FarmerCheckPoints_INSandUPDandDEL(string FarmerID, int QuestionID, int Answer, string Note, string CreatedBy, string ModifiedBy, int TypeOfOperation, int Year)
{
return(Farmer_DL.FarmerCheckPoints_INSandUPDandDEL(FarmerID, QuestionID, Answer, Note, CreatedBy, ModifiedBy, TypeOfOperation, Year));
}
public DataTable Getsubcheckpoints(string QuesID)
{
return(Farmer_DL.Getsubcheckpoints(QuesID));
}
//Code by ravi to get Questions
public DataTable GetYearFarmer(string FarmerID)
{
return(Farmer_DL.GetCheckpointQuestions(FarmerID).DefaultView.ToTable(true, "Year"));
}
public DataTable GetSeasonDetailsBasedFarmerID(string FarmerID, int SeasonYear)
{
return(Farmer_DL.GetSeasonDetailsBasedFarmerID(FarmerID, SeasonYear));
}
public string GetUserICSDetails(Guid userId)
{
return(Farmer_DL.GetUserICSDetails(userId));
}
public DataTable GetFarmerVillageDistinct(string Type)
{
return(Farmer_DL.GetFarmerVillageDistinct(Type));
}
public DataTable FieldRiskResult(string FarmerID)
{
return(Farmer_DL.FiledRiskResult(FarmerID));
}
public DataTable GetEstimationDetails(string Year)
{
return(Farmer_DL.GetEstimationDetails(Year));
}
public bool FiledRiskt_Result_INSandUPDandDEL(int FieldRiskID, string FarmerID, int FarmID, bool Result, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
return(Farmer_DL.FiledRiskt_Result_INSandUPDandDEL(FieldRiskID, FarmerID, FarmID, Result, CreatedBy, ModifiedBy, TypeOfOperation));
}
public DataTable FamerDetails(string farmerName, string farmerCode, string area)
{
return(Farmer_DL.FamerDetails(farmerName, farmerCode, area));
}
public bool FarmerApproval(string FarmerID, string InspectorName, string InspectionComments, string ModifiedBy, int TypeOfOperation, ref bool ReturnValue)
{
return(Farmer_DL.FarmerApproval(FarmerID, InspectorName, InspectionComments, ModifiedBy, TypeOfOperation, ref ReturnValue));
}
public DataTable FamerDetailsByIcs(string icsCode)
{
return(Farmer_DL.FamerDetailsByIcs(icsCode));
}
public DataTable GetFarmerProductDetailsBasedonYear(string FarmerID, int SeasonYear)
{
return(Farmer_DL.GetFarmerProductDetailsBasedonYear(FarmerID, SeasonYear));
}
public DataTable FarmerDetails(string Village)
{
return(Farmer_DL.FarmerDetails(Village));
}
public DataTable GetFarmerProdcts(int SeasonYear, int seasonID, int productID, string Village, string ICStype)
{
return(Farmer_DL.GetFarmerProdcts(SeasonYear, seasonID, productID, Village, ICStype));
}
//ravi code for detailed view on 24-marc-13
public DataTable FamerDetailDetails()
{
return(Farmer_DL.FamerDetailDetails());
}
public DataTable GetFarmerlistVillagewise(string Village)
{
return(Farmer_DL.GetFarmerlistVillagewise(Village));
}
private void BindgvPlan(int year, decimal DaysPerFarmer, DateTime start, DateTime end, string role)
{
try
{
DataTable dtNewPlan = new DataTable();
dtNewPlan.Columns.Add("FarmerID");
dtNewPlan.Columns.Add("FarmerName");
dtNewPlan.Columns.Add("FarmerCode");
dtNewPlan.Columns.Add("FarmerArea");
dtNewPlan.Columns.Add("InspectorID");
dtNewPlan.Columns.Add("InspectorName");
dtNewPlan.Columns.Add("PlanDate");
dtNewPlan.Columns.Add("VisitedDate");
dtNewPlan.Columns.Add("InspectionID");
List <DateTime> dates = GetDates(year, start, end);
DataTable dtHolidays = InspectionPlan_DL.Holidays(year, start, end);
foreach (DataRow item in dtHolidays.Rows)
{
string stDate = Convert.ToString(item["HolidayDate"]);
if (stDate.Contains("/"))
{
string[] keys = stDate.Split('/');
DateTime hdate = new DateTime(Convert.ToInt32(keys[2]), Convert.ToInt32(keys[0]), Convert.ToInt32(keys[1]));
if (hdate.DayOfWeek != DayOfWeek.Sunday && dates.Contains(hdate))
{
dates.Remove(new DateTime(Convert.ToInt32(keys[2]), Convert.ToInt32(keys[0]), Convert.ToInt32(keys[1])));
}
}
}
dates = dates.OrderBy(m => m).ToList();
List <int> months = dates.Select(m => m.Month).Distinct().ToList();
DataTable farmervillages = UnitInformation_DL.FarmersVillageListByIcs("ICS02");
int c = farmervillages.Rows.Count;
List <MudarVillage> villages = new List <MudarVillage>();
foreach (DataRow item in farmervillages.Rows)
{
MudarVillage village = new MudarVillage();
village.VillageName = Convert.ToString(item["City_Village"]);
DataTable dtFarmer = Farmer_DL.GetFarmerlistVillagewise(village.VillageName);
List <MudarFarmer> farmers = new List <MudarFarmer>();
for (int j = 0; j < dtFarmer.Rows.Count; j++)
{
MudarFarmer farmer = new MudarFarmer();
farmer.FarmerID = Convert.ToString(dtFarmer.Rows[j]["FarmerID"]);
farmer.FirstName = Convert.ToString(dtFarmer.Rows[j]["FirstName"]);
farmer.FarmerCode = Convert.ToString(dtFarmer.Rows[j]["FarmerCode"]);
farmer.IsVisited = false;
farmers.Add(farmer);
}
int[] visitMonths = ShareEqual(farmers.Count, months.Count);
int mn = 0;
int skip = 0;
foreach (var vm in months)
{
farmers.Skip(skip).Take(visitMonths[mn]).ToList().ForEach(m => m.VisitedMonth = vm);
skip = skip + visitMonths[mn];
mn = mn + 1;
}
village.Farmers = farmers;
villages.Add(village);
}
DataTable EmployeeTable = BranchsRolesEmployees_DL.GetEmployeBasedonRoleID(role);
List <MudarEmployee> emps = new List <MudarEmployee>();
foreach (DataRow item in EmployeeTable.Rows)
{
MudarEmployee emp = new MudarEmployee();
emp.EmployeeID = new Guid(Convert.ToString(item["EmployeeId"]));
emp.EmployeeName = Convert.ToString(item["EmployeeFristName"]);
emps.Add(emp);
}
List <MudarPlanModel> newPlans = new List <MudarPlanModel>();
foreach (var mnth in months)
{
List <DateTime> monthDates = dates.Where(m => m.Month == mnth && m.Year == year).ToList();
int mod = Convert.ToInt32((monthDates.Count) / c);
int l = Convert.ToInt32((monthDates.Count) % c);
villages.ForEach(m => m.loopCount = mod);
for (int i = 0; i < l; i++)
{
villages[i].loopCount += 1;
}
int h = 0;
foreach (var item in villages)
{
List <MudarFarmer> listFarmers = item.Farmers.Where(m => m.VisitedMonth == mnth).ToList();
int[] farmerVisitedPerInsp = ShareEqual(listFarmers.Count, emps.Count);
int f = 0;
foreach (var item1 in emps)
{
int[] timesVisit = ShareEqual(farmerVisitedPerInsp[f], item.loopCount);
int k = h;
foreach (var visit in timesVisit)
{
List <MudarFarmer> visitFarmers = listFarmers.Where(m => m.IsVisited == false).Take(visit).ToList();
foreach (var farm in visitFarmers)
{
MudarPlanModel plan = new MudarPlanModel();
plan.FarmerID = farm.FarmerID;
plan.FarmerName = farm.FirstName;
plan.FarmerCode = farm.FarmerCode;
plan.VillageName = item.VillageName;
plan.InspectorCode = item1.EmployeeID;
plan.InspectorName = item1.EmployeeName;
plan.PlanDate = monthDates[k];
plan.VisitedDate = monthDates[k];
var empCheck = newPlans.Where(m => m.PlanDate.ToShortDateString() == plan.PlanDate.ToShortDateString() && m.VillageName == plan.VillageName && m.InspectorName != plan.InspectorName).ToList();
if (empCheck.Count <= 0)
{
newPlans.Add(plan);
}
}
listFarmers.Where(m => m.IsVisited == false).Take(visit).ToList().ForEach(m => m.IsVisited = true);
k = k + villages.Count;
if (k >= monthDates.Count)
{
k = 0;
}
}
f = f + 1;
h = h + 1;
}
h = h - 1;
item.Farmers.Where(m => m.VisitedMonth == mnth).ToList().ForEach(m => m.IsVisited = true);
}
}
newPlans = newPlans.OrderBy(m => m.PlanDate).ToList();
foreach (var item in newPlans)
{
DataRow newrow = dtNewPlan.NewRow();
newrow["FarmerID"] = item.FarmerID;
newrow["FarmerName"] = item.FarmerName;
newrow["FarmerCode"] = item.FarmerCode;
newrow["FarmerArea"] = item.VillageName;
newrow["InspectorID"] = item.InspectorCode;
newrow["InspectorName"] = item.InspectorName;
newrow["PlanDate"] = item.PlanDate.ToShortDateString();
newrow["VisitedDate"] = item.VisitedDate.ToShortDateString();
dtNewPlan.Rows.Add(newrow);
}
dt = dtNewPlan;
if (dt.Rows.Count > 0)
{
Session["Inspec"] = string.Empty;
Session["Inspec"] = dt;
lblFarmers.Text = dt.Rows.Count.ToString();
divShowPlanDetails.Visible = true;
btnSubmit.Visible = true;
gvPlan.DataSource = dt;
gvPlan.DataBind();
}
else
{
Response.Write("<script>alert('No Data Found for InspectionPlan !!!!'</script>");
}
}
catch (Exception ex)
{
Session["ErrorMsg"] = ex.Message;
Response.Redirect("~/NoAccess.aspx", false);
}
}
public DataTable GetFarmerFarmDetails(string FarmerID, string Year)
{
return(Farmer_DL.GetFarmerFarmDetails(FarmerID, Year));
}
