public ActionResult FamilyYearlyCost(HouseholdYearlyExpenditure aData)
{
int rowAffected = aFamilyManager.SaveHouseholdYearlyExpenditure(aData);
ViewBag.Message = "Save Successfully" + rowAffected;
// return View();
return(RedirectToAction("DomesticImmovableAssets", "DomesticImmovableAssets", new { id = aData.BasicInformationOfAffectedPersonNid }));
}
public int SaveHouseholdYearlyExpenditure(HouseholdYearlyExpenditure aData)
{
double total = aData.ClothExpenditure + aData.FoodExpenditure + aData.ResidenceRepairingExpenditure + aData.MedicalExpenditure + aData.EducationalExpenditure + aData.CommunicationExpenditure + aData.Miscellaneous;
Query = @"INSERT INTO HouseholdYearlyExpenditure(BasicInformationOfAffectedPersonNid,FoodExpenditure,ClothExpenditure,ResidenceRepairingExpenditure,MedicalExpenditure,EducationalExpenditure,CommunicationExpenditure,Miscellaneous,TotalExpenditure)
VALUES('" + aData.BasicInformationOfAffectedPersonNid + "','" + aData.FoodExpenditure + "','"
+ aData.ClothExpenditure + "','" + aData.ResidenceRepairingExpenditure + "','" + aData.MedicalExpenditure + "','" + aData.EducationalExpenditure + "','" + aData.CommunicationExpenditure + "'," +
"'" + aData.Miscellaneous + "','" + total + "')";
Connection.Open();
Command.CommandText = Query;
int isRowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(isRowAffected);
}
public List <HouseholdYearlyExpenditure> GetAllHouseholdYearlyExpenditure(int qid)
{
List <HouseholdYearlyExpenditure> aInfo = new List <HouseholdYearlyExpenditure>();
Query = "SELECT * FROM HouseholdYearlyExpenditure WHERE BasicInformationOfAffectedPersonNid='" + qid + "'";
Connection.Open();
Command.CommandText = Query;
Reader = Command.ExecuteReader();
while (Reader.Read())
{
long id = Convert.ToInt64(Reader["BasicInformationOfAffectedPersonNid"]);
int name = Convert.ToInt32(Reader["FoodExpenditure"]);
int relation = Convert.ToInt32(Reader["ClothExpenditure"]);
int age = Convert.ToInt32(Reader["ResidenceRepairingExpenditure"]);
int gender = Convert.ToInt32(Reader["MedicalExpenditure"]);
int education = Convert.ToInt32(Reader["EducationalExpenditure"]);
int professionPrimary = Convert.ToInt32(Reader["CommunicationExpenditure"]);
int professionSecondary = Convert.ToInt32(Reader["Miscellaneous"]);
int totalIncomeFromProfession = Convert.ToInt32(Reader["TotalExpenditure"]);
HouseholdYearlyExpenditure aData = new HouseholdYearlyExpenditure();
aData.BasicInformationOfAffectedPersonNid = id;
aData.FoodExpenditure = name;
aData.ClothExpenditure = relation;
aData.ResidenceRepairingExpenditure = age;
aData.MedicalExpenditure = gender;
aData.EducationalExpenditure = education;
aData.CommunicationExpenditure = professionPrimary;
aData.Miscellaneous = professionSecondary;
aData.TotalExpenditure = totalIncomeFromProfession;
aInfo.Add(aData);
}
Connection.Close();
return(aInfo);
}
public int SaveHouseholdYearlyExpenditure(HouseholdYearlyExpenditure aData)
{
return(aFamilyGateway.SaveHouseholdYearlyExpenditure(aData));
}