public JsonResult UpdateData(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
try
{
var qry = $"DELETE {Common.Objects.TYPE_HD.HD_CD} WHERE KYHOADON='{obj.KYHD}'";
SQLServer.Connection.Query(qry);
qry = $@"INSERT INTO {Common.Objects.TYPE_HD.HD_CD}
SELECT NEWID() AS ID,KYHOADON,ID AS CD_ID,NEWID() AS DBKH_ID,TYPE_BILL,APP_ID,SO_TB,KIEU,TB_DAUCUOI,CUOC_TB,CUOC_DV,CUOC_NH,CUOC_NT,CUOC_PSTN,
CUOC_V171,CUOC_VDNK,CUOC_DD,CUOC_IDD,CUOC_V171Q,CUOC_VDNKQ,CUOC_CI,CUOC_KM,CHIET_KHAU,0 AS TONG_IN,TONG,VAT,TONGCONG,DUPE_FLAG
FROM {Common.Objects.TYPE_HD.CD} WHERE KYHOADON='{obj.KYHD}' AND TONGCONG>0";
SQLServer.Connection.Query(qry);
qry = $"UPDATE a SET a.DBKH_ID=b.ID FROM {Common.Objects.TYPE_HD.HD_CD} a INNER JOIN {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} b ON a.SO_TB=b.MA_TB WHERE a.TYPE_BILL=b.TYPE_BILL AND b.FIX=0 AND b.FLAG=1 and KYHOADON='{obj.KYHD}'";
SQLServer.Connection.Query(qry);
qry = $"select * from {Common.Objects.TYPE_HD.HD_CD} where KYHOADON='{obj.KYHD}'";
var data = SQLServer.Connection.Query <Models.HD_CD>(qry);
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_CD} - Cập nhật dữ liệu thành công - {data.Count()} thuê bao" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
public IActionResult Select(string sort, int page = 1, int per_page = 10)
{
try {
var SQLServer = new TM.Connection.SQLServer();
var sql = "SELECT TOP 30 * FROM db_goitichhop ORDER BY tengoi";
var data = SQLServer.Connection.Query <Billing.Core.Models.db_goitichhop>(sql);
var total = data.Count();
var from = (page - 1) * per_page;
data = data.Take(per_page).Skip(from);
//
SQLServer.Close();
var last_page = Math.Ceiling(decimal.Parse(total.ToString()) / decimal.Parse(per_page.ToString()));
return(Json(new {
total = total,
per_page = per_page,
current_page = page,
last_page = 2,
next_page_url = "",
prev_page_url = "",
from = from + 1,
to = per_page * page,
sort = sort,
data = data
}));
} catch (Exception ex) {
return(Json(new { Error = ex.Message }));
}
}
public JsonResult UpdateData(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
try
{
var qry = $"DELETE {Common.Objects.TYPE_HD.HD_DD} WHERE KYHOADON='{obj.KYHD}'";
SQLServer.Connection.Query(qry);
qry = $@"INSERT INTO {Common.Objects.TYPE_HD.HD_DD}
SELECT NEWID() AS ID,KYHOADON,ID AS DD_ID,NEWID() AS DBKH_ID,TYPE_BILL,APP_ID,SO_TB,MA_DVI1,MA_CBT1,KIEU,INCHITIET,EZPAY,IS_GROUP,SL_MAY,
TIEN_SDTK,CUOC_TB,CAREPLUS,CUOC_KTHUE,CUOC_KM,CUOC_CDVU,CUOC_TT,CUOC_PSDV,TIEN_TTRUO,TIEN_DCOC,GIAM_TRU,CUOC_GTRU,0 AS TONG_IN,TONG,VAT,TONGCONG,DUPE_FLAG
FROM {Common.Objects.TYPE_HD.DD} WHERE KYHOADON='{obj.KYHD}' AND TONGCONG>0";
SQLServer.Connection.Query(qry);
qry = $"UPDATE a SET a.DBKH_ID=b.ID FROM {Common.Objects.TYPE_HD.HD_DD} a INNER JOIN {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} b ON a.SO_TB=b.MA_TB WHERE a.TYPE_BILL=b.TYPE_BILL AND b.FIX=0 AND b.FLAG=1 and KYHOADON='{obj.KYHD}'";
SQLServer.Connection.Query(qry);
qry = $"select * from {Common.Objects.TYPE_HD.HD_DD} where KYHOADON='{obj.KYHD}'";
var data = SQLServer.Connection.Query <Models.HD_DD>(qry);
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_DD} - Cập nhật dữ liệu thành công - {data.Count()} thuê bao" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
public JsonResult XuLyKhuyenMai(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "4";
try
{
var qry = "";
//PERCENT
qry = $"UPDATE hd SET hd.TONG=hd.TONG*((100-dc.VALUE)/100) FROM HD_TSL hd INNER JOIN DISCOUNT dc ON hd.MA_TB=dc.MA_TB WHERE hd.TYPE_BILL={TYPE_BILL} AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND FORMAT(dc.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND dc.FLAG=1 AND dc.TYPEID={(int)Common.Objects.TYPE_DISCOUNT.PERCENT} AND ((hd.TIME_BILL>=dc.NGAY_BD AND dc.NGAY_KT IS NULL) OR (hd.TIME_BILL BETWEEN dc.NGAY_BD AND dc.NGAY_KT));";
SQLServer.Connection.Query(qry);
//MONEY
qry = $"UPDATE hd SET hd.TONG=hd.TONG-dc.VALUE FROM HD_TSL hd INNER JOIN DISCOUNT dc ON hd.MA_TB=dc.MA_TB WHERE hd.TYPE_BILL={TYPE_BILL} AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND FORMAT(dc.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND dc.FLAG=1 AND dc.TYPEID={(int)Common.Objects.TYPE_DISCOUNT.MONEY} AND ((hd.TIME_BILL>=dc.NGAY_BD AND dc.NGAY_KT IS NULL) OR (hd.TIME_BILL BETWEEN dc.NGAY_BD AND dc.NGAY_KT));";
SQLServer.Connection.Query(qry);
//FIX
qry = $"UPDATE hd SET hd.TONG=dc.VALUE FROM HD_TSL hd INNER JOIN DISCOUNT dc ON hd.MA_TB=dc.MA_TB WHERE hd.TYPE_BILL={TYPE_BILL} AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND FORMAT(dc.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND dc.FLAG=1 AND dc.TYPEID={(int)Common.Objects.TYPE_DISCOUNT.FIX} AND ((hd.TIME_BILL>=dc.NGAY_BD AND dc.NGAY_KT IS NULL) OR (hd.TIME_BILL BETWEEN dc.NGAY_BD AND dc.NGAY_KT));";
SQLServer.Connection.Query(qry);
//UPDATE VAT
qry = $"UPDATE HD_TSL SET VAT=ROUND(TONG*0.1,0) WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}';";
SQLServer.Connection.Query(qry);
//UPDATE TONGCONG
qry = $"UPDATE HD_TSL SET TONGCONG=TONG+VAT WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}';";
SQLServer.Connection.Query(qry);
return(Json(new { success = $"HD_TSL - Cập nhật khuyến mại thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
}
public JsonResult UpdateStatus(Guid id, int op = 2, string url = null)
{
try
{
if (!Authentication.Auth.isAuth)
{
return(Json(new { success = "Ok!" }, JsonRequestBehavior.AllowGet));
}
var SQLServer = new TM.Connection.SQLServer();
var qry = $"UPDATE NOTIFICATION SET FLAG={op} WHERE ID='{id}'";
SQLServer.Connection.Query(qry);
SQLServer.Close();
if (string.IsNullOrEmpty(url))
{
return(Json(new { success = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { url = url, success = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex) { return(Json(new { danger = ex.Message }, JsonRequestBehavior.AllowGet)); }//"Không tìm thấy dữ liệu, vui lòng thực hiện lại!"
finally { }
}
public ActionResult BackupDatabase()
{
var SqlServer = new TM.Connection.SQLServer();
try
{
var path = TM.Common.Directories.DBBak;
TM.IO.FileDirectory.CreateDirectory(path, false);
//TM.IO.FileDirectory.SetAccessRule(path, false);
var backup = new TM.SQLServer.Backup(path);
backup.BackingAll(SqlServer.Connection);
//InsertDirectory(TM.Common.Directories.DBBak + "test\\abc");
var a = InsertDirectoriesFiles(path);
this.success("thành công");
}
catch (Exception ex)
{
this.danger(ex.Message);
}
finally
{
SqlServer.Close();
}
return(RedirectToAction("Index"));
}
public JsonResult UpdateQuanHuyen(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var Oracle = new TM.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
try
{
//Get Data HNI
var qry = $"SELECT * FROM QUAN_HUYEN_BKN";
var data_hni = Oracle.Connection.Query <Models.QUAN_HUYEN_BKN>(qry).ToList();
//Delete Old
qry = "DELETE QUAN_HUYEN_BKN";
SQLServer.Connection.Query(qry);
//Insert Data
SQLServer.Connection.Insert(data_hni);
return(Json(new { success = $"QUAN_HUYEN_BKN - Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally
{
SQLServer.Close();
Oracle.Close();
}
}
public JsonResult UpdateDBDT(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var Oracle = new TM.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
try
{
//Get Data HNI
var qry = $"SELECT * FROM DB_DUONGTHU_BKN";
var data_hni = Oracle.Connection.Query <Models.DB_DUONGTHU_BKN>(qry).ToList();
//Update Data
foreach (var i in data_hni)
{
i.ID = Guid.NewGuid();
i.FIX = 0;
i.FLAG = 1;
i.MA_DT = i.MA_DT.Trim().ToUpper();
}
//Delete Old
qry = "DELETE DB_DUONGTHU_BKN WHERE FIX=0";
SQLServer.Connection.Query(qry);
//Insert Data
SQLServer.Connection.Insert(data_hni);
return(Json(new { success = $"DB_DUONGTHU_BKN - Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally
{
SQLServer.Close();
Oracle.Close();
}
}
public JsonResult UpdatePrice(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "4";
try
{
//Cập nhật tổng
var qry = $"UPDATE hd SET hd.TONG=bg.GIA FROM HD_TSL hd INNER JOIN BGCUOC bg ON bg.PROFILEIP LIKE '%,'+hd.TOC_DO+',%' WHERE TYPE_BILL={TYPE_BILL} AND bg.GOICUOCID=0 AND TT_THANG=1 AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
SQLServer.Connection.Query(qry);
qry = $"UPDATE hd SET hd.TONG=ROUND((bg.GIA/{obj.day_in_month})*NGAY_TB,0) FROM HD_TSL hd INNER JOIN BGCUOC bg ON bg.PROFILEIP LIKE '%,'+hd.TOC_DO+',%' WHERE TYPE_BILL={TYPE_BILL} AND bg.GOICUOCID=0 AND TT_THANG=2 AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
SQLServer.Connection.Query(qry);
//Cập nhật vat và tổng cộng
qry = $@"UPDATE HD_TSL SET VAT=ROUND(TONG*0.1,0) WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}';
UPDATE HD_TSL SET TONGCONG=TONG+VAT WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}';";
SQLServer.Connection.Query(qry);
return(Json(new { success = $"HD_TSL - Cập nhật giá thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally
{
SQLServer.Close();
}
}
public JsonResult XuLyTichHopxxx(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "4";
try
{
var qry = $@"UPDATE hd SET hd.GOICUOCID=thdv.LOAIGOICUOC_ID FROM HD_TSL hd,DANHBA_GOICUOC_TICHHOP thdv WHERE hd.MA_TB=thdv.MA_TB AND thdv.NGAY_KT>=CAST('{obj.block_time}' as datetime) AND hd.TYPE_BILL=8 AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND FORMAT(thdv.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND thdv.FIX=0 AND thdv.FLAG=1;
UPDATE hd SET hd.GOICUOCID=thdv.LOAIGOICUOC_ID FROM HD_TSL hd,DANHBA_GOICUOC_TICHHOP thdv WHERE hd.MA_TB=thdv.MA_TB AND thdv.NGAY_BD<CAST('{obj.block_time}' as datetime) AND thdv.NGAY_KT IS NULL AND hd.TYPE_BILL=8 AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND FORMAT(thdv.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND thdv.FIX=0 AND thdv.FLAG=1;";
SQLServer.Connection.Query(qry);
//Xử lý tích hợp thêm
qry = $"UPDATE hd SET hd.GOICUOCID=thdv.LOAIGOICUOC_ID FROM HD_TSL hd INNER JOIN DANHBA_GOICUOC_TICHHOP thdv ON hd.MA_TB=thdv.MA_TB WHERE hd.TYPE_BILL=8 AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}' AND thdv.DICHVUVT_ID=8 AND thdv.FIX=1";
SQLServer.Connection.Query(qry);
//Cập nhật giá từ bảng giá đối với thuê bao tích hợp
qry = $@"UPDATE hd SET hd.TONG=bg.GIA+hd.PAYTV_FEE FROM HD_TSL hd INNER JOIN BGCUOC bg ON hd.GOICUOCID=bg.GOICUOCID WHERE hd.GOICUOCID>0 AND bg.DICHVUVT_ID=8 AND hd.TYPE_BILL=8 AND FORMAT(hd.TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
SQLServer.Connection.Query(qry);
//Cập nhật thuê bao tích hợp không tròn tháng
//qry = $@"UPDATE HD_TSL SET TONG=PAYTV_FEE+SUB_FEE,GOICUOCID=0 WHERE GOICUOCID>0 AND (PAYTV_FEE+SUB_FEE)<TONG AND (NGAY_KHOA is not null or NGAY_MO is not null or NGAY_KT is not null) AND TYPE_BILL=8 AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
SQLServer.Connection.Query(qry);
//Cập nhật vat và tổng cộng
qry = $@"UPDATE HD_TSL SET VAT=ROUND(TONG*0.1,0) WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}';
UPDATE HD_TSL SET TONGCONG=TONG+VAT WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}';";
SQLServer.Connection.Query(qry);
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_MYTV} - Cập nhật tích hợp thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally
{
SQLServer.Close();
}
}
public async Task <IActionResult> GetData(string sort, int page, int per_page)
{
var TMAppSettings = new Common.TMAppSettings();
var a = TMAppSettings.GetSectionConnectionStrings();
var sql = new TM.Connection.SQLServer();
var data = await sql.Connection.QueryAsync <Billing.Core.Models.TEST>("SELECT * FROM TEST ORDER BY LEVELS");
var total = data.Count();
return(Json(new { total = total, data = data }));
}
public JsonResult Login(AuthObj obj)
{
try
{
SQLServer = new TM.Connection.SQLServer("Portal");
var qry = "";
//var collection = HttpContext.Request.ReadFormAsync();
//string username = collection["username"].ToString();
//string password = collection["password"].ToString();
//AuthStatic
var AuthStatic = Authentication.Auth.isAuthStatic(obj.username, obj.password);
if (AuthStatic != null)
{
Authentication.Auth.SetAuth(AuthStatic);
return(Json(new { success = "Đăng nhập thành công!", url = TM.Url.RedirectContinue() }, JsonRequestBehavior.AllowGet));
}
//AuthDB
qry = $"SELECT * FROM users WHERE username='******'";
var user = SQLServer.Connection.QueryFirstOrDefault <Authentication.Users>(qry);// db.users.SingleOrDefault(u => u.username == username);
//Account not Exist
if (user == null)
{
return(Json(new { danger = "Sai tên tài khoản hoặc mật khẩu!" }, JsonRequestBehavior.AllowGet));
}
//Password wrong
obj.password = TM.Encrypt.CryptoMD5TM(obj.password + user.salt);
if (user.password != obj.password)
{
return(Json(new { danger = "Sai tên tài khoản hoặc mật khẩu!" }, JsonRequestBehavior.AllowGet));
}
//Account is locked
if (user.flag < 1)
{
return(Json(new { danger = "Tài khoản đã bị khóa. Vui lòng liên hệ admin!" }, JsonRequestBehavior.AllowGet));
}
//Update last login
user.last_login = DateTime.Now;
SQLServer.Connection.Update(user);
//Set Auth Account
Authentication.Auth.SetAuth(user);
//return Redirect(TM.Url.RedirectContinue());
}
catch (Exception ex)
{
return(Json(new { danger = "Đăng nhập không thành công, vui lòng liên hệ admin!" }, JsonRequestBehavior.AllowGet));
}
finally { SQLServer.Close(); }
return(Json(new { success = "Đăng nhập thành công!", url = TM.Url.RedirectContinue(obj.currentUrl, true) }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
try
{
var SQLServer = new TM.Connection.SQLServer();
FileManagerController.InsertDirectory(Common.Directories.HDData);
ViewBag.directory = TM.IO.FileDirectory.DirectoriesToList(Common.Directories.HDData).OrderByDescending(d => d).ToList();
}
catch (Exception ex) { this.danger(ex.Message); }
return(View());
}
public JsonResult ImportGDSExcel(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var HNIVNPTBACKAN2 = new TM.Connection.Oracle("HNIVNPTBACKAN2");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var UploadFiles = new List <string>();
string strUpload = "Nhập file GDS thành công!";
try
{
TM.IO.FileDirectory.CreateDirectory(obj.DataSource, false);
var uploadData = UploadBase(obj.DataSource, strUpload, UploadFiles, ".xls");
if (UploadFiles.Count < 1)
{
return(Json(new { danger = "Chưa tải được tệp, Vui lòng thử lại!" }, JsonRequestBehavior.AllowGet));
}
//
var xxxx = TM.OleExcel.ToDataSet(obj.DataSource + UploadFiles[0]);
var excel = xxxx.Tables[0];
var list = new List <Models.CUOC_FIBERVNN>();
foreach (System.Data.DataRow r in excel.Rows)
{
index++;
var tmp = new Models.CUOC_FIBERVNN();
tmp.MA_MEN = r["MA_MEN"].ToString();
tmp.CUOC = r["CUOC"] != null?decimal.Parse(r["CUOC"].ToString()) : 0;
tmp.THANGNAM = obj.month_year_time;
list.Add(tmp);
}
//list.Add(new Models.GDSIMPORT { MA_MEN = r["MA_MEN"].ToString(), CUOC = (int)r["CUOC"], THANGNAM = ((DateTime)r["THANGNAM"]).ToString("MM/yyyy") });
//HNIVNPTBACKAN2.Connection.Query("DELETE CUOC_FIBERVNN WHERE THANGNAM='11/2017'");
TM.Dapper.CRUDOracle.InsertList(HNIVNPTBACKAN2.Connection, list);
//
if (uploadData == (int)Common.Objects.ResultCode._extension)
{
return(Json(new { danger = "Tệp phải định dạng .dbf!" }, JsonRequestBehavior.AllowGet));
}
else if (uploadData == (int)Common.Objects.ResultCode._length)
{
return(Json(new { danger = "Chưa đủ tệp!" }, JsonRequestBehavior.AllowGet));
}
//else if (uploadData == (int)Common.Objects.ResultCode._success)
// return Json(new { success = strUpload }, JsonRequestBehavior.AllowGet);
else
{
return(Json(new { success = strUpload }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
}
public ActionResult Index()
{
try
{
var SQLServer = new TM.Connection.SQLServer();
FileManagerController.InsertDirectory(Common.Directories.HDData);
ViewBag.directory = TM.IO.FileDirectory.DirectoriesToList(Common.Directories.HDData).OrderByDescending(d => d).ToList();
ViewBag.dvvt = SQLServer.Connection.Query <Models.DICHVU_VT_BKN>("SELECT * FROM DICHVU_VT_BKN WHERE TT_UPLOAD=1 AND FLAG=1 ORDER BY ORDERS");
}
catch (Exception ex) { this.danger(ex.Message); }
return(View());
}
public async Task <IActionResult> Delete(string id)
{
try {
var SQLServer = new TM.Connection.SQLServer();
var sql = "SELECT TOP 30 * FROM db_goitichhop ORDER BY tengoi";
//
SQLServer.Close();
return(Json(new { total = "total", data = id }));
} catch (Exception ex) {
return(Json(new { Error = ex.Message }));
}
}
public JsonResult InsertUpdate(Models.BGCUOC obj, long?id)
{
//var provider = System.Globalization.CultureInfo.InvariantCulture;
var index = 0;
var qry = "";
var msg = "Cập nhật thông tin thành công!";
var profile_ip = "profile_ip";
try
{
SQLServer = new TM.Connection.SQLServer();
//
qry = $"SELECT i.*,g.TITLE AS GROUPTITLE FROM ITEMS i,GROUPS g WHERE i.GROUPID=g.GROUPID AND i.APPKEY='{profile_ip}' AND g.APPKEY='{profile_ip}' AND i.FLAG=1 AND g.FLAG=1 ORDER BY i.TITLE";
var ProfileIPList = SQLServer.Connection.QueryFirstOrDefault <Models.GROUPS>(qry);
//
if (id == null)
{
obj.CREATEDBY = Authentication.Auth.AuthUser.username;
obj.CREATEDAT = DateTime.Now;
SQLServer.Connection.Insert(obj);
msg = "Tạo mới thông tin thành công!";
}
else
{
qry = $"SELECT * FROM BGCUOC WHERE BGCUOCID={id}";
var data = SQLServer.Connection.QueryFirstOrDefault <Models.BGCUOC>(qry);
data.TENGOI = obj.TENGOI;
data.PROFILE = obj.PROFILE;
data.PROFILEIP = getProfileIP(ProfileIPList.TITLE, data.PROFILE);
data.TOCDO = obj.TOCDO;
data.GIA = obj.GIA;
data.DICHVUVT_ID = obj.DICHVUVT_ID;
data.GOICUOCID = obj.GOICUOCID;
data.TICHHOPID = obj.TICHHOPID;
data.IS_DATA = obj.IS_DATA;
data.IS_TH = obj.IS_TH;
data.GHICHU = obj.GHICHU;
data.NGAY_BD = obj.NGAY_BD;
data.NGAY_KT = obj.NGAY_KT;
data.EXTRA_TYPE = obj.EXTRA_TYPE;
data.UPDATEDBY = Authentication.Auth.AuthUser.username;
data.UPDATEDAT = DateTime.Now;
data.FLAG = obj.FLAG;
SQLServer.Connection.Update(data);
}
var ReturnJson = Json(new { success = msg }, JsonRequestBehavior.AllowGet);
ReturnJson.MaxJsonLength = int.MaxValue;
return(ReturnJson);
}
catch (Exception ex) { return(Json(new { danger = "Lỗi hệ thống vui lòng thực hiện lại!" }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
public JsonResult CheckConnection(AuthObj obj)
{
try
{
SQLServer = new TM.Connection.SQLServer();
SQLServer = new TM.Connection.SQLServer("Portal");
}
catch (Exception)
{
return(Json(new { danger = "Không thể kết nối đến CSDL!" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = "Đăng nhập thành công!" }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Update(int id, Billing.Core.Models.db_goitichhop data)
{
try {
var SQLServer = new TM.Connection.SQLServer();
var sql = "SELECT TOP 30 * FROM db_goitichhop ORDER BY tengoi";
//
SQLServer.Close();
return(Json(new { total = "total", data = data }));
} catch (Exception ex) {
return(Json(new { Error = ex.Message }));
}
}
public ActionResult UpdateDanhBaKhachHangNull(Guid id, string col, string val)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
try
{
var qry = $"UPDATE {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} SET {col}=N'{val}' WHERE ID='{id}'";
SQLServer.Connection.Query(qry);
return(Json(new { success = "Xử lý thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Connection.Close(); }
}
public ActionResult DanhBaKhachHangNull()
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
try
{
var qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE ISNULL=1 OR ISNULLMT=1 OR MA_DVI IS NULL OR MA_CBT IS NULL OR MA_TUYEN IS NULL";
var data = SQLServer.Connection.Query <Models.DB_THANHTOAN_BKN>(qry).ToList();
return(Json(new { data = data, success = "Xử lý thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Connection.Close(); }
}
public static void Set()
{
TM.Connection.SQLServer SQLServer = new TM.Connection.SQLServer();
try
{
var settings = SQLServer.Connection.GetAll <Models.Settings>();
TMAppContext.Http.Session.Set(SessionSettings, JsonConvert.SerializeObject(settings));
}
catch (Exception) { throw; }
finally
{
SQLServer.Close();
}
}
public JsonResult GetQuanHuyen()
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
string msg = "Lấy dữ liệu thành công!";
try
{
string qry = $"SELECT * FROM QUAN_HUYEN_BKN ORDER BY MA_QUANHUYEN";
var data = SQLServer.Connection.Query <Models.QUAN_HUYEN_BKN>(qry);
return(Json(new { data = data, success = msg }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
}
public JsonResult GetReportCustom()
{
var SQLServer = new TM.Connection.SQLServer();
var appkey = "report_doanh_thu";
var index = 0;
string msg = "Lấy báo cáo thành công!";
try
{
string qry = $"SELECT * FROM GROUPS WHERE APPKEY='{appkey}' AND FLAG=1 ORDER BY ORDERS";
var data = SQLServer.Connection.Query <Models.GROUPS>(qry);
return(Json(new { data = data, success = msg }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
}
public async Task <IActionResult> Select(int id)
{
try {
var SQLServer = new TM.Connection.SQLServer();
var sql = $"SELECT * FROM db_goitichhop WHERE id_goitichhop={id}";
var data = await SQLServer.Connection.QueryAsync <Billing.Core.Models.db_goitichhop>(sql);
var total = data.Count();
//
SQLServer.Close();
return(Json(new { total = total, data = data }));
} catch (Exception ex) {
return(Json(new { Error = ex.Message }));
}
}
public ActionResult InsertUpdate(Models.ITEMS obj, long?id) //string sort, string order, string search, int offset = 0, int limit = 10, int flag = 1
{
//var provider = System.Globalization.CultureInfo.InvariantCulture;
var index = 0;
var qry = "";
var msg = "Cập nhật thông tin thành công!";
try
{
SQLServer = new TM.Connection.SQLServer();
//
if (id == null)
{
obj.CREATEDBY = Authentication.Auth.AuthUser.username;
obj.CREATEDAT = DateTime.Now;
SQLServer.Connection.Insert(obj);
msg = "Cập nhật thông tin thành công!";
}
else
{
qry = $"SELECT * FROM ITEMS WHERE ITEMID={id}";
var data = SQLServer.Connection.QueryFirstOrDefault <Models.ITEMS>(qry);
data.APPKEY = obj.APPKEY;
data.GROUPID = obj.GROUPID;
data.TITLE = obj.TITLE;
data.DESCRIPTION = obj.DESCRIPTION;
data.CONTENTS = obj.CONTENTS;
data.AMOUNT_START = obj.AMOUNT_START;
data.AMOUNT_END = obj.AMOUNT_END;
data.IMAGES = obj.IMAGES;
data.ATTACH = obj.ATTACH;
data.AUTHOR = obj.AUTHOR;
data.QUANTITY = obj.QUANTITY;
data.POSITION = obj.POSITION;
data.ORDERS = obj.ORDERS;
data.FLAG = obj.FLAG;
data.UPDATEDBY = Authentication.Auth.AuthUser.username;
data.UPDATEDAT = DateTime.Now;
SQLServer.Connection.Update(data);
}
var ReturnJson = Json(new { success = msg }, JsonRequestBehavior.AllowGet);
ReturnJson.MaxJsonLength = int.MaxValue;
return(ReturnJson);
}
catch (Exception) { return(Json(new { danger = "Lỗi hệ thống vui lòng thực hiện lại!" }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
public JsonResult GetReportDetailCustom(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDData;
obj = getDefaultObj(obj);
string msg = "Lấy báo cáo thành công!";
try
{
string qry = $"SELECT * FROM ITEMS WHERE GROUPID={obj.data_id} AND FLAG=1 ORDER BY ORDERS";
var item = SQLServer.Connection.Query <Models.ITEMS>(qry);
var data = new ReportDetailCustom();
foreach (var i in item)
{
if (i.APPKEY == "header")
{
data.hd = i.DESCRIPTION;
data.hc = i.CONTENTS;
}
else if (i.APPKEY == "footer")
{
data.fd = i.DESCRIPTION;
data.fc = i.CONTENTS;
}
else if (i.APPKEY == "content")
{
if (i.QUANTITY == 0)
{
var FoxPro = new TM.Connection.OleDBF(obj.DataSource);
data.cd = FoxPro.Connection.Query(i.DESCRIPTION);
data.cc = FixContent(i.CONTENTS);
FoxPro.Close();
}
else if (i.QUANTITY == 1)
{
data.cd = SQLServer.Connection.Query(i.DESCRIPTION);
data.cc = FixContent(i.CONTENTS);
}
}
}
return(Json(new { data = data, datetime = obj.datetime, success = msg }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
}
public JsonResult ChangePassword(Guid id, string password)
{
try
{
SQLServer = new TM.Connection.SQLServer("Portal");
var qry = $"SELECT * FROM users WHERE id='{id.ToString()}'";
var user = SQLServer.Connection.QueryFirstOrDefault <Authentication.Users>(qry);
user.password = TM.Encrypt.CryptoMD5TM(password + user.salt);
SQLServer.Connection.Update(user);
}
catch (Exception)
{
return(Json(new { danger = "Cập nhật mật khẩu không thành công, vui lòng thử lại sau!" }, JsonRequestBehavior.AllowGet));
}
finally { SQLServer.Close(); }
return(Json(new { success = "Cập nhật mật khẩu thành công!" }, JsonRequestBehavior.AllowGet));
}
public JsonResult Get(long id)
{
var index = 0;
var qry = "";
try
{
SQLServer = new TM.Connection.SQLServer();
qry = $"SELECT * FROM BGCUOC WHERE BGCUOCID={id}";
var data = SQLServer.Connection.QueryFirstOrDefault <Models.BGCUOC>(qry);
var ReturnJson = Json(new { data = data, success = "Lấy dữ liệu thành công!" }, JsonRequestBehavior.AllowGet);
ReturnJson.MaxJsonLength = int.MaxValue;
return(ReturnJson);
}
catch (Exception) { return(Json(new { danger = "Không tìm thấy dữ liệu, vui lòng thực hiện lại!" }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
public ActionResult GetAppKey()
{
var index = 0;
var qry = "";
try
{
SQLServer = new TM.Connection.SQLServer();
qry = $"SELECT DISTINCT APPKEY FROM GROUPS";
var data = SQLServer.Connection.Query <Models.GROUPS>(qry);
var ReturnJson = Json(new { data = data, success = "Lấy dữ liệu thành công!" }, JsonRequestBehavior.AllowGet);
ReturnJson.MaxJsonLength = int.MaxValue;
return(ReturnJson);
}
catch (Exception) { return(Json(new { danger = "Không tìm thấy dữ liệu, vui lòng thực hiện lại!" }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
