private void LoadTable()
{
// Đoạn này quan trọng. Đăng nhập bằng user nào => connectionString tương ứng
this.taPX.Connection.ConnectionString =
this.taDSNV.Connection.ConnectionString =
this.taCTPX.Connection.ConnectionString =
this.taDSKHO.Connection.ConnectionString =
this.taDSVTCH.Connection.ConnectionString =
UtilDB.ConnectionString;
try
{
this.dataSet.EnforceConstraints = false;
this.taPX.Fill(this.dataSet.PhieuXuat);
this.taCTPX.Fill(this.dataSet.CTPX);
this.taDSNV.Fill(this.dataSet.DSNV);
this.taDSKHO.Fill(this.dataSet.DSKHO);
this.taDSVTCH.Fill(this.dataSet.DSVTCONHANG);
//this.dataSet.EnforceConstraints = true;
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
private async void btnSwitch_Click(object sender, EventArgs e)
{
if (UtilDB.CurrentDeployment == cboDepartment.SelectedIndex)
{
XtraMessageBox.Show(Cons.ErrorSwitchDepartToCurrent, Cons.CaptionError,
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int oldEmployeeId = int.Parse(txtEmployeeId.Text);
string newDepartId = UtilDB.GetDepartIdInFilterClause(cboDepartment.SelectedValue.ToString());
SplashScreenManager.ShowForm(null, typeof(WaitFormCustom), true, true, false);
if (await SwitchDepartment(oldEmployeeId, newDepartId) == false)
{
SplashScreenManager.CloseForm(false);
XtraMessageBox.Show(Cons.ErrorSwitchDepart, Cons.CaptionError,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
SplashScreenManager.CloseForm(false);
XtraMessageBox.Show(Cons.SuccessSwitchDepart, Cons.CaptionSuccess,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private async void DeleteDepot()
{
_currentPosition = bdsDepot.Position;
string ten = ((DataRowView)bdsDepot[_currentPosition])["TENKHO"].ToString();
var result = XtraMessageBox.Show(string.Format(Cons.AskDeleteDepot, ten), Cons.CaptionWarning,
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
try
{
// lưu lại data trước khi xóa
_userDo.Push(new ButtonAction(ButtonActionType.Delete, ((DataRowView)bdsDepot[_currentPosition]).Row.ItemArray));
//bdsDepot.RemoveCurrent();
//this.taDepot.Update(this.dataSet.Kho);
if (await UtilDB.DeleteInDB("Kho", "MAKHO", txtDepotId.EditValue))
{
this.dataSet.EnforceConstraints = false;
this.taDepot.Fill(this.dataSet.Kho);
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
}
private bool SaveDepot()
{
try
{
if (_buttonAction == ButtonActionType.Add &&
IsExistDepot(txtDepotId.EditValue.ToString()))
{
XtraMessageBox.Show(Cons.ErrorDuplicateDeportId, Cons.CaptionWarning,
MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtDepotId.Focus();
txtDepotId.SelectAll();
return(false);
}
bdsDepot.EndEdit();
this.taDepot.Update(this.dataSet.Kho);
gbDepot.Enabled = false;
bdsDepot.ResetCurrentItem();
DisableEditMode();
if (_buttonAction == ButtonActionType.Add)
{
// Lưu vô stack trạng thái nút nhấn và data bị thay đổi
_userDo.Push(new ButtonAction(_buttonAction, ((DataRowView)bdsDepot[bdsDepot.Position]).Row.ItemArray));
}
_buttonAction = ButtonActionType.None;
bdsDepot.Position = _currentPosition;
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
return(false);
}
return(true);
}
public Xrpt_ReportHDNV(string tenCN, string tenNV, int maNV, string loaiPhieu, string beginDay, string endDay)
{
InitializeComponent();
//lblTenNV.Text = tenNV;
//lblDate.Text = DateTime.Now.ToString("dddd, dd MMMM yyyy", Cons.CiVNI);
this.taReport_HDNV.Connection.ConnectionString = UtilDB.ConnectionString;
try
{
this.dataSetReport.EnforceConstraints = false;
this.taReport_HDNV.Fill(this.dataSetReport.Report_HDNV, maNV, loaiPhieu, beginDay, endDay);
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
var bds = UtilDB.BdsDSPM;
//lblCN.Text = tenCN;
//lblNhanVienLap.Text = UtilDB.CurrentFullName;
//lblFromTo.Text = string.Format("TỪ {0} ĐẾN {1}", DateTime.Parse(beginDay, null).ToString("dd/MM/yyyy"), DateTime.Parse(endDay, null).ToString("dd/MM/yyyy"));
}
private bool IsExistDepot(string depotId)
{
bool exist = true;
string strLenh = string.Format(MyConfig.ExecSPTimKho, depotId);
using (SqlConnection connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (SqlCommand sqlcmd = new SqlCommand(strLenh, connection))
{
sqlcmd.CommandType = CommandType.Text;
try
{
sqlcmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
if (ex.Number == MyConfig.ErrorMsgNumNotExistObject)
{
exist = false;
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
}
return(exist);
}
private bool IsExistMaterial(string materialId)
{
string strLenh = string.Format(MyConfig.ExecSPTimVatTu, materialId);
bool exist = true;
using (SqlConnection connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
SqlCommand sqlcmd = new SqlCommand(strLenh, connection);
sqlcmd.CommandType = CommandType.Text;
try
{
SqlDataReader myreader = sqlcmd.ExecuteReader();
}
catch (SqlException ex)
{
if (ex.Number == MyConfig.ErrorMsgNumNotExistObject)
{
exist = false;
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
return(exist);
}
private void LoadTable()
{
// Đoạn này quan trọng. Đăng nhập bằng user nào => connectionString tương ứng
this.taVT.Connection.ConnectionString =
this.taCTDDH.Connection.ConnectionString =
this.taCTPN.Connection.ConnectionString =
this.taCTPX.Connection.ConnectionString =
UtilDB.ConnectionString;
try
{
this.dataSet.EnforceConstraints = false;
this.taVT.Fill(this.dataSet.Vattu);
this.taCTDDH.Fill(this.dataSet.CTDDH);
this.taCTPX.Fill(this.dataSet.CTPX);
this.taCTPN.Fill(this.dataSet.CTPN);
//this.dataSet.EnforceConstraints = true;
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
private bool IsExistGoodsReceivedNote(string id)
{
bool exist = true;
using (SqlConnection connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (SqlCommand sqlcmd = new SqlCommand(MyConfig.ExecSPTimPhieuNhap, connection))
{
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@mapn", id);
try
{
sqlcmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
if (ex.Number == MyConfig.ErrorMsgNumNotExistObject)
{
exist = false;
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
}
return(exist);
}
private void SilenceBackup(object source, ElapsedEventArgs e)
{
List <string> credentials = UtilVarios.GetCredentialsDB();
string server = credentials[0];
string user = credentials[1];
string database = credentials[2];
string pass = credentials[3];
DataTable tbl = BL.GetDataBLL.RazonSocial();
string fileSilenceBck = @"c:\windows\temp\" + tbl.Rows[0][0].ToString() + "_bck.sql";
string remoteFile = tbl.Rows[0][0].ToString() + "_bck.sql.xz";
UtilDB.DumpDB(server, 3306, user, pass, database, fileSilenceBck);
if (File.Exists(fileSilenceBck + ".xz"))
{
File.Delete(fileSilenceBck + ".xz");
}
UtilDB.ZipDB(fileSilenceBck);
MemoryStream ms = new MemoryStream();
using (FileStream fs = File.OpenRead(fileSilenceBck + ".xz"))
{
fs.CopyTo(ms);
}
try
{
BL.UtilFTP.UploadFromMemoryStream(ms, remoteFile, "trendsistemas");
}
catch (WebException)
{
return;
}
}
/// <summary>
/// Kiểm tra username và mật khẩu có connect được với server
/// Lưu lại username và mật khẩu vào UtilDB
/// </summary>
/// <returns>true nếu connect thành công</returns>
private bool IsLogin()
{
UtilDB.CurrentLogin = txtTK.Text;
UtilDB.CurrentPassword = txtMK.Text;
return(UtilDB.Connect());
}
private void frmLogin_Load(object sender, EventArgs e)
{
string cnnStr = $"Data Source={MyConfig.RootServerName};" +
$"Initial Catalog={MyConfig.DatabaseName};" +
$"Integrated Security=True";
try
{
UtilDB.BdsDSPM.DataSource = UtilDB.ExecSqlDataTable($"SELECT * FROM {MyConfig.ViewDSPMName} ORDER BY {MyConfig.DisplayMemberDSPM}", cnnStr);
if (UtilDB.BdsDSPM.DataSource == null)
{
Close();
return;
}
cboChiNhanh.DataSource = UtilDB.BdsDSPM;
cboChiNhanh.DisplayMember = MyConfig.DisplayMemberDSPM;
cboChiNhanh.ValueMember = MyConfig.ValueMemberDSPM;
cboChiNhanh.SelectedIndex = -1;
cboChiNhanh.SelectedIndex = 0;
}
catch (SqlException ex)
{
UtilDB.ShowError(ex);
}
txtTK.Select();
}
private bool RemoveLogin(string employeeId)
{
bool isSuccess = false;
string strLenh = string.Format(MyConfig.ExecSPXoaLogin, employeeId);
using (SqlConnection connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (SqlCommand sqlcmd = new SqlCommand(strLenh, connection))
{
sqlcmd.CommandType = CommandType.Text;
try
{
sqlcmd.ExecuteNonQuery();
isSuccess = true;
}
catch (SqlException ex)
{
if (ex.Number == MyConfig.ErrorMsgNumNotExistObject)
{
isSuccess = true;
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
}
return(isSuccess);
}
private bool chechInStockMaterials(string maPhieu, string maVattu, int quantity)
{
bool exist = true;
string strLenh = string.Format(MyConfig.ExecSPCheckInStockMaterial, maPhieu, maVattu, quantity);
using (SqlConnection connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (SqlCommand sqlcmd = new SqlCommand(strLenh, connection))
{
sqlcmd.CommandType = CommandType.Text;
try
{
sqlcmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
if (ex.Number == MyConfig.ErrorMsgNumNotExistObject)
{
exist = false;
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
}
return(exist);
}
private void LoadTable()
{
// Đoạn này quan trọng. Đăng nhập bằng user nào => connectionString tương ứng
this.taNV.Connection.ConnectionString =
this.taDH.Connection.ConnectionString =
this.taPN.Connection.ConnectionString =
this.taPX.Connection.ConnectionString =
UtilDB.ConnectionString;
try
{
this.dataSet.EnforceConstraints = false;
// TODO: This line of code loads data into the 'dataSet.NhanVien' table. You can move, or remove it, as needed.
this.taNV.Fill(this.dataSet.NhanVien);
// TODO: This line of code loads data into the 'dataSet.DatHang' table. You can move, or remove it, as needed.
this.taDH.Fill(this.dataSet.DatHang);
// TODO: This line of code loads data into the 'dataSet.PhieuXuat' table. You can move, or remove it, as needed.
this.taPX.Fill(this.dataSet.PhieuXuat);
// TODO: This line of code loads data into the 'dataSet.PhieuNhap' table. You can move, or remove it, as needed.
this.taPN.Fill(this.dataSet.PhieuNhap);
//this.dataSet.EnforceConstraints = true;
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
private void LoadTable()
{
// Đoạn này quan trọng. Đăng nhập bằng user nào => connectionString tương ứng
this.taDDH.Connection.ConnectionString =
this.taCTDDH.Connection.ConnectionString =
this.taDSVT.Connection.ConnectionString =
this.taDSKHO.Connection.ConnectionString =
this.taDSNCC.Connection.ConnectionString =
this.taDSNV.Connection.ConnectionString =
this.taDSVT.Connection.ConnectionString =
UtilDB.ConnectionString;
try
{
this.dataSet.EnforceConstraints = false;
this.taDDH.Fill(this.dataSet.DatHang);
this.taCTDDH.Fill(this.dataSet.CTDDH);
this.taDSVT.Fill(this.dataSet.DSVT);
this.taDSNCC.Fill(this.dataSet.DSNCC);
this.taDSNV.Fill(this.dataSet.DSNV);
this.taDSKHO.Fill(this.dataSet.DSKHO);
this.taDSVT.Fill(this.dataSet.DSVT);
//this.dataSet.EnforceConstraints = true;
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
private async Task <bool> SwitchDepartment(int oldId, string newDepartment)
{
using (SqlConnection connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(MyConfig.SpChuyenChiNhanh, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@manv", oldId);
command.Parameters.AddWithValue("@chinhanhmoi", newDepartment);
try
{
await command.ExecuteNonQueryAsync();
return(true);
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
return(false);
}
}
}
}
private bool SaveDeliveryNote()
{
try
{
txtCustomerName.Text = txtCustomerName.Text.Trim();
if (IsSaveGoodsDeliveryNote() == false)
{
return(false);
}
SaveALlDataDetail();
((DataRowView)bdsPX.Current).Row.ItemArray = GetDataOrder();
bdsPX.EndEdit();
//UtilDB.UpdateWithTransaction(() =>
//{
// this.taPX.Update(this.dataSet.PhieuXuat);
// this.taCTPX.Update(this.dataSet.CTPX);
//}, taPX, taCTPX);
using (var connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (var trans = connection.BeginTransaction())
{
taPX.Connection = trans.Connection;
taCTPX.Connection = trans.Connection;
taPX.Transaction = trans;
taCTPX.Transaction = trans;
try
{
this.taPX.Update(this.dataSet.PhieuXuat);
this.taCTPX.Update(this.dataSet.CTPX);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
}
taDSVTCH.Fill(dataSet.DSVTCONHANG);
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
// xử lý tạm thời
DisableEditMode();
btnRefresh.PerformClick();
return(false);
}
return(true);
}
public frmReportTongHopNhapXuat()
{
InitializeComponent();
if (UtilDB.CurrentGroup.Equals(MyConfig.CongTyGroupName))
{
labelControl1.Visible = cboDepartment.Visible = btnFull.Visible = true;
UtilDB.SetupDSCN(cboDepartment, () => { });
}
}
private void ShowControlsByGroup(string grName)
{
if (grName.Equals("congty"))
{
UtilDB.SetupDSCN(cboDeployment, LoadTable);
this.pnPickDepartment.Visible = true;
btnAdd.Enabled = false;
}
}
/// <summary>
/// Uncompress a block of data found in an EncyclopeDIA library.
/// </summary>
private byte[] UncompressEncyclopeDiaData(byte[] compressedBytes, int uncompressedSize)
{
// Pass -1 in for uncompressed length since EnclyclopeDIA always compresses
// the bytes even if the uncompressed size is equal to the compresssed size.
byte[] uncompressedBytes = UtilDB.Uncompress(compressedBytes, -1, false);
if (uncompressedBytes.Length != uncompressedSize)
{
throw new IOException(Resources.UtilDB_Uncompress_Failure_uncompressing_data);
}
return(uncompressedBytes);
}
private bool SaveOrder()
{
try
{
if (IsSaveOrder() == false)
{
return(false);
}
SaveALlDataOrderDetailOnView();
((DataRowView)bdsDDH.Current).Row.ItemArray = GetDataOrder();
bdsDDH.EndEdit();
//UtilDB.UpdateWithTransaction(() =>
//{
// this.taDDH.Update(this.dataSet.DatHang);
// this.taCTDDH.Update(this.dataSet.CTDDH);
//}, taDDH, taCTDDH);
using (var connection = new SqlConnection(UtilDB.ConnectionString))
{
connection.Open();
using (var trans = connection.BeginTransaction())
{
taDDH.Connection = trans.Connection;
taCTDDH.Connection = trans.Connection;
taDDH.Transaction = trans;
taCTDDH.Transaction = trans;
try
{
this.taDDH.Update(this.dataSet.DatHang);
this.taCTDDH.Update(this.dataSet.CTDDH);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
}
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
// xử lý tạm thời
DisableEditMode();
btnRefresh.PerformClick();
return(false);
}
return(true);
}
private void cboChiNhanh_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboChiNhanh.SelectedValue == null)
{
return;
}
try
{
UtilDB.ServerName = cboChiNhanh.SelectedValue.ToString();
}
catch (Exception ex) { UtilDB.ShowError(ex); }
}
private void frmReportHDVN_Load(object sender, EventArgs e)
{
taDSNV.Connection.ConnectionString = UtilDB.ConnectionString;
try
{
this.taDSNV.Fill(this.dataSet.DSNV);
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
public frmReportDSNV()
{
InitializeComponent();
if (UtilDB.CurrentGroup.Equals(MyConfig.CongTyGroupName))
{
pnPickDepartment.Visible = true;
UtilDB.SetupDSCN(cboDepartment, () =>
{
danhSachNhanVien = new Xrpt_DanhSachNhanVien(cboDepartment.Text);
documentViewer.DocumentSource = danhSachNhanVien;
danhSachNhanVien.CreateDocument();
});
}
}
public frmReportDSDVT()
{
InitializeComponent();
if (UtilDB.CurrentGroup.Equals(MyConfig.CongTyGroupName))
{
lblCN.Visible = cboDepartment.Visible = btnPrint.Visible = true;
UtilDB.SetupDSCN(cboDepartment, () => {
});
}
else
{
lblCN.Visible = cboDepartment.Visible = btnPrint.Visible = false;
}
}
public ActionResult Index()
{
if (Session["usuarioId"] != null)
{
ViewBag.EntityFramework = UtilDB.GetVersionAssembly("EntityFramework");
ViewBag.Postgres = UtilDB.GetVersionAssembly("Npgsql");
ViewBag.MVC = typeof(Controller).Assembly.GetName().Version;// = UtilDB.GetVersionAssembly("System.Web.Mvc");
return(View());
}
else
{
return(RedirectToAction("Login"));
}
}
private async void Undo()
{
ButtonAction action = (ButtonAction)_userDo.Pop();
int position = -1;
try
{
switch (action.ActionType)
{
case ButtonActionType.Add:
// xóa dữ liệu mới
//position = bdsNV.Find("MANV", action.SaveItems[0]);
//bdsNV.Remove((DataRowView)bdsNV[position]);
if (await UtilDB.DeleteInDB("NhanVien", "MANV", action.SaveItems[0]))
{
//this.dataSet.EnforceConstraints = false;
this.taNV.Fill(this.dataSet.NhanVien);
//this.dataSet.EnforceConstraints = true;
}
break;
case ButtonActionType.Edit:
// sửa lại dữ liệu cũ
position = bdsNV.Find("MANV", action.SaveItems[0]);
((DataRowView)bdsNV[position]).Row.ItemArray = action.SaveItems;
bdsNV.EndEdit();
//bdsNV.ResetCurrentItem();
break;
case ButtonActionType.Delete:
// Thêm dữ liệu cũ vào
position = bdsNV.Count;
bdsNV.AddNew();
((DataRowView)bdsNV[position]).Row.ItemArray = action.SaveItems;
bdsNV.EndEdit();
break;
case ButtonActionType.None:
default:
break;
}
this.taNV.Update(this.dataSet.NhanVien);
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
private void backup_Click(object sender, EventArgs e)
{
SaveFileDialog fichero = new SaveFileDialog();
fichero.Filter = "SQL (*.sql)|*.sql";
fichero.FileName = "Backup";
if (fichero.ShowDialog() == DialogResult.OK)
{
List <string> credentials = UtilVarios.GetCredentialsDB();
string server = credentials[0];
string user = credentials[1];
string database = credentials[2];
string pass = credentials[3];
UtilDB.DumpDB(server, 3306, user, pass, database, fichero.FileName);
}
}
private void LoadTable()
{
this.taVTCONHANG.Connection.ConnectionString =
UtilDB.ConnectionString;
try
{
this.dataSet.EnforceConstraints = false;
this.taVTCONHANG.Fill(this.dataSet.DSVTCONHANG);
}
catch (Exception ex)
{
UtilDB.ShowError(ex);
}
}
private DataSet executeQuery(string command, string datasetName = "DS", string tableName = "TABLE")
{
if ((dbFileName == null) || (dbFileName.Length == 0))
{
m_lastError = "Internal error: database file missing (function executeQuery)!";
return null;
}
string connectionString = "Data Source=" + dbFileName + ";Version=3;";
UtilDB dbUtil = new UtilDB(connectionString);
if (!(dbUtil.Load(command, "")))
{
m_lastError = dbUtil.LastError;
return null;
}
DataSet ds = dbUtil.DataSet;
ds.DataSetName = datasetName;
ds.Namespace = NAME_SPACE_URN;
ds.Tables[0].TableName = tableName;
return ds;
}
