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!";
}
}
