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