public List <FamilyAffectedLandInformation> GetAllFamilyAffectedLandInformation(int qid)
{
List <FamilyAffectedLandInformation> aList = new List <FamilyAffectedLandInformation>();
Query = @"SELECT * FROM FamilyAffectedLandInformation 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["TotalAcquiedLand"].ToString();
string ownershipPattern = Reader["OwnershipPattern"].ToString();
string marketPriceOfAcquiredLand = Reader["MarketPriceOfAcquiredLand"].ToString();
string presentLandUsePattern = Reader["PresentLandUsePattern"].ToString();
FamilyAffectedLandInformation aData = new FamilyAffectedLandInformation();
aData.BasicInformationOfAffectedPersonNid = id;
aData.JlNo = jlNo;
aData.PlotNo = plotNo;
aData.TotalAcquiedLand = totalAcquiedLand;
aData.OwnershipPattern = ownershipPattern;
aData.MarketPriceOfAcquiredLand = marketPriceOfAcquiredLand;
aData.PresentLandUsePattern = presentLandUsePattern;
aList.Add(aData);
}
Connection.Close();
return(aList);
}
public int SaveFamilyAffectedLandInformation(FamilyAffectedLandInformation aData)
{
Query = @"INSERT INTO FamilyAffectedLandInformation(BasicInformationOfAffectedPersonNid,JlNo,PlotNo,TotalAcquiedLand,OwnershipPattern,MarketPriceOfAcquiredLand,PresentLandUsePattern)
VALUES('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.JlNo + "','" + aData.PlotNo + "','" + aData.TotalAcquiedLand + "','" + aData.OwnershipPattern + "','" + aData.MarketPriceOfAcquiredLand + "','" + aData.PresentLandUsePattern + "')";
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public int SaveFamilyAffectedLandInformation(FamilyAffectedLandInformation aData)
{
return(aFamilyGateway.SaveFamilyAffectedLandInformation(aData));
}
