public ParentViewModel() { Jct_Asset_Dep_Unit = new Jct_Asset_Dep_Unit(); Jct_Asset_Dep_Company = new Jct_Asset_Dep_Company(); Jct_Asset_Dep_SubUnit = new Jct_Asset_Dep_SubUnit(); Jct_Asset_Dep_Book = new Jct_Asset_Dep_Book(); Jct_Asset_Dep_Group = new Jct_Asset_Dep_Group(); Jct_Asset_Dep_SubGroup = new Jct_Asset_Dep_SubGroup(); Jct_Asset_Dep_CompanyActRate = new Jct_Asset_Dep_CompanyActRate(); Jct_Asset_Dep_Bill_Info = new Jct_Asset_Dep_Bill_Info(); Jct_Asset_Dep_Asset = new Jct_Asset_Dep_Asset(); Jct_Asset_Dep_Book_AccountingYear = new Jct_Asset_Dep_Book_AccountingYear(); Jct_Asset_Dep_Section = new Jct_Asset_Dep_Section(); FinancialYearMasterModel = new FinancialYearMasterModel(); Jct_Asset_Dep_Method = new Jct_Asset_Dep_Method(); Jct_Asset_Dep_Insurance = new Jct_Asset_Dep_Insurance(); Jct_Asset_Dep_Sub_Asset = new Jct_Asset_Dep_Sub_Asset(); Jct_Asset_Dep_Shift = new Jct_Asset_Dep_Shift(); SLMProspectiveCalculatorModel = new SLMProspectiveCalculatorModel(); DropDownViewModel = new DropDownViewModel(); ReportViewModel = new ReportViewModel(); }
public JsonResult GetMethodlist(string SubGroupCode) { Jct_Asset_Dep_Method model = new Jct_Asset_Dep_Method(); SqlConnection con = DBConnection.getConnection(); string sql = "Jct_Asset_Dep_Asset_Detail_GetSubGroupMethod_Fetch"; SqlCommand cmd = new SqlCommand(sql, con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SubGroup_Code", SubGroupCode); SqlDataReader read = cmd.ExecuteReader(); if (read.HasRows) { while (read.Read()) { model.Method_Code = read["SubGroup_MethodCode"].ToString(); } read.Close(); con.Close(); } return(Json(model, JsonRequestBehavior.AllowGet)); }