public List<ChartOfAccountCustom> CodeWiseGetAllChartOfAccountByCompanyIdForLastLevel(int CompanyId,int code) { try { //var cAObj = _finalCrudOperation.GetOperation() // .Include(c => c.Companies) // .Filter(c => c.CompanyId == CompanyId || c.CompanyId.HasValue == false && c.Level > 2 && c.ACode.StartsWith(code)) // .Get() // .OrderBy(c => c.ACode) // .ToList(); //return cAObj; using (var context = new WsDbContext()) { var param1 = new SqlParameter("@queryoption", 1); var param2 = new SqlParameter("@accounttypeid", code); var param3 = new SqlParameter("@companyid", CompanyId); const string query = "EXEC spget_chartofaccount @queryoption,@accounttypeid,@companyid"; var rr = context.Database.SqlQuery<ChartOfAccountCustom>(query, param1, param2,param3).ToList(); return rr; } } catch (Exception ex) { var rr = ex.Message; return null; } }
public string InsertDefaultData() { using (var context = new WsDbContext()) { const string query = "EXEC spset_general_data_entry"; var rr = context.Database.ExecuteSqlCommand(query); if (rr > 0) return "Default Data Added Successfully!"; return "Default Data Already Inserted,No need to do again!"; } }