public async Task <IActionResult> UpdateND([FromBody] request_import req)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
var qry = "";
var csv = TM.Core.IO.ReadFile(req.file_upload, '\t');
var error = new List <template_update_import>();
var success = 0;
var index = 0;
for (index = 0; index < csv.Count; index++)
{
try
{
if (index < 1)
{
continue;
}
// Kiểm tra thuê bao
qry = $"select ma_tb from kehoach_tb where donvi_id={nd.donvi_id} and ma_tb='{csv[index][0]}'";
var tmp = await db.Connection.QueryFirstOrDefaultAsync <Models.Core.Kehoach_TB>(qry);
if (tmp == null)
{
var _tmp = new template_update_import();
_tmp.ma_tb = csv[index][0].Trim();
_tmp.ma_nd = csv[index][1].Trim();
_tmp.ct_loi = "Không tồn tại thuê bao";
error.Add(_tmp);
continue;
}
qry = $"update kehoach_tb set ma_nd='{csv[index][1].Trim()}' where ma_tb='{csv[index][0]}' and donvi_id={nd.donvi_id}";
await db.Connection.QueryAsync(qry);
success++;
}
catch (System.Exception)
{
var _tmp = new template_update_import();
_tmp.ma_tb = csv[index][0].Trim();
_tmp.ma_nd = csv[index][1].Trim();
_tmp.ct_loi = "Sai định dạng";
continue;
}
}
return(Json(new
{
total = index - 1,
success = success,
error = error,
msg = TM.Core.Common.Message.success.ToString()
}));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
public async Task <IActionResult> Post([FromBody] request_import req)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
if (req.nhomkh_id < 1)
{
return(Json(new { msg = TM.Core.Common.Message.danger.ToString() }));
}
if (req.donvi_id < 1)
{
return(Json(new { msg = TM.Core.Common.Message.danger.ToString() }));
}
// Bỏ danh sách thuê bao cũ
// var qry = $@"update kehoach_tb set trang_thai=2,nguoi_huy='{nd.ma_nd}',
// ip_huy='{TM.Core.HttpContext.Header("LocalIP")}',ngay_huy={DateTime.Now.ParseDateTime()}
// where nhom_kh={req.nhomkh_id} and thang_bd={req.thang_bd} and donvi_id={req.donvi_id} and trang_thai=1";
// await db.Connection.QueryAsync(qry);
// Get kehoach_tb check
var qry = $"select ma_tb from kehoach_tb where nhom_kh={req.nhomkh_id} and donvi_id={req.donvi_id} AND THANG_BD={req.thang_bd} AND THANG_KT={req.thang_kt}";
var kehoach_tb = await db.Connection.QueryAsync <Models.Core.Kehoach_TB>(qry);
var data = new Models.Core.Kehoach_TB();
var csv = TM.Core.IO.ReadFile(req.file_upload, '\t');
var error = new List <template_import>();
var success = 0;
var index = 0;
for (index = 0; index < csv.Count; index++)
{
try
{
if (index < 1)
{
continue;
}
// data.id = Guid.NewGuid().ToString("N");
data.nhom_kh = req.nhomkh_id;
data.donvi_id = req.donvi_id;
data.ma_tb = csv[index][0].Trim();
data.ten_tb = csv[index][1].Trim();
data.diachi_tb = csv[index][2].Trim();
data.so_dt = csv[index][3].Trim();
data.thang_bd = req.thang_bd;
data.thang_kt = req.thang_kt;
data.ma_nd = csv[index][4].Trim().ToLower();
data.ghichu = csv[index][5].Trim();
data.nguoi_nhap = nd.ma_nd;
data.ngay_nhap = DateTime.Now;
data.ip_nhap = TM.Core.HttpContext.Header("LocalIP");
data.trang_thai = 1;
// Nếu đã có thuê bao thì bỏ qua
//var tmp = kehoach_tb.Any(b => b.ma_tb==data.ma_tb);
if (kehoach_tb.Any(b => b.ma_tb == data.ma_tb))
{
ImportData(error, csv, index, "Trùng thuê bao");
continue;
}
// Chưa có thực hiện nhập vào csdl
await db.Connection.InsertOraAsync(data);
// qry = $"select ma_tb from kehoach_tb where nhom_kh={req.nhomkh_id} and donvi_id={req.donvi_id} and ma_tb='{data.ma_tb}' and id!='{data.id}'";
// var update = await db.Connection.QueryFirstOrDefaultAsync(qry);
// if (update != null)
// {
// await db.Connection.QueryAsync(qry.Replace("select ma_tb from", "delete"));
// ImportData(error, csv, index, "Cập nhật lại");
// }
success++;
}
catch (System.Exception ex)
{
ImportData(error, csv, index, ex.Message); //"Sai định dạng"
// var tmp = new template_import();
// tmp.ma_tb = csv[index][0];
// tmp.ten_tb = csv[index][1];
// tmp.diachi_tb = csv[index][2];
// tmp.so_dt = csv[index][3];
// tmp.ma_nd = csv[index][4];
// tmp.ghichu = csv[index][5];
// tmp.error = "Sai định dạng";
// error.Add(tmp);
continue;
}
}
return(Json(new
{
total = index - 1,
success = success,
error = error,
msg = TM.Core.Common.Message.success.ToString()
}));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
