public List <IsAffectedLandUnderShare> GetAllIsAffectedLandUnderShare(int qid)
{
List <IsAffectedLandUnderShare> alistOfInfo = new List <IsAffectedLandUnderShare>();
Query = "SELECT * FROM IsAffectedLandUnderShare 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 totalAcquiredLand = Reader["TotalAcquiredLand"].ToString();
string nameOfShareCropper = Reader["NameOfShareCropper"].ToString();
IsAffectedLandUnderShare aData = new IsAffectedLandUnderShare();
aData.BasicInformationOfAffectedPersonNid = id;
aData.JlNo = jlNo;
aData.PlotNo = plotNo;
aData.TotalAcquiredLand = totalAcquiredLand;
aData.NameOfShareCropper = nameOfShareCropper;
alistOfInfo.Add(aData);
}
return(alistOfInfo);
}
public int SaveIsAffectedLandUnderShare(IsAffectedLandUnderShare aData)
{
Query = @"INSERT INTO IsAffectedLandUnderShare(BasicInformationOfAffectedPersonNid,JlNo,PlotNo,TotalAcquiredLand,NameOfShareCropper) VALUES ('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.JlNo + "','" + aData.PlotNo + "','" + aData.TotalAcquiredLand + "','" + aData.NameOfShareCropper + "')";
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public int SaveIsAffectedLandUnderShare(IsAffectedLandUnderShare aData)
{
return(affectedPersonGateway.SaveIsAffectedLandUnderShare(aData));
}
