LibNetCore 1.1.1

Ver contains.

• Common ( Class untilities support processed table, convert type etc)
• Constants contains define constants
• Core Contains class Dependency and Register auto -Data use DBhelper to help query databse, default SQL. -Excel help export data to excel. use template as xml or xls, xlsx to export data
• Filter use filter data input -Resource Lib javascript, ( vuejs)
• Session : use to processed session
• Web : contains Report (rdlc) and register js and css to webform (cshtml)

Detail.

• Required: If you wanna used componet wrote for design form contains: grid, textbox, drop (select2) , You must register Resource LibNetCore . Note. sys required Jquery.

• In your project, file programe you config in service as follows.

  builder.Services.AddConfigService(); and app.UseConfig();

• Next in file _layout.cshtml , you can add 2 code to register javascript and css library. @Html.RegisterCssFromResource() AND @Html.RegisterJsFromResource().

• If you use connect db, in file config json you add source code.

"Conect": { "DB_NAME": "dbname", "IPSERVER": "localhost", "USERSQL": "sa", "PWSQL": "sa" },

Okie done, so we can use Lib c# and js

• Report. used report rdlc.

to used it, you can download rdlc for vs on visual studio market or used Report build, save file *.rdl. OKie, to used it, you must using namepase: LibNetCore.Web.

In controller a write as follows

   string rdlc = "Report/Benhnhan_Mau".rdlc";   ( Define file report)

        ReportHelper rpt = new ReportHelper(rdlc);  ( Classs helper processed report)

-List<ReportParameter> paramaters = new List<ReportParameter>(); ( Define report paramater if you have)

and then add paramater and datasource to report if you have

rpt.DataSouce =DataSouce ; rpt.paramaters = paramaters;

• next call method export.

  var kq = rpt.Export("PDF"); --Call export pdf, we can change to other paramater as excel ( xls) word, html... return byte array, web convert byte array to file save or return to views.

• DATA. to used query database ( defaul SQL server), we used namepace : LibNetCore.Data, when web register config in step 1 then class Session, DbHelper Auto register DI. to used i define.

private IDbHelper _dbHelper; public DanhMucService(IDbHelper dbHelper) { _dbHelper = dbHelper; }

Lib used dapper to query so you can used it as dapper.

var parameters = new DynamicParameters(); -- Define Dynamic db

and call mothod

await _dbHelper.ExecuteNoneQueryAsyn(StoreProcedure, parameters); -- await _dbHelper.ExecuteQueryAsyn(b_sql); -- Execute query SQL await _dbHelper.ExecuteProcedureAsyn<T1>(storeProcedure); -- Execute procedure and return T1 class ( T 1model define), to return more class you can use T1,T2,T3... return Ienumable<T1>...

Link Git demo:

https://github.com/tieudoan208/LibNetCore.git