public List <DomesticMovableAssets> GetAllDomesticMovableAssetss(int qid)
{
List <DomesticMovableAssets> aInfo = new List <DomesticMovableAssets>();
Query = "SELECT * FROM DomesticMovableAssets WHERE BasicInformationOfAffectedPersonNid='" + qid + "'";
Connection.Open();
Command.CommandText = Query;
Reader = Command.ExecuteReader();
while (Reader.Read())
{
long id = Convert.ToInt64(Reader["BasicInformationOfAffectedPersonNid"]);
string education = Reader["InstitutionTypes"].ToString();
int name = Convert.ToInt32(Reader["Numbers"]);
int relation = Convert.ToInt32(Reader["TentativeAmount"]);
DomesticMovableAssets aData = new DomesticMovableAssets();
aData.BasicInformationOfAffectedPersonNid = id;
aData.InstitutionTypes = education;
aData.Numbers = name;
aData.TentativeAmount = relation;
aInfo.Add(aData);
}
Connection.Close();
return(aInfo);
}
public int SaveDomesticMovableAssets(DomesticMovableAssets aData)
{
Query = @"INSERT INTO DomesticMovableAssets(BasicInformationOfAffectedPersonNid,InstitutionTypes,Numbers,TentativeAmount)
VALUES('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.InstitutionTypes + "','" + aData.Numbers + "','" + aData.TentativeAmount + "')";
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public int SaveDomesticMovableAssets(DomesticMovableAssets aData)
{
return(aFamilyGateway.SaveDomesticMovableAssets(aData));
}
