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