private void btnDel_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (grvData.DataSource == null) { return; } int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); if (id == 0) { return; } if (MaterialFileLinkBO.Instance.CheckExist("MaterialID", id)) { if (MessageBox.Show("Vật tư [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] đang liên kết với các file thư viện.\n Bạn có thật sự muốn xóa nó không?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.No) { return; } DataTable dt = TextUtils.Select("select Path,MaterialID,MaterialCode from vMaterialFile with(nolock) where FileType = 0 and MaterialID = " + id); if (dt.Rows.Count > 0) { DocUtils.InitFTPTK(); DocUtils.DeleteFile(dt.Rows[0][0].ToString()); } pt.Delete("Material", id); pt.DeleteByAttribute("MaterialConnect", "MaterialID", id.ToString()); pt.DeleteByAttribute("MaterialParameterLink", "MaterialID", id.ToString()); pt.DeleteByAttribute("MaterialFileLink", "MaterialID", id.ToString()); } else { if (MessageBox.Show("Bạn có chắc muốn xóa vật tư [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] không?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } pt.Delete("Material", id); pt.DeleteByAttribute("MaterialConnect", "MaterialID", id.ToString()); pt.DeleteByAttribute("MaterialParameterLink", "MaterialID", id.ToString()); } pt.CommitTransaction(); LoadInfoSearch(); } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
/// <summary> /// Insert du lieu vao History /// </summary> /// <param name="Action">Hanh dong "Insert" - "Update" - "Delete"</param> /// <param name="Model">Model cua doi tuong can ghi</param> /// <param name="pt">ProcessTransaction</param> public static void InsertHistory(string Action, BaseModel Model, ProcessTransaction pt) { //#region Khai bao model History //DateTime SysDate = GetSystemDate(); //DateTime BusinessDate = GetBusinessDate(); //PropertyInfo[] propertiesName = Model.GetType().GetProperties(); //HistoryModel mH = new HistoryModel(); //mH.Action = Action; //mH.BusinessDate = BusinessDate; //mH.ComputerName = GetHostName(); //mH.Content = TextUtils.GetXmlContent(Model); //mH.CreateDate = SysDate; //mH.ObjectID = Convert.ToInt32(propertiesName[0].GetValue(Model, null)); //mH.SystemDate = SysDate; //mH.TableName = Model.GetType().Name.Substring(0, Model.GetType().Name.Length - 5); //mH.UpdateDate = SysDate; //mH.UserID = Global.UserID; //mH.UserName = Global.UserName; //mH.UserInsertID = Global.UserID; //mH.UserUpdateID = Global.UserID; //#endregion //#region Insert to history //pt.Insert(mH); //#endregion }
public void ProcessTransaction_GivenThatTransactionRequestIsValid_ShouldCreateTransactionSendMessageAndReturnTransaction() { Environment.SetEnvironmentVariable("QueueName", "teste123"); var transactionRequest = new TransactionRequest { AccountOrigin = "123", AccountDestination = "456", Value = 55.32F }; var transaction = new Transaction { TransactionRequest = transactionRequest, TransactionId = Guid.NewGuid().ToString(), Status = new StatusResponse { Status = TransactionStatus.In_Queue.ToString(), Message = "" } }; var transactionRegistersRepositoryMock = new Mock <ITransactionRegistersRepository>(); var rabbitMQProducerClientMock = new Mock <IRabbitMQProducerClient>(); IProcessTransaction processTransaction = new ProcessTransaction( transactionRegistersRepositoryMock.Object, rabbitMQProducerClientMock.Object ); var result = processTransaction.Execute(transactionRequest); transactionRegistersRepositoryMock.Verify(repoMock => repoMock.Create(It.IsAny <Transaction>()), Times.Once); rabbitMQProducerClientMock.Verify(queueMock => queueMock.SendMessage("teste123", It.IsAny <string>()), Times.Once); Assert.AreEqual(result.Status.Message, transaction.Status.Message); Assert.AreEqual(result.Status.Status, transaction.Status.Status); Assert.AreEqual(result.TransactionRequest, transaction.TransactionRequest); }
private void btnApprove_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có chắc muốn xóa hoàn toàn những file này không?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } foreach (int item in grvGrid.GetSelectedRows()) { int mID = TextUtils.ToInt(grvGrid.GetRowCellValue(item, colMaterialFileID)); ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { //Delete file in ftp DocUtils.DeleteFile(grvGrid.GetRowCellValue(item, colPath).ToString()); // pt.Delete("MaterialFile", mID); pt.DeleteByAttribute("MaterialFileLink", "MaterialFileID", mID.ToString()); pt.CommitTransaction(); } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!checkValid()) { return; } ModuleErrorTypeModel model; if (_isAdd) { model = new ModuleErrorTypeModel(); } else { model = (ModuleErrorTypeModel)ModuleErrorTypeBO.Instance.FindByPK(_id); } //model.Type = cboType.SelectedIndex; model.Type = 0; model.Name = txtName.Text.Trim(); model.GroupID = (int)cboGroup.SelectedValue; if (_isAdd) { pt.Insert(model); } else { pt.Update(model); } pt.CommitTransaction(); if (model.GroupID == 0) { loadGroup(); } loadTree(); SetInterface(false); ClearInterface(); _isSaved = true; } catch (Exception ex) { TextUtils.ShowError("Lưu trữ không thành công!", ex); } finally { pt.CloseConnection(); } }
private void btnCopyN_Click(object sender, EventArgs e) { //chuyển thông số đích sang nguồns int groupID = TextUtils.ToInt(cboMaterialGroupN.EditValue); if (groupID == 0) { MessageBox.Show("Bạn hãy chọn nhóm vật tư.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } foreach (int rowHandle in grvData.GetSelectedRows()) { string name = grvData.GetRowCellValue(rowHandle, colNameN).ToString(); DataTable dt; dt = TextUtils.Select("select Name from MaterialParameters where MaterialGroupID =" + groupID + " and Name = N'" + name + "'"); if (dt != null) { if (dt.Rows.Count > 0) { MessageBox.Show("Tên thông số [" + name + "] này đã tồn tại!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); continue; } } ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { MaterialParametersModel model = new MaterialParametersModel(); model.CreatedDate = TextUtils.GetSystemDate(); model.CreatedBy = Global.AppUserName; model.UpdatedDate = model.CreatedDate; model.UpdatedBy = Global.AppUserName; model.Name = grvData.GetRowCellValue(rowHandle, colNameN).ToString(); model.MaterialGroupID = TextUtils.ToInt(cboMaterialGroupN.EditValue); DataTable dtmax = TextUtils.Select("SELECT isnull(MAX(STT),0) FROM MaterialParameters with(nolock) where MaterialParameters.MaterialGroupID = " + model.MaterialGroupID); model.STT = TextUtils.ToInt(dtmax.Rows[0][0].ToString()) + 1; pt.Insert(model); pt.CommitTransaction(); loadGridParasN(); } catch (Exception) { } finally { pt.CloseConnection(); } } }
private void btnSaveN_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (checkValidN()) { MaterialParametersModel model = new MaterialParametersModel(); if (isAddN) { model.CreatedDate = TextUtils.GetSystemDate(); model.CreatedBy = Global.AppUserName; model.UpdatedDate = model.CreatedDate; model.UpdatedBy = Global.AppUserName; } else { int ID = Convert.ToInt32(grvDataN.GetFocusedRowCellValue(colID).ToString()); model = (MaterialParametersModel)MaterialParametersBO.Instance.FindByPK(ID); model.UpdatedDate = model.CreatedDate; model.UpdatedBy = Global.AppUserName; } model.Name = txtNameN.Text; model.MaterialGroupID = TextUtils.ToInt(cboMaterialGroupN.EditValue); if (isAddN) { DataTable dt = TextUtils.Select("SELECT isnull(MAX(STT),0) FROM MaterialParameters with(nolock) where MaterialParameters.MaterialGroupID = " + model.MaterialGroupID); model.STT = TextUtils.ToInt(dt.Rows[0][0].ToString()) + 1; pt.Insert(model); } else { pt.Update(model); } pt.CommitTransaction(); loadGridParasN(); SetInterfaceN(false); cboMaterialGroupN.Enabled = true; ClearInterfaceN(); } } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
void save(bool close) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } if (CoCau.ID == 0) { CoCau = new CoCauMauModel(); } CoCau.Name = txtName.Text.Trim().ToUpper(); CoCau.Code = txtCode.Text.Trim().ToUpper(); CoCau.CoCauGroupID = TextUtils.ToInt(cboGroup.EditValue); //CoCau.Note = txtDescription.Text.Trim(); CoCau.Description = txtDescription.Text.Trim(); CoCau.Specifications = txtTSKT.Text.Trim(); CoCau.ImagePath = pictureBox1.ImageLocation; if (CoCau.ID == 0) { CoCau.ID = (int)pt.Insert(CoCau); } else { pt.Update(CoCau); } pt.CommitTransaction(); _isSaved = true; if (close) { this.DialogResult = DialogResult.OK; } else { MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
void save() { mnuMenu.Focus(); ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } PartBorrow.DateBorrow = (DateTime?)dtpDateBorrow.EditValue; PartBorrow.DateReturn = (DateTime?)dtpDateReturn.EditValue; PartBorrow.DateReturnExpected = (DateTime?)dtpDateReturnExpected.EditValue; PartBorrow.Price = TextUtils.ToDecimal(txtPrice.EditValue); PartBorrow.Qty = TextUtils.ToDecimal(txtQty.EditValue); PartBorrow.QtyBorrow = TextUtils.ToDecimal(txtQtyBorrow.EditValue); PartBorrow.QtyReturn = TextUtils.ToDecimal(txtQtyReturn.EditValue); PartBorrow.Total = TextUtils.ToDecimal(txtTotal.EditValue); PartBorrow.Description = txtDescription.Text.Trim(); PartBorrow.PartsId = TextUtils.ToString(cboPart.EditValue); PartBorrow.Unit = TextUtils.ToString(cboUnit.SelectedValue); PartBorrow.UserId = TextUtils.ToString(cboUser.EditValue); if (PartBorrow.ID == 0) { PartBorrow.ID = (long)pt.Insert(PartBorrow); } else { pt.Update(PartBorrow); } pt.CommitTransaction(); _isSaved = true; MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information); if (this.LoadDataChange != null) { this.LoadDataChange(null, null); } } catch (Exception ex) { MessageBox.Show("Lưu trữ không thành công!" + Environment.NewLine + ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { Model.Name = txtName.Text.Trim(); Model.ParentID = TextUtils.ToInt(cboParent.SelectedValue); Model.Type = Type; Model.Description = txtDes.Text.Trim(); Model.Extension = txtExtension.Text.Trim(); Model.Contain = txtContain.Text.Trim(); if (ParentID == 0) { Model.ParentPath = DPath; Model.Path = Path.Combine(DPath, txtName.Text.Trim()); } else { Model.ParentPath = ((DesignStructureModel)DesignStructureBO.Instance.FindByPK(ParentID)).Path; Model.Path = Path.Combine(Model.ParentPath, txtName.Text.Trim()); } if (Model.ID == 0) { Model.CreatedDate = TextUtils.GetSystemDate(); Model.CreatedBy = Global.AppUserName; Model.UpdatedDate = Model.CreatedDate; Model.UpdatedBy = Global.AppUserName; Model.ID = (int)pt.Insert(Model); } else { Model.UpdatedDate = TextUtils.GetSystemDate(); Model.UpdatedBy = Global.AppUserName; pt.Update(Model); } CurentNode = Model.ID; pt.CommitTransaction(); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (checkValid()) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); if (!isAdd) { _model = (ConfigSystemModel)ConfigSystemBO.Instance.FindByPK(TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID))); } _model.KeyName = txtKey.Text.Trim(); _model.KeyValue = txtDuongDan.Text.Trim(); _model.Description = txtMoTa.Text.Trim(); if (isAdd) { _model.CreatedDate = TextUtils.GetSystemDate(); _model.CreatedBy = Global.AppUserName; _model.UpdatedDate = _model.CreatedDate; _model.UpdatedBy = Global.AppUserName; _model.ID = (int)pt.Insert(_model); } else { _model.UpdatedDate = TextUtils.GetSystemDate(); _model.UpdatedBy = Global.AppUserName; pt.Update(_model); } pt.CommitTransaction(); pt.CloseConnection(); LoadData(); if (isAdd) { MessageBox.Show("Tạo mới thành công!"); } else { MessageBox.Show("Cập nhật thành công!"); } SetInterface(false); ClearInterface(); } } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void saveDN(ProcessTransaction pt, int count, DataRow row) { int stt = TextUtils.ToInt(row["F1"]); decimal qty = TextUtils.ToDecimal(row["F7"]); C_QuotationDetail_SXModel item = new C_QuotationDetail_SXModel(); item.C_QuotationID = Quotation.ID; item.ParentID = 0; item.Qty = item.QtyT = qty; item.PriceVT = TextUtils.ToDecimal(row["F41"]); item.PriceVTTN = TextUtils.ToDecimal(row["F42"]); item.PriceVTPS = TextUtils.ToDecimal(row["F43"]); item.Manufacture = TextUtils.ToString(row["F4"]); item.ModuleCode = TextUtils.ToString(row["F3"]); item.ModuleName = TextUtils.ToString(row["F2"]); item.Origin = TextUtils.ToString(row["F5"]); item.C_ProductGroupID = TextUtils.ToInt(LibQLSX.ExcuteScalar("select ID from C_ProductGroup where Code = '" + TextUtils.ToString(row["F6"]) + "'")); item.ID = (int)pt.Insert(item); count++; row["ID"] = item.ID; DataRow[] drs = _dtData.Select("F1 like '" + stt + ".%'"); foreach (DataRow rowC in drs) { decimal qtyC = TextUtils.ToDecimal(rowC["F7"]); string groupCode = TextUtils.ToString(rowC["F6"]); int groupID = TextUtils.ToInt(LibQLSX.ExcuteScalar("select ID from C_ProductGroup where Code = '" + groupCode + "'")); C_QuotationDetail_SXModel itemC = new C_QuotationDetail_SXModel(); itemC.C_QuotationID = Quotation.ID; itemC.ParentID = item.ID; itemC.C_ProductGroupID = groupID; itemC.Qty = qtyC; itemC.QtyT = qtyC / item.Qty; itemC.PriceVT = TextUtils.ToDecimal(rowC["F41"]); itemC.PriceVTTN = TextUtils.ToDecimal(row["F42"]); itemC.PriceVTPS = TextUtils.ToDecimal(row["F43"]); itemC.ModuleName = TextUtils.ToString(rowC["F2"]); itemC.ModuleCode = TextUtils.ToString(rowC["F3"]); itemC.Manufacture = TextUtils.ToString(rowC["F4"]); itemC.Origin = TextUtils.ToString(rowC["F5"]); itemC.ID = (int)pt.Insert(itemC); rowC["ID"] = itemC.ID; count++; } }
private void btnDelete_Click(object sender, EventArgs e) { using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang xóa file...")) { if (grvData.RowCount <= 0) { return; } int materialFileID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); if (materialFileID == 0) { return; } string filePath = grvData.GetFocusedRowCellValue(colPath).ToString(); string fileName = grvData.GetFocusedRowCellValue(colFileName).ToString(); DataTable dt = TextUtils.Select("MaterialFileLink", new Expression("MaterialFileID", materialFileID)); if (dt.Rows.Count >= 1) { MessageBox.Show("File [" + fileName + "]" + " đã được đính kèm với nhiều vật tư.\n Bạn không thế xóa file này!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Question); return; } if (MessageBox.Show("Bạn có thật sự muốn xóa file [" + fileName + "] này không?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { pt.Delete("MaterialFile", materialFileID); pt.DeleteByAttribute("MaterialFileLink", "MaterialFileID", materialFileID.ToString()); DocUtils.DeleteFile(filePath); pt.CommitTransaction(); } catch (Exception) { } finally { pt.CloseConnection(); } loadGrid(); } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } Model.Code = txtCode.Text.Trim(); Model.Name = txtName.Text.Trim(); Model.TotalTime = (double)txtTotalTime.Value; Model.ProductID = TextUtils.ToInt(leProducts.EditValue); Model.WorkStatusID = cboStatus.SelectedIndex; Model.WorkTypeID = cboWorkType.SelectedIndex; Model.Type = cboType.SelectedIndex; Model.TotalScore = TextUtils.ToDouble(txtTotalScore.Value); Model.Priority = TextUtils.ToInt(txtPriority.Value); Model.Description = txtDescription.Text.Trim(); if (Model.ID == 0) { Model.CreatedDate = TextUtils.GetSystemDate(); Model.CreatedBy = Global.AppUserName; Model.UpdatedDate = Model.CreatedDate; Model.UpdatedBy = Global.AppUserName; Model.ID = (int)pt.Insert(Model); } else { Model.UpdatedDate = TextUtils.GetSystemDate(); Model.UpdatedBy = Global.AppUserName; pt.Update(Model); } pt.CommitTransaction(); MessageBox.Show("Lưu trữ thành công!", "Thông báo"); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnDeleteFile_Click(object sender, EventArgs e) { DocUtils.InitFTPTK(); if (grvFile.RowCount <= 0) { return; } int id = TextUtils.ToInt(grvFile.GetFocusedRowCellValue(colFileID)); string filePath = TextUtils.ToString(grvFile.GetFocusedRowCellValue(colFileLocalPath)); string fileName = Path.GetFileName(filePath); if (MessageBox.Show("Bạn có thật sự muốn xóa file [" + fileName + "] này không?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } if (id == 0) { grvFile.DeleteSelectedRows(); } else { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { pt.Delete("SolutionFile", id); if (DocUtils.CheckExits(filePath)) { DocUtils.DeleteFile(filePath); } pt.CommitTransaction(); grvFile.DeleteSelectedRows(); } catch (Exception ex) { MessageBox.Show("Xóa file [" + fileName + "] không thành công!" + Environment.NewLine + ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); } finally { pt.CloseConnection(); } } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (checkValid()) { CostDetailModel dModel; if (_isAdd) { dModel = new CostDetailModel(); } else { int ID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); dModel = (CostDetailModel)CostDetailBO.Instance.FindByPK(ID); } dModel.Code = txtCode.Text.Trim(); dModel.Name = txtName.Text.Trim(); dModel.Description = txtDescription.Text.Trim(); dModel.Type = cboCostType.SelectedIndex; dModel.IsFix = chkIsFix.Checked ? 1 : 0; dModel.DepartmentID = TextUtils.ToInt(cboDepartment.EditValue); if (_isAdd) { pt.Insert(dModel); } else { pt.Update(dModel); } pt.CommitTransaction(); loadData(); SetInterface(false); ClearInterface(); } } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnDeleteFile_Click(object sender, EventArgs e) { using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang xóa file lên server!")) { DocUtils.InitFTPTK(); if (grvDataImage.RowCount <= 0) { return; } int id = TextUtils.ToInt(grvDataImage.SelectedRows[0].Cells[colID.Name].Value); if (id == 0) { return; } string filePath = grvDataImage.SelectedRows[0].Cells[colFilePath.Name].Value.ToString(); string fileName = grvDataImage.SelectedRows[0].Cells[colFileName.Name].Value.ToString(); if (MessageBox.Show("Bạn có thật sự muốn xóa file [" + fileName + "] này không?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { pt.Delete("MisMatchImage", id); if (DocUtils.CheckExits(filePath)) { DocUtils.DeleteFile(filePath); } pt.CommitTransaction(); } catch (Exception ex) { MessageBox.Show("Xóa file [" + fileName + "] không thành công!" + Environment.NewLine + ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop); } finally { pt.CloseConnection(); } loadGridImage(); } }
void save() { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } //PartA.Name = txtName.Text.Trim().ToUpper(); //PartA.Code = txtCode.Text.Trim().ToUpper(); //PartA.Type = cboType.SelectedIndex; //PartA.Unit = txtUnit.Text.Trim(); PartA.QtyMin = TextUtils.ToDecimal(txtQtyMin.EditValue); PartA.QtyDM = TextUtils.ToDecimal(txtQtyDM.EditValue); PartA.ProjectPercent = TextUtils.ToDecimal(txtProjectPercent.EditValue); //PartA.Price = TextUtils.ToDecimal(txtPrice.EditValue); PartA.IsProject = PartA.ProjectPercent > 0 ? 1 : 0; PartA.Qty = TextUtils.ToDecimal(txtQty.EditValue); //PartA.Hang = txtHang.Text.Trim(); //if (PartA.ID == 0) //{ // PartA.ID = (int)pt.Insert(PartA); //} //else //{ pt.UpdateQLSX(PartA); //} pt.CommitTransaction(); _isSaved = true; MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } if (Model == null) { Model = new FormAndFunctionModel(); } Model.Name = txtName.Text.Trim(); Model.Code = txtCode.Text.Trim(); Model.FormAndFunctionGroupID = TextUtils.ToInt(leParentCat.EditValue); Model.IsHide = false; if (Model.ID == 0) { Model.CreatedDate = TextUtils.GetSystemDate(); Model.CreatedBy = Global.AppUserName; Model.UpdatedDate = Model.CreatedDate; Model.UpdatedBy = Global.AppUserName; Model.ID = (int)pt.Insert(Model); } else { Model.UpdatedDate = TextUtils.GetSystemDate(); Model.UpdatedBy = Global.AppUserName; pt.Update(Model); } pt.CommitTransaction(); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { PayVouchersModel dModel; if (_isAdd) { dModel = new PayVouchersModel(); } else { int ID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); dModel = (PayVouchersModel)PayVouchersBO.Instance.FindByPK(ID); } if (!checkValid(dModel)) { return; } dModel.Name = txtName.Text.Trim(); dModel.Type = cboType.SelectedIndex; if (_isAdd) { pt.Insert(dModel); } else { pt.Update(dModel); } pt.CommitTransaction(); loadData(); SetInterface(false); ClearInterface(); } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { Model.Name = txtName.Text.Trim(); Model.ParentID = TextUtils.ToInt(cboParent.SelectedValue); Model.DepartmentID = DepartmentID; Model.Description = txtDes.Text.Trim(); Model.FolderType = cboFolderType.SelectedIndex; if (ParentID == 0) { Model.ParentPath = DPath; Model.Path = Path.Combine(DPath, txtName.Text.Trim()); } else { Model.ParentPath = ((PBDLStructureModel)PBDLStructureBO.Instance.FindByPK(ParentID)).Path; Model.Path = Path.Combine(Model.ParentPath, txtName.Text.Trim()); } if (Model.ID == 0) { Model.ID = (int)pt.Insert(Model); } else { pt.Update(Model); } CurentNode = Model.ID; pt.CommitTransaction(); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
void CreateVersion(BaiThucHanhModel BaiThucHanh) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { // Tạo phiên bản bài thực hành BaiThucHanhVersionModel versionModel = new BaiThucHanhVersionModel(); versionModel.BaiThucHanhID = BaiThucHanh.ID; versionModel.Reason = "Tạo phiên bản đầu tiên"; versionModel.Version = BaiThucHanh.Version; versionModel.ID = (int)pt.Insert(versionModel); //Tạo các phiên bản module bài thực hành ArrayList lisModules = BaiThucHanhModuleBO.Instance.FindByAttribute("BaiThucHanhID", BaiThucHanh.ID); if (lisModules.Count > 0) { foreach (var item in lisModules) { BaiThucHanhModuleModel thisModule = (BaiThucHanhModuleModel)item; BaiThucHanhModuleVersionModel moduleVersion = new BaiThucHanhModuleVersionModel(); moduleVersion.BTHVersionID = versionModel.ID; moduleVersion.Code = thisModule.Code; moduleVersion.CVersion = thisModule.CVersion; moduleVersion.Hang = thisModule.Hang; moduleVersion.Name = thisModule.Name; moduleVersion.Qty = thisModule.Qty; moduleVersion.Type = thisModule.Type; moduleVersion.ID = (int)pt.Insert(moduleVersion); } } pt.CommitTransaction(); } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnDeleteApprove_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { for (int i = 0; i < grvData.RowCount; i++) { if (grvData.DataSource == null) { return; } int id = TextUtils.ToInt(grvData.GetRowCellValue(i, colID)); if (id == 0) { return; } File3DModel model = (File3DModel)File3DBO.Instance.FindByPK(id); if (!model.IsDeleted) { continue; } if (MessageBox.Show("Bạn có chắc muốn duyệt xóa file [" + grvData.GetFocusedRowCellValue(colName).ToString() + "] ?", TextUtils.Caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { continue; } pt.Delete("File3D", id); File.Delete(model.Path); } pt.CommitTransaction(); LoadInfoSearch(); } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
void save(bool close) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } MisMatch.StatusTK = cboStatus.SelectedIndex; if (MisMatch.ID == 0) { MisMatch.ID = (int)pt.Insert(MisMatch); } else { pt.Update(MisMatch); } pt.CommitTransaction(); _isSaved = true; if (close) { this.DialogResult = DialogResult.OK; } else { MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
private void btnChooseFile_Click(object sender, EventArgs e) { frmDatasheet frm = new frmDatasheet(); frm.ChooseFile = true; frm.CustomerID = Material.CustomerID; frm.Text += ": " + Material.Code + " - " + Material.Name; bool added = false; if (frm.ShowDialog() == DialogResult.OK) { foreach (int item in frm.ListMaterialFileID) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { MaterialFileLinkModel model = new MaterialFileLinkModel(); model.MaterialID = Material.ID; model.MaterialFileID = item; pt.Insert(model); added = true; if (added) { //MaterialModel material = (MaterialModel)MaterialBO.Instance.FindByPK(Material.ID); Material.FileDatasheet = 1; pt.Update(Material); } pt.CommitTransaction(); } catch (Exception) { } finally { pt.CloseConnection(); } } loadDatasheet(); } }
private void btnDeleteGroup_Click(object sender, EventArgs e) { if (grvData.RowCount > 0) { if (MessageBox.Show("Bạn có chắc chắn muốn xóa?", TextUtils.Caption, MessageBoxButtons.YesNo) == DialogResult.Yes) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); int id = (int)grvData.GetRowCellValue(grvData.FocusedRowHandle, "ID"); pt.Delete("VatTuThayThe", id); pt.CommitTransaction(); pt.CloseConnection(); LoadGrid(); } } }
private void btnSave_Click(object sender, EventArgs e) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } if (Model == null) { Model = new BaiThucHanhGroupModel(); } Model.Name = txtName.Text.Trim().ToUpper(); Model.Code = txtCode.Text.Trim().ToUpper(); Model.Description = txtDescription.Text.Trim(); Model.ParentID = TextUtils.ToInt(leParentCat.EditValue); if (Model.ID == 0) { Model.ID = (int)pt.Insert(Model); } else { pt.Update(Model); } pt.CommitTransaction(); CurentNode = Model.ID; this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } }
void saveGiaTri(ProcessTransaction pt) { if (treeValue.Nodes.Count == 0) { return; } int paraID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); if (paraID == 0) { return; } if (Material.ID <= 0) { return; } for (int i = 0; i < treeValue.Nodes.Count; i++) { int valID = TextUtils.ToInt(treeValue.GetNodeByVisibleIndex(i).GetValue(colIDValue)); DataTable dt = TextUtils.Select("MaterialConnect", new Expression("MaterialID", Material.ID) .And(new Expression("MaterialParameterID", paraID)) .And(new Expression("MaterialParameterValueID", valID))); if (dt.Rows.Count > 0) { if (!treeValue.GetNodeByVisibleIndex(i).Checked) { pt.Delete("MaterialConnect", TextUtils.ToInt(dt.Rows[0]["ID"])); } } else { if (treeValue.GetNodeByVisibleIndex(i).Checked) { MaterialConnectModel modelM = new MaterialConnectModel(); modelM.MaterialID = Material.ID; modelM.MaterialParameterID = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID)); modelM.MaterialParameterValueID = valID; pt.Insert(modelM); } } } }
void save(bool close) { ProcessTransaction pt = new ProcessTransaction(); pt.OpenConnection(); pt.BeginTransaction(); try { if (!ValidateForm()) { return; } Product.CostGroupID = TextUtils.ToInt(cboCostGroup.EditValue); pt.Update(Product); pt.CommitTransaction(); _isSaved = true; if (close) { this.DialogResult = DialogResult.OK; } else { MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { pt.CloseConnection(); } if (_isSaved && close) { this.Close(); } }
public static async Task <HttpResponseMessage> CreateTransaction(ProcessTransaction processTransaction) { var client = new HttpClient(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); DefaultContractResolver contractResolver = new DefaultContractResolver { NamingStrategy = new CamelCaseNamingStrategy() }; var transactionRequestString = JsonConvert.SerializeObject(processTransaction, new JsonSerializerSettings { ContractResolver = contractResolver, }); var content = new StringContent(transactionRequestString, Encoding.UTF8, "application/json"); return(await client.PostAsync(AuthorizeUrl, content)); }