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