public int SaveOthersInformation(OthersInformation aData)
{
Query = @"INSERT INTO OthersInformation(BasicInformationOfAffectedPersonNid,FamilyDrinkingWaterDetails,FamilyBathroomDetails,
AreYouAwareOfTheProposedProject
,DoYouHaveLandLease,HowManyYears,HowMuchMoney,
FamilyStatus,HowDoesTheCostCarryingOut,
CreditResponsibility,CreditResponsibilityMoney,CreditResponsibilityReceivedForm,
GovernmentBuysCompensation,HowCanYouCompensationMoney,DoYouHaveNeedAnyCommittee,ListOfCommitteeMembers,
MainProblemOfYouTerritory,BenefitAfterCompleteProject,
DifficultyAfterCompleteProject,AdviseToRemoveDifficulty,DataCollectorFeedback)
VALUES('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.FamilyDrinkingWaterDetails + "','" + aData.FamilyBathroomDetails + "','" + aData.AreYouAwareOfTheProposedProject +
"','" + aData.DoYouHaveLandLease + "','" + aData.HowManyYears + "','" + aData.HowMuchMoney + "','" + aData.FamilyStatus + "','" + aData.HowDoesTheCostCarryingOut +
"','" + aData.CreditResponsibility + "','" + aData.CreditResponsibilityMoney + "','" + aData.CreditResponsibilityReceivedForm + "','" + aData.GovernmentBuysCompensation +
"','" + aData.HowCanYouCompensationMoney + "','" + aData.DoYouHaveNeedAnyCommittee + "','" + aData.ListOfCommitteeMembers + "','" + aData.MainProblemOfYouTerritory + "','" +
aData.BenefitAfterCompleteProject + "','" + aData.DifficultyAfterCompleteProject + "','" + aData.AdviseToRemoveDifficulty + "','" + aData.DataCollectorFeedback + "')";
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public ActionResult OthersInformation(OthersInformation aData)
{
int row = affectedPersonManager.SaveOthersInformation(aData);
ViewBag.Message = "Succesfully Saved " + row + " Informatoin";
return(View());
}
public int SaveOthersInformation(OthersInformation aData)
{
return(affectedPersonGateway.SaveOthersInformation(aData));
}
