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(); } }