public List <FamilyAffectedLandUsedInformation> GetAllFamilyAffectedLandUsedInformation(int qid) { List <FamilyAffectedLandUsedInformation> aList = new List <FamilyAffectedLandUsedInformation>(); Query = @"SELECT * FROM FamilyAffectedLandUsedInformation WHERE BasicInformationOfAffectedPersonNid='" + qid + "'"; Connection.Open(); Command.CommandText = Query; Reader = Command.ExecuteReader(); while (Reader.Read()) { long id = Convert.ToInt64(Reader["BasicInformationOfAffectedPersonNid"]); string jlNo = Reader["JlNo"].ToString(); string plotNo = Reader["PlotNo"].ToString(); string totalAcquiedLand = Reader["LandElevation"].ToString(); string ownershipPattern = Reader["LandUse"].ToString(); string marketPriceOfAcquiredLand = Reader["PriceOfOthersAssets"].ToString(); FamilyAffectedLandUsedInformation aData = new FamilyAffectedLandUsedInformation(); aData.BasicInformationOfAffectedPersonNid = id; aData.JlNo = jlNo; aData.PlotNo = plotNo; aData.LandElevation = totalAcquiedLand; aData.LandUse = ownershipPattern; aData.PriceOfOthersAssets = marketPriceOfAcquiredLand; aList.Add(aData); } Connection.Close(); return(aList); }
public int SaveFamilyAffectedLandUsedInformation(FamilyAffectedLandUsedInformation aData) { Query = @"INSERT INTO FamilyAffectedLandUsedInformation(BasicInformationOfAffectedPersonNid,JlNo,PlotNo,LandElevation,LandUse,PriceOfOthersAssets) VALUES('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.JlNo + "','" + aData.PlotNo + "','" + aData.LandElevation + "','" + aData.LandUse + "','" + aData.PriceOfOthersAssets + "')"; Connection.Open(); Command.CommandText = Query; int isRowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(isRowAffected); }
public int SaveFamilyAffectedLandUsedInformation(FamilyAffectedLandUsedInformation aData) { return(aFamilyGateway.SaveFamilyAffectedLandUsedInformation(aData)); }