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)); }