Esempio n. 1
0
 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();
 }
Esempio n. 2
0
        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));
        }