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 ImportTextData(string txtDataVal, int actionType)
{
var SQLServer = new TM.Connection.SQLServer();
long index = 0;
var provider = System.Globalization.CultureInfo.InvariantCulture;
var msg = "Cập nhật thành công";
var profile_ip = "profile_ip";
try
{
//
if (string.IsNullOrEmpty(txtDataVal))
{
return(Json(new { danger = "Vui lòng nhập giá trị!" }, JsonRequestBehavior.AllowGet));
}
//
//var 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 qry = $"SELECT * FROM GROUPS WHERE APPKEY='{profile_ip}' AND FLAG=1 ORDER BY TITLE";
var ProfileIPList = SQLServer.Connection.QueryFirstOrDefault <Models.GROUPS>(qry);
var dataRow = txtDataVal.Split('\n');
//Remove old
if (actionType == 2)
{
qry = $"DELETE BGCUOC";
SQLServer.Connection.Query(qry);
}
index = 0;
//
var dataList = new List <Models.BGCUOC>();
foreach (var i in dataRow)
{
index++;
var tmp = i.Trim('\r').Split('\t');
if (index == 1)
{
continue;
}
if (tmp.Length > 13)
{
var _data = new Models.BGCUOC();
_data.TENGOI = string.IsNullOrEmpty(tmp[0]) ? null : tmp[0].Trim();
_data.PROFILE = string.IsNullOrEmpty(tmp[1]) ? null : tmp[1].Trim();
_data.PROFILEIP = getProfileIP(ProfileIPList.TITLE, _data.PROFILE);
_data.TOCDO = string.IsNullOrEmpty(tmp[2]) ? 0 : int.Parse(tmp[2].Trim());
_data.GIA = string.IsNullOrEmpty(tmp[3]) ? 0 : decimal.Parse(tmp[3].Trim());
_data.DICHVUVT_ID = string.IsNullOrEmpty(tmp[4]) ? 0 : int.Parse(tmp[4].Trim());
_data.GOICUOCID = string.IsNullOrEmpty(tmp[5]) ? 0 : int.Parse(tmp[5].Trim());
_data.TICHHOPID = string.IsNullOrEmpty(tmp[6]) ? 0 : int.Parse(tmp[6].Trim());
_data.IS_DATA = string.IsNullOrEmpty(tmp[7]) ? 0 : int.Parse(tmp[7].Trim());
_data.IS_TH = string.IsNullOrEmpty(tmp[8]) ? 0 : int.Parse(tmp[8].Trim());
if (!string.IsNullOrEmpty(tmp[9]))
{
_data.NGAY_BD = DateTime.ParseExact(tmp[9], "dd/MM/yyyy", provider);
}
if (!string.IsNullOrEmpty(tmp[10]))
{
_data.NGAY_KT = DateTime.ParseExact(tmp[10], "dd/MM/yyyy", provider);
}
_data.EXTRA_TYPE = string.IsNullOrEmpty(tmp[11]) ? 0 : int.Parse(tmp[11].Trim());
_data.FLAG = string.IsNullOrEmpty(tmp[12]) ? 0 : int.Parse(tmp[12].Trim());
_data.GHICHU = string.IsNullOrEmpty(tmp[13]) ? null : tmp[13].Trim();
_data.CREATEDBY = Authentication.Auth.AuthUser.username;
_data.CREATEDAT = DateTime.Now;
//PROFILEIP
//var PROFILEIP = ProfileIPList.TITLE.Trim(',').Split(',');
//_data.PROFILEIP = ",";
//if (!string.IsNullOrEmpty(tmp[1]))
// foreach (var item in PROFILEIP)
// {
// var PROFILEList = tmp[1].Split('_');
// _data.PROFILEIP += PROFILEList.Length > 1 ? $"{PROFILEList[0]}{item}_{PROFILEList[1]}," : "";
// }
////_data.PROFILEIP = string.IsNullOrEmpty(tmp[0]) ? null : tmp[0].Trim();
dataList.Add(_data);
}
}
//
SQLServer.Connection.Insert(dataList);
return(Json(new { success = $"{msg} - Count: {dataList.Count}" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
