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