private void btn_Luu_Click(object sender, EventArgs e) { if (validateGrid(gridView1.FocusedRowHandle)) { var result = MessageBox.Show("Bạn có muốn lưu sự thay đổi xuống cơ sở dữ liệu hay không?", "Lưu thông tin", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { DataUpdate <LinhKien_View> listUpdate = gridThaoTac.update(); if (LinhKien_DAL.saves(listUpdate)) { MessageBox.Show("Lưu thông tin thành công!"); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Lưu thông tin thất bại!"); } } } else { MessageBox.Show("Chưa nhập đầy đủ thông tin!"); } }
public void HandlePrintUpdate(object src, EventArgs e, string s) { // process print string Current.ProcessPrintStr(s); if (!Current.NewPrint) { return; } int i0; // update timeseries data objects for (i0 = 0; i0 < TimeSeries.Count; ++i0) { TimeSeries[i0].NewData(Current.Print); } for (i0 = 0; i0 < OHLC.Count; ++i0) { OHLC[i0].NewData(Current.Print); } for (i0 = 0; i0 < Volume.Count; ++i0) { Volume[i0].NewData(Current.Print); } // update timeframe analytics TFAnalytics.NewData(Current.Print); // call data update event DataUpdate?.Invoke(this, EventArgs.Empty); }
protected void OnDataUpdate(object source, CryptoIdDataUpdateEventArgs args) { if (DataUpdate != null) { DataUpdate.Invoke(source, args); } }
public ActionResult Entry(EntryModel model) { try { if (CheckModelIsValid(model)) { UserInfo sysUser = CacheInit.GetUserInfo(HttpContext); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); PasswordModifiyRepository rep = new PasswordModifiyRepository(); rep.DbUpdate = dbUpdate; rep.ModifiyPassword(model, sysUser.UserId); dbUpdate.Commit(); } catch (Exception ex) { dbUpdate.Rollback(); throw new Exception(ex.Message); } finally { dbUpdate.Close(); } } return(View(model)); } catch (Exception ex) { AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "PasswordModifiyController.Entry post", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace); return(new JsonResult()); } }
protected int Update(BarcodePrintRepository rep, Entry2Model model, string viewTitle) { UserInfo sysUser = CacheInit.GetUserInfo(HttpContext); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); rep.DbUpdate = dbUpdate; rep.Update(model, sysUser, viewTitle); dbUpdate.Commit(); return(1); } catch (Exception ex) { dbUpdate.Rollback(); model.Message = ex.Message; model.HasError = "true"; return(0); } finally { dbUpdate.Close(); } }
public int Update(UserInfo sysUser, EntryModel model) { List <DataTable> dtlist = new List <DataTable>(); string sql = @"select * from FiscalYear where 1<>1 "; DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0]; dt.TableName = "FiscalYear"; int formYear = DataConvert.ToInt32(model.FromYear); int toYear = DataConvert.ToInt32(model.ToYear); string sql2 = @"select * from FiscalPeriod where 1<>1 "; DataTable dt2 = AppMember.DbHelper.GetDataSet(sql2).Tables[0]; dt2.TableName = "FiscalPeriod"; for (int i = formYear; i <= toYear; i++) { DataRow dr = dt.NewRow(); string id = IdGenerator.GetMaxId(dt.TableName); dr["fiscalYearId"] = id; dr["fiscalYearName"] = i.ToString(); dr["fromDate"] = i.ToString() + "/01/01"; dr["toDate"] = i.ToString() + "/12/31"; dt.Rows.Add(dr); Create5Field(dt, sysUser.UserId, model.ViewTitle); UpdateFiscalPeriod(sysUser, model, i, id, dt2); } dtlist.Add(dt); dtlist.Add(dt2); DbUpdate = new DataUpdate(); return(DbUpdate.Update(dtlist, true)); }
public ActionResult BatchDelete(string pageId, string formMode, string viewTitle, string gridString, string isCascadeDelete) { try { UserInfo sysUser = CacheInit.GetUserInfo(HttpContext); AssetsRepository arep = new AssetsRepository(); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); arep.DbUpdate = dbUpdate; arep.BatchDelete(sysUser, gridString, viewTitle, isCascadeDelete); dbUpdate.Commit(); return(Content("1")); } catch (Exception) { dbUpdate.Rollback(); return(Content(AppMember.AppText["DeleteExistRefrence"])); } finally { dbUpdate.Close(); } } catch (Exception ex) { AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AssetsManageController.BatchDelete post", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace); return(Content("[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace, "text/html")); } }
public ActionResult ReplaceFavorit(string tableName, string pkValue) { try { UserInfo sysUser = CacheInit.GetUserInfo(HttpContext); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); CacheRepository drep = new CacheRepository(); drep.DbUpdate = dbUpdate; drep.ReplaceFavorit(pkValue, sysUser.UserId, tableName); dbUpdate.Commit(); } catch (Exception ex) { dbUpdate.Rollback(); throw new Exception(ex.Message); } finally { dbUpdate.Close(); } return(Content("0", "text/html")); } catch (Exception ex) { AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "MasterController.ReplaceFavorit", ControllerName + "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace); return(Content(ControllerName + "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace, "text/html")); } }
private void InnitVal(string maHD) { //gridThaoTac = new GridHelper<CT_HoaDon_View>(gridControl1); HoaDon_View hd_view = HoaDon_DAL.get_HoaDon_By_MaHD(maHD); tong_tien_old = hd_view.TongTien; dt = new DataUpdate <CT_HOADON>(); kh_vanglai = KhachHang_DAL.get_KhachHang_VangLai(); ls_cthd = new List <CT_HoaDon_View>(); if (maHD.Equals("")) { isNew = true; hoadon = new HoaDon_View(); hoadon.NhanVien = Context.getInstance().nv.TenNhanVien; hoadon.MaNhanVien = Context.getInstance().nv.MaNhanVien; hoadon.MaHoaDon = HoaDon_DAL.get_HoaDonMax(); hoadon.NgayLap = DateTime.Now; hoadon.GhiChu = ""; } else { isNew = false; hoadon = HoaDon_DAL.get_HoaDon_By_MaHD(maHD); } setDataLoad(); }
public static bool add_KiemKho(KiemKho_View hd, DataUpdate <CT_KIEMKHO> list_Change) { using (var transaction = Context.getInstance().db.Database.BeginTransaction()) { try { hd.TrangThai = 1; Context.getInstance().db.Entry(hd.toKiemKho()).State = System.Data.Entity.EntityState.Added; list_Change.Inserts.ForEach(x => { Context.getInstance().db.Entry(x).State = System.Data.Entity.EntityState.Added; }); Context.getInstance().db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); //Context.getInstance().db.KHOes.Local.Clear(); //Context.getInstance().db.CT_HOADON.Local.Clear(); //Context.getInstance().db.KHACHHANGs.Local.Clear(); //Context.getInstance().db.NHANVIENs.Local.Clear(); Context.Refresh(); Console.WriteLine("ERROR--------------------------------------" + ex.Message); return(false); } } return(true); }
public ActionResult Entry(EntryModel model) { if (ModelState.IsValid) { string gridHidStr = model.GridId + model.PageId + AppMember.HideString; List <Test> gridData = JsonHelper.JSONStringToList <Test>(Request.Form[gridHidStr]); string delPkHidStr = model.GridId + model.PageId + AppMember.DeletePK; string delPks = Request.Form[delPkHidStr]; UserInfo sysUser = CacheInit.GetUserInfo(HttpContext); DataUpdate dbUpdate = new DataUpdate(); dbUpdate.BeginTransaction(); TestRepository rep = new TestRepository(dbUpdate); Dictionary <string, object> objs = new Dictionary <string, object>(); objs.Add("gridData", gridData); objs.Add("deletePks", delPks); try { rep.Save(objs, sysUser, model.ViewTitle); dbUpdate.Commit(); } catch (Exception ex) { dbUpdate.Rollback(); throw new Exception(ex.Message); } model.HasError = "false"; } else { model.HasError = "true"; } model.GridLayout = GridLayout(); return(View(model)); }
public static void ExcuteAutoUpdateByThread() { if (!TaskExcuting) { TaskExcuting = true; //AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Debug, "AutoTask", string.Format(AppMember.AppText["AutoDepreciationProcess"])); AssetsDepreciationRepository rep = new AssetsDepreciationRepository(); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); rep.DbUpdate = dbUpdate; rep.UpdateAuto(AppMember.AppText["MonthAutoUpdate"]); dbUpdate.Commit(); } catch (Exception ex) { dbUpdate.Rollback(); AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AutoTask", ex.Message); throw ex; } finally { dbUpdate.Close(); TaskExcuting = false; } } }
public void SaveDistribution(List <Distribution> distribs) { foreach (DataRow drd in distribution.Rows) //Поиск удалённых распределений { bool found = false; foreach (Distribution dst in distribs) { if (dst.Id == drd.Field <long>("id")) { found = true; break; } } if (!found) { drd.Delete(); } } foreach (Distribution newDistr in distribs) { if (newDistr.Id == -1) { DataRow newDistribution = distribution.NewRow(); newDistribution["computerID"] = newDistr.ComputerID; newDistribution["userID"] = newDistr.UserID; distribution.Rows.Add(newDistribution); } } dbHelper.Save(); DataUpdate?.Invoke(); }
public string OrderUpdate([FromQuery] updateOrders UpdateData, [FromBody] UpdateOrderDetails UpdateDetailData) { //required information if (UpdateData.OrderID == 0) { return("Please input OrderID"); } string result, updateOrder, updateOrderDetial; var Update = new DataUpdate(); //Determine if Order need to update if (UpdateData.CustomerID != null || UpdateData.CustomerID != null || UpdateData.EmployeeID != null || UpdateData.OrderDate != null || UpdateData.RequiredDate != null || UpdateData.ShipVia != null || UpdateData.Freight != null || UpdateData.ShipName != null || UpdateData.ShipAddress != null || UpdateData.ShipCity != null || UpdateData.ShipRegion != null || UpdateData.ShipPostalCode != null || UpdateData.ShipCountry != null) { updateOrder = Update.UpdateOrderData(UpdateData); } else { updateOrder = "Order not Edit"; } //Determine if Order Detail need to update & ProductID is required information if (UpdateDetailData.ProductID != null & (UpdateDetailData.Quantity != null || UpdateDetailData.UnitPrice != null || UpdateDetailData.Discount != null)) { updateOrderDetial = Update.UpdateOrderDetailData(UpdateDetailData, UpdateData.OrderID); } else { updateOrderDetial = "Order Detail not Edit"; } result = updateOrder + " & " + updateOrderDetial; return(result); }
private static void OnTimedEvent(object source, System.Timers.ElapsedEventArgs e) { myTimer.Stop(); AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Debug, "AutoTask", string.Format(AppMember.AppText["AutoDepreciationProcess"])); AssetsDepreciationRepository rep = new AssetsDepreciationRepository(); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); rep.DbUpdate = dbUpdate; rep.UpdateAuto(AppMember.AppText["MonthAutoUpdate"]); dbUpdate.Commit(); } catch (Exception ex) { dbUpdate.Rollback(); throw ex; } finally { dbUpdate.Close(); myTimer.Start(); } }
public static bool saves(DataUpdate <HeThong_View> list) { using (var transaction = Context.getInstance().db.Database.BeginTransaction()) { try { list.Inserts.ForEach(x => { }); list.Updates.ForEach(x => { Context.getInstance().db.Entry(x.toHeThong()).State = System.Data.Entity.EntityState.Modified; }); list.Deletes.ForEach(x => { }); Context.getInstance().db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Context.Refresh(); Console.WriteLine("ERROR--------------------------------------" + ex.Message); return(false); } } return(true); }
[WebMethod] // 删除指定模板 public int fun10(int _class, string _LabelId) { AppInit.Init(); DataUpdate dbUpdate = new DataUpdate(); BarcodePrintRepository rep = new BarcodePrintRepository(); try { dbUpdate.BeginTransaction(); rep.DbUpdate = dbUpdate; string labelType = ""; if (_class == 0) { labelType = "Z"; } else { labelType = "C"; } rep.DeleteStyle(labelType, _LabelId, "Print Tools Update"); dbUpdate.Commit(); return(1); } catch (Exception) { dbUpdate.Rollback(); return(0); } finally { dbUpdate.Close(); } }
public static async Task <string> PostRequest(string postdata, DataUpdate _type) { try { string url = Settings.PublishDatabaseServerIp; CloudStreamCore.print("PUBLISHIP: " + url); int waitTime = 400; HttpWebRequest webRequest = (HttpWebRequest)HttpWebRequest.Create(url); if (CloudStreamCore.GetRequireCert(url)) { webRequest.ServerCertificateValidationCallback = delegate { return(true); }; } webRequest.Method = "POST"; webRequest.UserAgent = "CLOUDSTREAM APP v" + App.GetBuildNumber(); webRequest.Timeout = waitTime * 10; webRequest.ReadWriteTimeout = waitTime * 10; webRequest.ContinueTimeout = waitTime * 10; webRequest.Headers.Add("TYPE", ((int)_type).ToString()); try { HttpWebRequest _webRequest = webRequest; Stream postStream = await _webRequest.GetRequestStreamAsync(); string requestBody = postdata; // --- RequestHeaders --- byte[] byteArray = Encoding.UTF8.GetBytes(requestBody); postStream.Write(byteArray, 0, byteArray.Length); postStream.Close(); // BEGIN RESPONSE try { HttpWebRequest request = webRequest; HttpWebResponse response = (HttpWebResponse)(await webRequest.GetResponseAsync()); using StreamReader httpWebStreamReader = new StreamReader(response.GetResponseStream()); try { string s = await httpWebStreamReader.ReadToEndAsync(); CloudStreamCore.print("RESPONSEF FROM POST::: " + s); } catch (Exception) { return(""); } } catch (Exception _ex) { CloudStreamCore.error("FATAL EX IN POST2: " + _ex); } } catch (Exception _ex) { CloudStreamCore.error("FATAL EX IN POSTREQUEST" + _ex); } return(""); } catch (Exception _ex) { CloudStreamCore.error(_ex); return(""); } }
public void RunModel() { var importData = Task.Factory.StartNew(() => { GetInstall(); DataUpdate?.Invoke(); }); }
void Awake() { if (Instance != null) { return; } Instance = this; //DontDestroyOnLoad(this); }
protected int Update(IApproveEntry rep, ApproveEntryViewModel model, string pkValue, string approveReturn) { UserInfo sysUser = CacheInit.GetUserInfo(HttpContext); DataUpdate dbUpdate = new DataUpdate(); try { dbUpdate.BeginTransaction(); rep.DbUpdate = dbUpdate; if (model.FormMode != "approve") { //再申请的,将状态由再申请初期变为再申请 if (model.FormMode == "reapply") { ApproveRepository repApprove = new ApproveRepository(); repApprove.DbUpdate = rep.DbUpdate; repApprove.EditData(sysUser, model.ViewTitle, model.ApproveTableName, model.ApprovePkField, model.ApprovePkValue, "A", model.ApproveMind, model.ApproveNode); } if (CheckModelIsValid(model)) { rep.Update(model, sysUser, model.FormMode, pkValue, model.ViewTitle); } else { return(0); } } else { //ModelState.Clear(); if (ApproveAndUpdate(rep, model, pkValue, approveReturn, sysUser) == 0) { return(0); } int val = DealApprove(rep, model, approveReturn, ""); if (val == 0) { return(0); } } dbUpdate.Commit(); return(1); } catch (Exception ex) { dbUpdate.Rollback(); model.Message = ex.Message; model.HasError = "true"; AppLog.WriteLog(sysUser.UserName, LogType.Error, "UpdateError", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace); return(0); } finally { dbUpdate.Close(); } }
public IHttpActionResult Put(int id, string newName = "", int newAge = 0) { int check = DataUpdate.Update(connectionStr, id, newName, newAge); if (check != 0) { return(Ok()); } return(NotFound()); }
public static bool del_HoaDon(HoaDon_View hd, DataUpdate <CT_HOADON> list_Change) { using (var transaction = Context.getInstance().db.Database.BeginTransaction()) { try { hd.TrangThai = 0; Context.getInstance().db.Entry(hd.toHoaDon()).State = System.Data.Entity.EntityState.Modified; //list_Change.Inserts.ForEach(x => //{ //}); //list_Change.Updates.ForEach(x => //{ // x.TinhTrang = 1; // Context.getInstance().db.Entry(getCTHD(x)).State = System.Data.Entity.EntityState.Modified; //}); list_Change.Deletes.ForEach(x => { //set trang thai = 0 o day x.TinhTrang = 0; Context.getInstance().db.Entry(getCTHD(x)).State = System.Data.Entity.EntityState.Modified; //them trong kho KHO kho = Context.getInstance().db.KHOes.Where(key => key.MaLinhKien == x.MaLinhKien).Where(k => k.Seri == x.Seri).FirstOrDefault(); kho.TrangThai = 1; Context.getInstance().db.Entry(kho).State = System.Data.Entity.EntityState.Modified; }); //update so tien mua hang cua khach hang KHACHHANG kh = Context.getInstance().db.KHACHHANGs.Where(key => key.MaKhachHang == hd.MaKhachHang).FirstOrDefault(); kh.Tong -= hd.TongTien; Context.getInstance().db.Entry(kh).State = System.Data.Entity.EntityState.Modified; //update so luong ban hang cua nhan vien NHANVIEN mNV = Context.getInstance().db.NHANVIENs.Where(key => key.MaNhanVien == hd.MaNhanVien).FirstOrDefault(); mNV.TongTien -= hd.TongTien; Context.getInstance().db.Entry(mNV).State = System.Data.Entity.EntityState.Modified; Context.getInstance().db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Context.Refresh(); Console.WriteLine("ERROR--------------------------------------" + ex.Message); return(false); } } return(true); }
private DataUpdate GetDataUpdate(Applicant organization) { var dataUpdate = new DataUpdate() { TraceNumber = _app.ApplicationId.ToString(), ProcessingCode = "ExternalUpdateRequest", Source = "LoanOrigination", UpdateAction = "Add", Organization = GetOrganization(organization) }; return(dataUpdate); }
public void Start() { core.DataUpdate += Core_DataUpdate; var firstLaunch = Task.Factory.StartNew(() => { GetUsers(); GetSoftware(); GetComputers(); GetDivision(); GetUserNoComp(); DataUpdate?.Invoke(); }); }
public static async Task <string> _PostRequest(string postdata, DataUpdate _type) { try { string url = Settings.PublishDatabaseServerIp; CloudStreamCore.print("PUBLISHIP: " + url); HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url); request.Method = "POST"; byte[] byteArray = Encoding.UTF8.GetBytes(postdata); request.ContentType = "application/json"; request.ContentLength = byteArray.Length; request.Headers.Add("TYPE", ((int)_type).ToString()); Stream dataStream = await request.GetRequestStreamAsync(); dataStream.Write(byteArray, 0, byteArray.Length); dataStream.Close(); WebResponse response = await request.GetResponseAsync(); dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); string responseFromServer = await reader.ReadToEndAsync(); reader.Close(); dataStream.Close(); response.Close(); return(responseFromServer); } catch (WebException e) { CloudStreamCore.error(e); try { using (WebResponse response = e.Response) { HttpWebResponse httpResponse = (HttpWebResponse)response; Console.WriteLine("Error code: {0}", httpResponse.StatusCode); using Stream data = response.GetResponseStream(); using var reader = new StreamReader(data); string text = reader.ReadToEnd(); Console.WriteLine(text); } return(""); } catch (Exception _ex) { CloudStreamCore.error(_ex); return(""); } } catch (Exception _ex) { CloudStreamCore.error(_ex); return(""); } }
private DataUpdate GetDataUpdate(Applicant applicant) { var dataUpdate = new DataUpdate() { TraceNumber = _app.ApplicationId.ToString(), ProcessingCode = "ExternalUpdateRequest", Source = "LoanOrigination", UpdateAction = "Indeterminate", UpdateTarget = "AccountPartyRelationships", AccountPartyRelationships = GetAccountPartyRelationships(applicant) }; return(dataUpdate); }
private DataUpdate GetDataUpdate(LmsPerson lmsPerson) { var dataUpdate = new DataUpdate() { TraceNumber = _app.ApplicationId.ToString(), ProcessingCode = "ExternalUpdateRequest", Source = "LoanOrigination", UpdateAction = "Add", UpdateTarget = "Card", Card = GetCard(lmsPerson) }; return(dataUpdate); }
private DataUpdate GetDataUpdate(LmsPerson lmsPerson) { var dataUpdate = new DataUpdate() { TraceNumber = _app.ApplicationId.ToString(), ProcessingCode = "ExternalUpdateRequest", Source = "LoanOrigination", UpdateAction = "Modify", Person = GetPerson(lmsPerson), ModifiedFields = GetModifiedFields(lmsPerson) }; return(dataUpdate); }
private DataUpdate GetDataUpdate(Applicant primaryApplicant) { var dataUpdate = new DataUpdate() { TraceNumber = _app.ApplicationId.ToString(), ProcessingCode = "ExternalUpdateRequest", Source = "LoanOrigination", UpdateAction = "Modify", UpdateTarget = "Account", Account = GetAccount(primaryApplicant), ModifiedFields = GetModifiedFields(primaryApplicant) }; return(dataUpdate); }