public ActionResult BasicInformationOfAffectedPersonStepFour(BasicInformationOfAffectedPerson affectedPerson)
{
int message = affectedPersonManager.SaveBasicInformationOfAffectedPersonStep4(affectedPerson);
ViewBag.Message = "Successfully Save All Information";
return(View());
//return RedirectToAction("FamilyAffectedLandUsedInformation", "FamilyAffectedLandUsedInformation", new { id = affectedPerson.NidCardNumber });
}
public ActionResult BasicInformationOfAffectedPersonStepTwo(BasicInformationOfAffectedPerson affectedPerson)
{
int message = affectedPersonManager.SaveBasicInformationOfAffectedPersonStep2(affectedPerson);
ViewBag.Message = "";
//eturn View();
return(RedirectToAction("FamilyAffectedLandInformation", "FamilyAffectedLandInformation", new { id = affectedPerson.NidCardNumber }));
}
public ActionResult BasicInformationOfAffectedPerson(BasicInformationOfAffectedPerson affectedPerson)
{
int row = affectedPersonManager.SaveBasicInformationOfAffectedPerson(affectedPerson);
int uniqueId = affectedPersonManager.GetuniqueId(affectedPerson.NidCardNumber, affectedPerson.NameOfAffectedPerson, affectedPerson.PhoneNo);
return(RedirectToAction("SocialEconomicInformationAndData", "SocialEconomicInformationAndData", new { id = uniqueId }));
}
public int SaveBasicInformationOfAffectedPersonStep3(BasicInformationOfAffectedPerson aData)
{
Query = @"UPDATE BasicInformationOfAffectedPerson SET DoYouHaveLandLease='" + aData.DoYouHaveLandLease + "',HowManyYears='" + aData.HowManyYears + "',HowMuchMoney='" + aData.HowMuchMoney + "' WHERE ID= " + aData.Id;
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public int SaveBasicInformationOfAffectedPersonStep4(BasicInformationOfAffectedPerson aData)
{
Query = @"UPDATE BasicInformationOfAffectedPerson SET FamilyStatus='" + aData.FamilyStatus + "',HowDoesTheCostCarryingOut='"
+ aData.HowDoesTheCostCarryingOut + "',CreditResponsibility='" + aData.CreditResponsibility + "',CreditResponsibilityMoney='" + aData.CreditResponsibilityMoney + "' ,CreditResponsibilityReceivedForm='" + aData.CreditResponsibilityReceivedForm + "',GovernmentBuysCompensation='"
+ aData.GovernmentBuysCompensation + "',HowCanYouCompensationMoney='" + aData.HowCanYouCompensationMoney + "',DoYouHaveNeedAnyCommittee='" + aData.DoYouHaveNeedAnyCommittee + "',ListOfCommitteeMembers='" + aData.ListOfCommitteeMembers + "',MainProblemOfYouTerritory='" + aData.MainProblemOfYouTerritory + "',BenefitAfterCompleteProject='" + aData.BenefitAfterCompleteProject
+ "',DifficultyAfterCompleteProject='" + aData.DifficultyAfterCompleteProject + "',AdviseToRemoveDifficulty='" + aData.AdviseToRemoveDifficulty + "',DataCollectorFeedback='" + aData.DataCollectorFeedback + "' WHERE ID= " + aData.Id;
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public ActionResult UpdateDetailsInformation([Bind] BasicInformationOfAffectedPerson affectedPerson, [Bind(Include = "BasicInformationOfAffectedPersonNid,JlNo,PlotNo,TotalAcquiedLand,OwnershipPattern,MarketPriceOfAcquiredLand,PresentLandUsePattern")] List <FamilyAffectedLandInformation> data, List <IsAffectedLandUnderShare> data2, List <FamilyAffectedLandUsedInformation> data3)
{
//foreach (var aData in data)
//{
// long a=aData.BasicInformationOfAffectedPersonNid;
//}
string message = "";
int count = affectedPersonManager.UpdateAllBasicInformationOfAffectedPerson(affectedPerson);
if (count > 0)
{
message = "Successfully Update Information";
}
return(RedirectToAction("ShowDetailsInformation", "ShowDetailsInformation", new { id = message }));
}
public int SaveBasicInformationOfAffectedPerson(BasicInformationOfAffectedPerson affectedPerson)
{
//string message = "";
//bool isNidCardNumberExits = affectedPersonGateway.IsNidCardNumberExits(affectedPerson.NidCardNumber);
//if (isNidCardNumberExits)
//{
// message = "Nid Card Number Already Exits";
//}
//else
//{
// affectedPersonGateway.SaveBasicInformationOfAffectedPerson(affectedPerson);
//}
return(affectedPersonGateway.SaveBasicInformationOfAffectedPerson(affectedPerson));
}
public int UpdateAllBasicInformationOfAffectedPerson(BasicInformationOfAffectedPerson aData)
{
Query = @"UPDATE BasicInformationOfAffectedPerson SET HouseHoldSlNo='" + aData.HouseHoldSlNo + "',NameOfSs='" + aData.NameOfSs + "',NameOfAffectedPerson='" + aData.NameOfAffectedPerson +
"',InsertDate='" + aData.Date + "',NidCardNumber='" + aData.NidCardNumber + "',PhoneNo='" + aData.PhoneNo +
"',HusbandOrFathersNameOfAffectedPerson='" + aData.HusbandOrFathersNameOfAffectedPerson + "',NameOfHeadOfTheFamily='" + aData.NameOfHeadOfTheFamily +
"',GenderNameOfHeadOfTheFamily='" + aData.GenderNameOfHeadOfTheFamily + "',DistrictName='" + aData.District + "',UpazillaName='" + aData.Upazilla + "',UnionName='" + aData.Union +
"',MauzaName='" + aData.Mauza + "',Ward='" + aData.Ward + "',VillageName='" + aData.Village + "',ProfessionOfAffectedPerson='" + aData.ProfessionOfAffectedPerson +
"',TypesOfAffectedPeople='" + aData.TypesOfAffectedPeople + "', FamilyDrinkingWaterDetails='" + aData.FamilyDrinkingWaterDetails + "',FamilyBathroomDetails='" + aData.FamilyBathroomDetails + "',AreYouAwareOfTheProposedProject='" + aData.AreYouAwareOfTheProposedProject + "', DoYouHaveLandLease='" + aData.DoYouHaveLandLease + "',HowManyYears='" + aData.HowManyYears + "',HowMuchMoney='" + aData.HowMuchMoney + "'" +
",FamilyStatus='" + aData.FamilyStatus + "',HowDoesTheCostCarryingOut='"
+ aData.HowDoesTheCostCarryingOut + "',CreditResponsibility='" + aData.CreditResponsibility + "',CreditResponsibilityMoney='" + aData.CreditResponsibilityMoney + "' ,CreditResponsibilityReceivedForm='" + aData.CreditResponsibilityReceivedForm + "',GovernmentBuysCompensation='"
+ aData.GovernmentBuysCompensation + "',HowCanYouCompensationMoney='" + aData.HowCanYouCompensationMoney + "',DoYouHaveNeedAnyCommittee='" + aData.DoYouHaveNeedAnyCommittee + "',ListOfCommitteeMembers='" + aData.ListOfCommitteeMembers + "',MainProblemOfYouTerritory='" + aData.MainProblemOfYouTerritory + "',BenefitAfterCompleteProject='" + aData.BenefitAfterCompleteProject
+ "',DifficultyAfterCompleteProject='" + aData.DifficultyAfterCompleteProject + "',AdviseToRemoveDifficulty='" + aData.AdviseToRemoveDifficulty + "',DataCollectorFeedback='" + aData.DataCollectorFeedback + "' WHERE ID=" + aData.Id;
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public int SaveBasicInformationOfAffectedPerson(BasicInformationOfAffectedPerson affectedPerson)
{
Query = @"INSERT INTO BasicInformationOfAffectedPerson(HouseHoldSlNo,NameOfSs,NameOfAffectedPerson,InsertDate,NidCardNumber,PhoneNo,HusbandOrFathersNameOfAffectedPerson,NameOfHeadOfTheFamily,GenderNameOfHeadOfTheFamily,DistrictName,UpazillaName,UnionName,MauzaName,Ward,VillageName,ProfessionOfAffectedPerson,TypesOfAffectedPeople,FamilyDrinkingWaterDetails,FamilyBathroomDetails,
AreYouAwareOfTheProposedProject
,DoYouHaveLandLease,HowManyYears,HowMuchMoney,FamilyStatus,HowDoesTheCostCarryingOut,
CreditResponsibility,CreditResponsibilityMoney,CreditResponsibilityReceivedForm,
GovernmentBuysCompensation,HowCanYouCompensationMoney,DoYouHaveNeedAnyCommittee,ListOfCommitteeMembers,
MainProblemOfYouTerritory,BenefitAfterCompleteProject,
DifficultyAfterCompleteProject,AdviseToRemoveDifficulty,DataCollectorFeedback)
VALUES('" + affectedPerson.HouseHoldSlNo + "','" + affectedPerson.NameOfSs + "','" + affectedPerson.NameOfAffectedPerson + "','" + affectedPerson.Date + "','"
+ affectedPerson.NidCardNumber + "','" + affectedPerson.PhoneNo + "','" + affectedPerson.HusbandOrFathersNameOfAffectedPerson + "','" + affectedPerson.NameOfHeadOfTheFamily + "','" + affectedPerson.GenderNameOfHeadOfTheFamily + "'," +
"'" + affectedPerson.District + "','" + affectedPerson.Upazilla + "','" + affectedPerson.Union + "','" + affectedPerson.Mauza + "','" + affectedPerson.Ward + "','" + affectedPerson.Village + "','" + affectedPerson.ProfessionOfAffectedPerson + "','" + affectedPerson.TypesOfAffectedPeople + "','" + affectedPerson.FamilyDrinkingWaterDetails + "','" + affectedPerson.FamilyBathroomDetails + "','" + affectedPerson.AreYouAwareOfTheProposedProject +
"','" + affectedPerson.DoYouHaveLandLease + "','" + affectedPerson.HowManyYears + "','" + affectedPerson.HowMuchMoney + "','" + affectedPerson.FamilyStatus + "','" + affectedPerson.HowDoesTheCostCarryingOut +
"','" + affectedPerson.CreditResponsibility + "','" + affectedPerson.CreditResponsibilityMoney + "','" + affectedPerson.CreditResponsibilityReceivedForm + "','" + affectedPerson.GovernmentBuysCompensation +
"','" + affectedPerson.HowCanYouCompensationMoney + "','" + affectedPerson.DoYouHaveNeedAnyCommittee + "','" + affectedPerson.ListOfCommitteeMembers + "','" + affectedPerson.MainProblemOfYouTerritory + "','" +
affectedPerson.BenefitAfterCompleteProject + "','" + affectedPerson.DifficultyAfterCompleteProject + "','" + affectedPerson.AdviseToRemoveDifficulty + "','" + affectedPerson.DataCollectorFeedback + "')";
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public List <BasicInformationOfAffectedPerson> GetAllBasicInformationOfAffectedPerson(int nidCardNumber)
{
List <BasicInformationOfAffectedPerson> alistOfInfo = new List <BasicInformationOfAffectedPerson>();
Query = "SELECT * FROM BasicInformationOfAffectedPerson WHERE ID=@nidCardNumber";
Connection.Open();
Command.Parameters.Clear();
Command.Parameters.Add("nidCardNumber", SqlDbType.VarChar);
Command.Parameters["nidCardNumber"].Value = nidCardNumber;
Command.CommandText = Query;
Command.CommandText = Query;
Reader = Command.ExecuteReader();
while (Reader.Read())
{
int id = Convert.ToInt32(Reader["ID"]);
int houseHoldSlNo = Convert.ToInt32(Reader["HouseHoldSlNo"]);
string nameOfSs = Reader["NameOfSs"].ToString();
string nameOfAffectedPerson = Reader["NameOfAffectedPerson"].ToString();
DateTime date = Convert.ToDateTime(Reader["InsertDate"]);
long nidCardNumbers = Convert.ToInt64(Reader["NidCardNumber"]);
string phoneNo = Reader["PhoneNo"].ToString();
string husbandOrFathersNameOfAffectedPerson = Reader["HusbandOrFathersNameOfAffectedPerson"].ToString();
string nameOfHeadOfTheFamily = Reader["NameOfHeadOfTheFamily"].ToString();
string genderNameOfHeadOfTheFamily = Reader["GenderNameOfHeadOfTheFamily"].ToString();
string district = Reader["DistrictName"].ToString();
string upazilla = Reader["UpazillaName"].ToString();
string union = Reader["UnionName"].ToString();
string mauza = Reader["MauzaName"].ToString();
string ward = Reader["Ward"].ToString();
string village = Reader["VillageName"].ToString();
string professionOfAffectedPerson = Reader["ProfessionOfAffectedPerson"].ToString();
string typesOfAffectedPeople = Reader["TypesOfAffectedPeople"].ToString();
string familyDrinkingWaterDetails = Reader["FamilyDrinkingWaterDetails"].ToString();
string familyBathroomDetails = Reader["FamilyBathroomDetails"].ToString();
string areYouAwareOfTheProposedProject = Reader["AreYouAwareOfTheProposedProject"].ToString();
string doYouHaveLandLease = Reader["DoYouHaveLandLease"].ToString();
string howManyYears = Reader["HowManyYears"].ToString();
string howMuchMoney = Reader["HowMuchMoney"].ToString();
string familyStatus = Reader["FamilyStatus"].ToString();
string howDoesTheCostCarryingOut = Reader["HowDoesTheCostCarryingOut"].ToString();
string creditResponsibility = Reader["CreditResponsibility"].ToString();
string creditResponsibilityMoney = Reader["CreditResponsibilityMoney"].ToString();
string creditResponsibilityReceivedForm = Reader["CreditResponsibilityReceivedForm"].ToString();
string governmentBuysCompensation = Reader["GovernmentBuysCompensation"].ToString();
string howCanYouCompensationMoney = Reader["HowCanYouCompensationMoney"].ToString();
string doYouHaveNeedAnyCommittee = Reader["DoYouHaveNeedAnyCommittee"].ToString();
string listOfCommitteeMembers = Reader["ListOfCommitteeMembers"].ToString();
string mainProblemOfYouTerritory = Reader["MainProblemOfYouTerritory"].ToString();
string benefitAfterCompleteProject = Reader["BenefitAfterCompleteProject"].ToString();
string difficultyAfterCompleteProject = Reader["DifficultyAfterCompleteProject"].ToString();
string adviseToRemoveDifficulty = Reader["AdviseToRemoveDifficulty"].ToString();
string dataCollectorFeedback = Reader["DataCollectorFeedback"].ToString();
BasicInformationOfAffectedPerson aData = new BasicInformationOfAffectedPerson(id, houseHoldSlNo,
nameOfSs, nameOfAffectedPerson, date, nidCardNumbers, phoneNo, husbandOrFathersNameOfAffectedPerson,
nameOfHeadOfTheFamily, genderNameOfHeadOfTheFamily, district, upazilla, union, mauza, ward, village,
professionOfAffectedPerson, typesOfAffectedPeople, familyDrinkingWaterDetails, familyBathroomDetails,
areYouAwareOfTheProposedProject, doYouHaveLandLease, howManyYears, howMuchMoney, familyStatus,
howDoesTheCostCarryingOut, creditResponsibility, creditResponsibilityMoney,
creditResponsibilityReceivedForm, governmentBuysCompensation, howCanYouCompensationMoney,
doYouHaveNeedAnyCommittee, listOfCommitteeMembers, mainProblemOfYouTerritory,
benefitAfterCompleteProject, difficultyAfterCompleteProject, adviseToRemoveDifficulty,
dataCollectorFeedback);
alistOfInfo.Add(aData);
}
Reader.Close();
Connection.Close();
return(alistOfInfo);
}
public ActionResult BasicInformationOfAffectedPersonStepThree(List <IsAffectedLandUnderShare> data, BasicInformationOfAffectedPerson affectedPerson)
{
foreach (var ta in data)
{
if (ta.JlNo != "" && ta.JlNo != null)
{
affectedPersonManager.SaveIsAffectedLandUnderShare(ta);
}
}
int message = affectedPersonManager.SaveBasicInformationOfAffectedPersonStep3(affectedPerson);
ViewBag.Message = "";
// return View();
return(RedirectToAction("FamilyAffectedLandUsedInformation", "FamilyAffectedLandUsedInformation", new { id = affectedPerson.NidCardNumber }));
}
public int SaveBasicInformationOfAffectedPersonStep4(BasicInformationOfAffectedPerson aData)
{
return(affectedPersonGateway.SaveBasicInformationOfAffectedPersonStep4(aData));
}
public int UpdateAllBasicInformationOfAffectedPerson(BasicInformationOfAffectedPerson aData)
{
return(affectedPersonGateway.UpdateAllBasicInformationOfAffectedPerson(aData));
}
