/*
* select the second i8
*/
public dynamic execureI8NghiemThu(BscRequest bscRequest)
{
List <I8AcceptanceRespond> result = new List <I8AcceptanceRespond>();
var dyParam = new OracleDynamicParameters();
dyParam.Add("vtungay", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.vtungay);
dyParam.Add("vdenngay", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.vdenngay);
dyParam.Add("vtrangthai", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.vtrangthai);
dyParam.Add("returnds", OracleDbType.RefCursor, ParameterDirection.Output);
var conn = GetConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
// var query = "select * from ppm_tuyetnt.I8NGHIEMTHU_KHANH";
var query = "kiemsoat.bc_dashboard.i8_tk_tyle_ccdv_va_scdv_nghiem_thu_mobile_app";
result = SqlMapper.Query <I8AcceptanceRespond>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).AsList <I8AcceptanceRespond>();
//result = SqlMapper.Query<I8AcceptanceRespond>(conn, query, param: dyParam, commandType: CommandType.Text).AsList<I8AcceptanceRespond>(); ;
//insertToI8MobileAcceptance(result);
}
return(result);
}
public Task Execute(IJobExecutionContext context)
{
BscRequest bscRequest = new BscRequest();
bscRequest.vtungay = DateTime.Now.AddDays(-2).Day + "/" + DateTime.Now.AddDays(-2).Month + "/" + DateTime.Now.AddDays(-2).Year;
bscRequest.vtungay = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year;
return(m_bsc.execureI8NghiemThu(bscRequest));
}
/*
* get chi tiet so luong thuc tan
*/
public dynamic execureDetailDataReal(BscRequest bscRequest)
{
List <DetailDataReal> result = new List <DetailDataReal>();
var dyParam = new OracleDynamicParameters();
dyParam.Add("o_data", OracleDbType.RefCursor, ParameterDirection.Output);
var conn = GetConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
var query = "kiemsoat.bc_dashboard.detail_sl_thuctang";
result = SqlMapper.Query <DetailDataReal>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).AsList <DetailDataReal>();
//insertDetailDataReal(result);
}
return(result);
}
/*
* get so luong thuc tan
*/
public dynamic execureDataIncrese(BscRequest bscRequest)
{
List <DataReal> result = new List <DataReal>();
var dyParam = new OracleDynamicParameters();
dyParam.Add("i_thang", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.i_Thang);
dyParam.Add("o_data", OracleDbType.RefCursor, ParameterDirection.Output);
var conn = GetConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
var query = "mivtt.SL_COS.TK_TT_FIBER_MYTV";
result = SqlMapper.Query <DataReal>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).AsList <DataReal>();
//insertToCos(result, bscRequest);
}
return(result);
}
/*
* select danh ba thue bao
*/
public dynamic execureDbThueBao(BscRequest bscRequest)
{
List <ListDirectoryRespond> result = new List <ListDirectoryRespond>();
var dyParam = new OracleDynamicParameters();
dyParam.Add("i_Thang", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.i_Thang);
dyParam.Add("i_TTVT", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.i_TTVT);
dyParam.Add("o_data", OracleDbType.RefCursor, ParameterDirection.Output);
var conn = GetConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
var query = "kiemsoat.bc_dashboard.tke_lm_go_theo_dvtb";
result = SqlMapper.Query <ListDirectoryRespond>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).AsList <ListDirectoryRespond>();
// insertToDirectory(result);
}
return(result);
}
/*
* call stores with the parameter
* the first
*/
public dynamic execureI8MobileApp(BscRequest bscRequest)
{
List <BscRespond> result = new List <BscRespond>();
var dyParam = new OracleDynamicParameters();
dyParam.Add("vtungay", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.vtungay);
dyParam.Add("vdenngay", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.vdenngay);
dyParam.Add("returnds", OracleDbType.RefCursor, ParameterDirection.Output);
var conn = GetConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
var query = "dashboard.i8_sudung_mobile_app_by_khanh";
result = SqlMapper.Query <BscRespond>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).AsList <BscRespond>();
//insertToI8MobileApp(result);
}
return(result);
}
/*
* get chi tiet so luong thuc tan
*/
public dynamic execureDetailFiberMyTV(BscRequest bscRequest)
{
List <DetailFiberMyTV> result = new List <DetailFiberMyTV>();
var dyParam = new OracleDynamicParameters();
dyParam.Add("i_tungay", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.i_tungay);
dyParam.Add("i_denngay", OracleDbType.Varchar2, ParameterDirection.Input, bscRequest.i_denngay);
dyParam.Add("o_data", OracleDbType.RefCursor, ParameterDirection.Output);
var conn = GetConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
var query = "kiemsoat.bc_dashboard.detail_fiber_mytv";
result = SqlMapper.Query <DetailFiberMyTV>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).AsList <DetailFiberMyTV>();
//insertDetailFiberMyTV(result);
}
return(result);
}
/*
* insert to SL_COS
*/
public void insertToCos(List <DataReal> listCos, BscRequest bscRequest)
{
foreach (var cos in listCos)
{
DataReal data = new DataReal();
data.id = cos.id;
data.donvi = cos.donvi;
data.ptm_fiber_ttkd = cos.ptm_fiber_ttkd;
data.ptm_fiber_ttvt = cos.ptm_fiber_ttvt;
data.ptm_mytv_ttkd = cos.ptm_mytv_ttkd;
data.ptm_mytv_ttvt = cos.ptm_mytv_ttvt;
data.huy_fiber = cos.huy_fiber;
data.huy_mytv = cos.huy_mytv;
data.ctld_mytv = cos.ctld_mytv;
data.ctld_fiber = cos.ctld_fiber;
data.ngaytao = DateTime.Now;
var day = "01/" + bscRequest.i_Thang.ToString().Substring(4, 2) + "/" + bscRequest.i_Thang.ToString().Substring(0, 4);
data.ngay = DateTime.ParseExact(day, "dd/MM/yyyy", CultureInfo.InvariantCulture);
data.thang = Int32.Parse(bscRequest.i_Thang.ToString().Substring(4, 2));
data.nam = Int32.Parse(bscRequest.i_Thang.ToString().Substring(0, 4));
//m_slCos.insert(data);
}
}
public dynamic getDetailDataReal()
{
BscRequest x = new BscRequest();
return(m_bsc.execureDetailDataReal(x));
}
