public List <HomeResources> GetAllHomeResources(int qid) { List <HomeResources> aInfo = new List <HomeResources>(); Query = "SELECT * FROM HomeResources WHERE BasicInformationOfAffectedPersonNid='" + qid + "'"; Connection.Open(); Command.CommandText = Query; Reader = Command.ExecuteReader(); while (Reader.Read()) { long id = Convert.ToInt64(Reader["BasicInformationOfAffectedPersonNid"]); string resources = Reader["Resources"].ToString(); string resourcesName = Reader["ResourcesName"].ToString(); string others = Reader["Others"].ToString(); int counts = Convert.ToInt32(Reader["Counts"]); long amounts = Convert.ToInt64(Reader["Amounts"]); HomeResources aData = new HomeResources(); aData.BasicInformationOfAffectedPersonNid = id; aData.Resources = resources; aData.ResourcesName = resourcesName; aData.Others = others; aData.Count = counts; aData.Amount = amounts; aInfo.Add(aData); } Connection.Close(); return(aInfo); }
public ActionResult HomeResources(HomeResources aData) { int rowAffected = aFamilyManager.SaveHomeResources(aData); string messages = "Successfully Saved " + rowAffected; return(RedirectToAction("HomeResources", "HomeResources", new { id = aData.BasicInformationOfAffectedPersonNid, message = messages })); }
public int SaveHomeResources(HomeResources aData) { Query = @"INSERT INTO HomeResources(BasicInformationOfAffectedPersonNid,Resources,ResourcesName,Others,Counts,Amounts) VALUES('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.Resources + "','" + aData.ResourcesName + "','" + aData.Others + "','" + aData.Count + "','" + aData.Amount + "')"; Connection.Open(); Command.CommandText = Query; int isRowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(isRowAffected); }
public int SaveHomeResources(HomeResources aData) { return(aFamilyGateway.SaveHomeResources(aData)); }