protected void grdRecibos_DeleteCommand(object sender, GridCommandEventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
List <gsEgresosVarios_BuscarDetalleResult> lst = JsonHelper.JsonDeserialize <List <gsEgresosVarios_BuscarDetalleResult> >((string)ViewState["lstEVDetalle"]);
lst.Find(x => x.ID_Amarre == (decimal)((GridDataItem)e.Item).GetDataKeyValue("ID_Amarre")).Estado = 0;
ViewState["lstEVDetalle"] = JsonHelper.JsonSerializer(lst);
lblTotal.Text = "Total: " + lst.ToList().AsEnumerable().Sum(x => x.Importe).ToString();
grdRecibos.DataSource = lst.FindAll(x => x.Estado == 1);
grdRecibos.DataBind();
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
// 6. Thay doi thong tin mat khau
public bool ChangePassword(string password)
{
Account account = _guestModel.GetActiveAccountByUserName(Program.currentLogin.Username);
if (account == null)
{
Console.WriteLine("Không tìm thấy tài khoản hoặc tài khoản đã bị khóa!");
return(false);
}
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
try
{
var salt = account.Salt;
var passwordHash = _passwordHelper.MD5Hash(password + salt);
var stringCmdUpdateAccount =
$"UPDATE `accounts` SET `passwordHash` = '{passwordHash}' WHERE username = '******' AND status = {(int) AccountStatus.ACTIVE}";
var cmdUpdateAccount = new MySqlCommand(stringCmdUpdateAccount, cnn);
cmdUpdateAccount.ExecuteNonQuery();
cnn.Close();
Console.WriteLine("Đổi mật khẩu thành công!");
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
cnn.Close();
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
if (!Page.IsPostBack)
{
Title = "Registrar producto";
Item_Buscar(Request.QueryString["idItem"], Request.QueryString["idCliente"], decimal.Parse(Request.QueryString["idAlmacen"]),
Convert.ToBoolean(Int32.Parse(Request.QueryString["nuevo"])));
}
lblMensaje.Text = "Datos del producto se cargo correctamente.";
lblMensaje.CssClass = "mensajeExito";
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
// 3. Tim kiem theo ten
public Account GetUserByAccountName(string name)
{
Account account = null;
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
var stringCmdGetAccount = (
$"SELECT * FROM `accounts` WHERE fullName = '{name}'"
);
var cmdGetAccount = new MySqlCommand(stringCmdGetAccount, cnn);
var accountReader = cmdGetAccount.ExecuteReader();
if (accountReader.Read())
{
account = new Account()
{
AccountNumber = accountReader.GetString("accountNumber"),
Balance = accountReader.GetDouble("balance"),
Username = accountReader.GetString("userName"),
PhoneNumber = accountReader.GetString("phoneNumber"),
Role = (AccountRole)accountReader.GetInt32("role"),
FullName = accountReader.GetString("fullName"),
Email = accountReader.GetString("email"),
Status = (AccountStatus)accountReader.GetInt32("status")
};
}
cnn.Close();
return(account);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
if (!Page.IsPostBack)
{
var idMarca = (Request.QueryString["idMarca"]);
var imagen = (Request.QueryString["imagen"]);
Page.Title = "Logo Marca";
imgLogo.ImageUrl = "Documentos/" + idMarca + "/" + imagen;
LoginWCF.LoginWCFClient objLoginWCF = new LoginWCF.LoginWCFClient();
objLoginWCF.AuditoriaMenu_Registrar(System.Web.HttpContext.Current.Request.Url.AbsolutePath, Environment.MachineName,
((Usuario_LoginResult)System.Web.HttpContext.Current.Session["Usuario"]).idUsuario);
}
}
catch (Exception ex)
{
}
}
// 9. Thay doi thong tin tai khoan
public bool EditAccount(string phoneNumber, string fullName, string email)
{
var account = GetUserByAccountAccountNumber(Program.currentLogin.AccountNumber);
if (account == null)
{
Console.WriteLine("Không tìm thấy tài khoản hoặc tài khoản đã bị khóa!");
return(false);
}
try
{
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
var stringCmdEditAccount =
$"UPDATE `accounts` SET `phoneNumber` = '{phoneNumber}', `fullName` = '{fullName}', `email` = '{email}' WHERE accountNumber = '{Program.currentLogin.AccountNumber}' AND status = {(int) AccountStatus.ACTIVE}";
var cmdEditAccount = new MySqlCommand(stringCmdEditAccount, cnn);
cmdEditAccount.ExecuteNonQuery();
cnn.Close();
Console.WriteLine("Thay đổi thành công.");
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(false);
}
public Account GetActiveAccountByUserName(string username)
{
Account account = null;
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
var stringCmdGetAccount = $"select * from accounts where username = '******' and " +
$"status = {(int)AccountStatus.ACTIVE}";
var cmdGetAccount = new MySqlCommand(stringCmdGetAccount, cnn);
var readerGetAccount = cmdGetAccount.ExecuteReader();
if (readerGetAccount.Read())
{
account = new Account()
{
AccountNumber = readerGetAccount.GetString("accountNumber"),
Username = readerGetAccount.GetString("userName"),
Balance = readerGetAccount.GetDouble("balance"),
PasswordHash = readerGetAccount.GetString("passwordHash"),
Email = readerGetAccount.GetString("email"),
PhoneNumber = readerGetAccount.GetString("phoneNumber"),
Salt = readerGetAccount.GetString("salt"),
FullName = readerGetAccount.GetString("fullName"),
Role = (AccountRole)readerGetAccount.GetInt32("role"),
Status = (AccountStatus)readerGetAccount.GetInt32("status")
};
}
cnn.Close();
return(account);
}
static async Task Main()
{
Console.Title = "Samples.SqlServer.Native.ErrorProcessor";
Console.WriteLine("Press any key to exit");
await CreateErrorQueue().ConfigureAwait(false);
#region MessageProcessingLoop
long startingRow;
var rowVersionTracker = new RowVersionTracker();
using (var connection = await ConnectionHelpers.OpenConnection(SqlHelper.ConnectionString)
.ConfigureAwait(false))
{
await rowVersionTracker.CreateTable(connection).ConfigureAwait(false);
startingRow = await rowVersionTracker.Get(connection).ConfigureAwait(false);
}
Task Callback(SqlTransaction sqlTransaction, IncomingBytesMessage message, CancellationToken cancellation)
{
var bodyText = Encoding.UTF8.GetString(message.Body);
Console.WriteLine($"Message received in error queue:\r\n{bodyText}");
return(Task.CompletedTask);
}
void ErrorCallback(Exception exception)
{
Environment.FailFast("Message processing loop failed", exception);
}
Task PersistRowVersion(SqlTransaction transaction, long rowVersion, CancellationToken cancellation)
{
return(rowVersionTracker.Save(transaction, rowVersion, cancellation));
}
Task <SqlTransaction> TransactionBuilder(CancellationToken cancellation)
{
return(ConnectionHelpers.BeginTransaction(SqlHelper.ConnectionString, cancellation));
}
var processingLoop = new MessageProcessingLoop(
table: "error",
delay: TimeSpan.FromSeconds(1),
transactionBuilder: TransactionBuilder,
callback: Callback,
errorCallback: ErrorCallback,
startingRow: startingRow,
persistRowVersion: PersistRowVersion);
processingLoop.Start();
Console.ReadKey();
await processingLoop.Stop()
.ConfigureAwait(false);
#endregion
}
// 5. Thay doi thong tin ca nhan
public bool ChangeUser(string email, string phoneNumber, string fullName)
{
var account = _guestModel.GetActiveAccountByUserName(Program.currentLogin.Username);
if (account == null)
{
Console.WriteLine("Không tìm thấy tài khoản hoặc tài khoản đã bị khóa!");
return(false);
}
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
try
{
var stringCmdUpdateAccount =
$"UPDATE `accounts` SET `phoneNumber` = '{phoneNumber}', `fullName` = '{fullName}', `email` = '{email}' WHERE username = '******' AND status = {(int) AccountStatus.ACTIVE}";
var cmdUpdateAccount = new MySqlCommand(stringCmdUpdateAccount, cnn);
cmdUpdateAccount.ExecuteNonQuery();
cnn.Close();
Console.WriteLine("Thay đổi thông tin thành công!");
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
cnn.Close();
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
if (!Page.IsPostBack)
{
lblTitulo.Text = "Clases Marca";
Page.Title = "Clases Marca";
LoginWCF.LoginWCFClient objLoginWCF = new LoginWCF.LoginWCFClient();
objLoginWCF.AuditoriaMenu_Registrar(System.Web.HttpContext.Current.Request.Url.AbsolutePath, Environment.MachineName,
((Usuario_LoginResult)System.Web.HttpContext.Current.Session["Usuario"]).idUsuario);
BuscarClases();
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
Response.Redirect("~/Security/frmCerrar.aspx");
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("Revisar su conexión a internet.");
}
try {
if (!Page.IsPostBack)
{
dpFechaInicio.SelectedDate = DateTime.Now.AddMonths(-1);
dpFechaFinal.SelectedDate = DateTime.Now;
EgresosVarios_Listar(((Usuario_LoginResult)Session["Usuario"]).nroDocumento, dpFechaInicio.SelectedDate.Value, dpFechaFinal.SelectedDate.Value);
lblMensaje.Text = "Se encontraron " + grdEgresosVarios.Items.Count.ToString() + " registros.";
lblMensaje.CssClass = "mensajeExito";
}
}
catch (Exception ex) {
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
private static void SaveConnection(Settings settings)
{
SaveLatestConnectionString(settings.ConnectionString);
var baseFileName = BuildBaseFileName();
var file = $@"{baseFileName}-Connection.dat";
var connectionString = settings.ConnectionString;
if (!File.Exists(file) && connectionString.IsFilled())
{
File.Create(file).Dispose();
Status.Update("[Settings] Created a new connection file.");
}
if (!File.Exists(file))
{
return;
}
Status.Update("[Settings] Writing to file ...");
var encodedString = Convert.ToBase64String(Encoding.UTF8.GetBytes(connectionString));
File.WriteAllText(file, encodedString);
Status.Update($"[Settings] Connection string: {ConnectionHelpers.SecureConnectionString(connectionString)}");
}
protected void grdCobranza_ItemCommand(object sender, GridCommandEventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
string mensaje = "";
lblMensaje.Text = "";
try
{
if (e.CommandName == "Eliminar")
{
if (ValidarValores(ref mensaje) == false)
{
int id_proyectado = 0;
id_proyectado = int.Parse(e.CommandArgument.ToString());
string obj = Request.QueryString["objDocumento"];
char delimiter = '}';
string[] arryString = Request.QueryString["objDocumento"].Split(delimiter);
arryString[0] = arryString[0] + "}";
arryString[1] = arryString[1].Substring(1, 6);
string fecha = arryString[1];
gsReporte_EstadoCuenta_BIResult objDocumento = JsonHelper.JsonDeserialize <gsReporte_EstadoCuenta_BIResult>(arryString[0]);
CobranzasWCFClient objCobranzaWCF = new CobranzasWCFClient();
objCobranzaWCF.ProyectadoCobranza_Eliminar(
((Usuario_LoginResult)Session["Usuario"]).idEmpresa, ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, id_proyectado);
Proyeccion_Sectorista(0, fecha, 0, objDocumento.Origen, (int)objDocumento.OrigenOp, 1);
lblMensaje.Text = "Se eliminó el registro.";
lblMensaje.CssClass = "mensajeExito";
}
else
{
lblMensaje.Text = mensaje;
lblMensaje.CssClass = "mensajeError";
}
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
public static async Task Run()
{
using (var connection = await ConnectionHelpers.OpenConnection(SqlHelper.ConnectionString)
.ConfigureAwait(false))
{
var dedupeManager = new DedupeManager(connection, "Deduplication");
await dedupeManager.Create().ConfigureAwait(false);
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
gsItem_BuscarResult objItem;
try
{
if (txtCantidad.Value <= 0)
{
throw new ArgumentException("ERROR: La cantidad ingresada debe ser mayor a 0.");
}
if (!Convert.ToBoolean(Int32.Parse(Request.QueryString["nuevo"])))
{
objItem = new gsItem_BuscarResult();
objItem = ((List <gsItem_BuscarResult>)Session["lstProductos"]).Find(x => x.Item_ID.ToString() == Request.QueryString["idItem"]);
((List <gsItem_BuscarResult>)Session["lstProductos"]).Remove(objItem);
}
objItem = new gsItem_BuscarResult();
objItem = JsonHelper.JsonDeserialize <gsItem_BuscarResult>((string)ViewState["objItem"]);
objItem.Precio = Math.Round(decimal.Parse(txtPrecio.Text), 4);
objItem.Cantidad = Int32.Parse(txtCantidad.Text);
objItem.Importe = Math.Round(objItem.Precio * Int32.Parse(txtCantidad.Text), 4);
objItem.Observacion = txtObservacion.Text;
objItem.Descuento = Math.Round(decimal.Parse(txtDescuento.Text), 2);
objItem.FactorUnidadInv = Math.Round(decimal.Parse(txtFactor.Text), 2);
objItem.Stock = Math.Round(decimal.Parse(txtStock.Text), 0);;
objItem.Estado = 1;
if (Session["lstProductos"] == null)
{
List <gsItem_BuscarResult> lstProductos = new List <gsItem_BuscarResult>();
Session["lstProductos"] = lstProductos;
}
((List <gsItem_BuscarResult>)Session["lstProductos"]).Add(objItem);
Impuesto_Guardar(objItem.Codigo, Convert.ToBoolean(Int32.Parse(Request.QueryString["nuevo"])));
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CloseAndRebind(" + objItem.Item_ID + ");", true);
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
static async Task CreateQueue()
{
using (var connection = await ConnectionHelpers.OpenConnection(SqlHelper.ConnectionString)
.ConfigureAwait(false))
{
var queueManager = new QueueManager("NativeEndpoint", connection);
await queueManager.Create()
.ConfigureAwait(false);
}
}
async Task ReadLoop()
{
#region ProcessingLoop
var rowVersionTracker = new RowVersionTracker();
var startingRow = await rowVersionTracker.Get(sqlConnection)
.ConfigureAwait(false);
async Task Callback(SqlTransaction transaction, IncomingMessage message, CancellationToken cancellation)
{
using (var reader = new StreamReader(message.Body))
{
var bodyText = await reader.ReadToEndAsync()
.ConfigureAwait(false);
Console.WriteLine($"Message received in error message:\r\n{bodyText}");
}
}
void ErrorCallback(Exception exception)
{
Environment.FailFast("Message processing loop failed", exception);
}
Task <SqlTransaction> TransactionBuilder(CancellationToken cancellation)
{
return(ConnectionHelpers.BeginTransaction(connectionString, cancellation));
}
Task PersistRowVersion(SqlTransaction transaction, long rowVersion, CancellationToken token)
{
return(rowVersionTracker.Save(sqlConnection, rowVersion, token));
}
var processingLoop = new MessageProcessingLoop(
table: "error",
delay: TimeSpan.FromSeconds(1),
transactionBuilder: TransactionBuilder,
callback: Callback,
errorCallback: ErrorCallback,
startingRow: startingRow,
persistRowVersion: PersistRowVersion);
processingLoop.Start();
Console.ReadKey();
await processingLoop.Stop()
.ConfigureAwait(false);
#endregion
}
// 7. Truy vấn lịch sử giao dịch
public List <SHBTransaction> TransactionHistory()
{
List <SHBTransaction> list = null;
SHBTransaction shbTransaction;
Account account = _guestModel.GetActiveAccountByUserName(Program.currentLogin.Username);
if (account == null)
{
Console.WriteLine("Không tìm thấy tài khoản hoặc tài khoản đã bị khóa!");
return(null);
}
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
try
{
list = new List <SHBTransaction>();
var stringCmdGetTransaction =
$"SELECT * FROM `transactions` WHERE senderAccountNumber = '{account.AccountNumber}' OR receiverAccountNumber = '{account.AccountNumber}'";
var cmdGetTransaction = new MySqlCommand(stringCmdGetTransaction, cnn);
var readerGetTransaction = cmdGetTransaction.ExecuteReader();
while (readerGetTransaction.Read())
{
shbTransaction = new SHBTransaction()
{
TransactionCode = readerGetTransaction.GetString("transactionCode"),
SenderAccountNumber = readerGetTransaction.GetString("senderAccountNumber"),
ReceiverAccountNumber = readerGetTransaction.GetString("receiverAccountNumber"),
Type = (TransactionType)readerGetTransaction.GetInt32("type"),
Amount = readerGetTransaction.GetDouble("amount"),
Fee = readerGetTransaction.GetDouble("fee"),
Message = readerGetTransaction.GetString("message"),
CreateAt = readerGetTransaction.GetDateTime("createAt"),
UpdatedAt = readerGetTransaction.GetDateTime("updatedAt"),
Status = (TransactionStatus)readerGetTransaction.GetInt32("status")
};
list.Add(shbTransaction);
}
cnn.Close();
}
catch (Exception e)
{
Console.WriteLine(e);
cnn.Close();
}
return(list);
}
void InitSendSql()
{
string resultSql;
if (dedupe)
{
resultSql = string.Format(dedupSql, dedupeTable) + string.Format(sql, Table);
}
else
{
resultSql = string.Format(sql, Table);
}
sendSql = ConnectionHelpers.WrapInNoCount(resultSql);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
if (!Page.IsPostBack)
{
Empresa_Cargar();
Tipo_Cargar();
Pais_Cargar();
Titular_Cargar();
Estado_Cargar();
var idMarca = int.Parse((Request.QueryString["idMarca"]));
LoginWCF.LoginWCFClient objLoginWCF = new LoginWCF.LoginWCFClient();
objLoginWCF.AuditoriaMenu_Registrar(System.Web.HttpContext.Current.Request.Url.AbsolutePath, Environment.MachineName,
((Usuario_LoginResult)System.Web.HttpContext.Current.Session["Usuario"]).idUsuario);
if (idMarca == 0)
{
lblTitulo.Text = "Nueva Marca";
Page.Title = "Registrar Marca";
}
else
{
lblTitulo.Text = "Modificar Marca";
Page.Title = "Modificar Marca";
Marca_Cargar(idMarca);
}
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
public Constructor(string fullFilePath, Topology.Topology topology)
{
this.fullFilePath = fullFilePath ?? throw new NullReferenceException();
if (topology == null)
{
throw new NullReferenceException();
}
InitializeComponent();
connection = ConnectionHelpers.OpenConnection();
crudHelper = new CrudHelper(connection);
SetupSettings();
topologyBuilder = new TopologyBuilder(dgvField, topology);
}
protected void grdGestionStock_ItemCommand(object sender, GridCommandEventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
lblMensaje.Text = "";
try
{
if (e.CommandName == "Eliminar")
{
int ID = 0;
ID = int.Parse(e.CommandArgument.ToString());
ItemWCFClient objItemWCF = new ItemWCFClient();
int Operacion = 3;
int Kardex = JsonHelper.JsonDeserialize <int>(Request.QueryString["Kardex"]);
int ID_Almacen = JsonHelper.JsonDeserialize <int>(Request.QueryString["ID_Almacen"]);
float Cantidad = 0;
string Observacion = txtObservacion.Text;
objItemWCF.Item_Mantenimiento_GestionStock(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, ID, ID_Almacen, Kardex, Cantidad, Observacion, Operacion);
Item_Limpiar();
Item_GestionStock(0, ID_Almacen, Kardex, 0, "");
lblMensaje.Text = "Se eliminó el registro.";
lblMensaje.CssClass = "mensajeExito";
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
static async Task Main()
{
Console.Title = "Samples.SqlServer.Native.AuditConsumer";
Console.WriteLine("Press any key to exit");
await CreateAuditQueue().ConfigureAwait(false);
#region MessageConsumingLoop
async Task Callback(SqlTransaction transaction, IncomingMessage message, CancellationToken cancellation)
{
using (var reader = new StreamReader(message.Body))
{
var bodyText = await reader.ReadToEndAsync().ConfigureAwait(false);
Console.WriteLine($"Message received in audit queue:\r\n{bodyText}");
}
}
void ErrorCallback(Exception exception)
{
Environment.FailFast("Message consuming loop failed", exception);
}
Task <SqlTransaction> TransactionBuilder(CancellationToken cancellation)
{
return(ConnectionHelpers.BeginTransaction(SqlHelper.ConnectionString, cancellation));
}
var consumingLoop = new MessageConsumingLoop(
table: "audit",
delay: TimeSpan.FromSeconds(1),
transactionBuilder: TransactionBuilder,
callback: Callback,
errorCallback: ErrorCallback);
consumingLoop.Start();
Console.ReadKey();
await consumingLoop.Stop()
.ConfigureAwait(false);
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
if (!Page.IsPostBack)
{
dpFecRegistro.SelectedDate = DateTime.Now;
dpFecVencimiento.SelectedDate = DateTime.Now;
Moneda_CargarComboBox();
CentroCosto_Cargar();
UnidadGestion_Cargar();
UnidadProyecto_Cargar();
NaturalezaGasto_Cargar();
EgresosVarios_Cargar(int.Parse((Request.QueryString["idOperacion"])));
if ((Request.QueryString["idOperacion"]) == "0")
{
Page.Title = "Registrar planilla de gasto";
lblMensaje.Text = "Listo para registrar el gasto.";
}
else
{
Page.Title = "Modificar planilla de gasto";
lblMensaje.Text = "Listo para modificar el gasto " + (Request.QueryString["idOperacion"]);
}
lblMensaje.CssClass = "mensajeExito";
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
public bool Save(Account account)
{
try
{
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
var strCmdRegister = $"insert into accounts (accountNumber, balance, userName, passwordHash, phoneNumber, salt, role, fullName, email, status) values ('{account.AccountNumber}', {Convert.ToDouble(account.Balance)}, '{account.Username}', '{account.PasswordHash}', '{account.PhoneNumber}', '{account.Salt}', " +
$"{Convert.ToInt32(account.Role)}, '{account.FullName}', '{account.Email}', {Convert.ToInt32(account.Status)})";
var cmdRegister = new MySqlCommand(strCmdRegister, cnn);
cmdRegister.ExecuteNonQuery();
cnn.Close();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public string ValidateUsername(string username)
{
string newUserName = null;
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
var strGetUsername =
$"select * from accounts where userName = '******'";
var cmdGetUsername = new MySqlCommand(strGetUsername, cnn);
var usernameReader = cmdGetUsername.ExecuteReader();
if (usernameReader.Read())
{
Console.WriteLine("Username đã tồn tại, vui lòng nhập lại user của bạn: ");
newUserName = Console.ReadLine();
}
cnn.Close();
return(newUserName);
}
public string ValidateAccountNumber(string accountNumber)
{
string newAccountNumber = null;
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
var strGetAccount =
$"select * from accounts where accountNumber = '{accountNumber}'";
var cmdGetAccountNumber = new MySqlCommand(strGetAccount, cnn);
var accountReader = cmdGetAccountNumber.ExecuteReader();
if (accountReader.Read())
{
var firstAccountNumber = "9704";
newAccountNumber = firstAccountNumber + _passwordHelper.GenerateAccountNumber();
}
cnn.Close();
return(newAccountNumber);
}
protected void btnAgregar_Click(object sender, EventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("Revisar su conexión a internet.");
}
try {
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "ShowInsertForm(0);", true);
}
catch (Exception ex) {
lblMensaje.Text = "ERROR: " + ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
// 2. Danh sách lịch sử giao dịch.
public List <SHBTransaction> ListTransaction()
{
List <SHBTransaction> listTran = null;
SHBTransaction transaction;
var cnn = ConnectionHelpers.GetConnection();
cnn.Open();
try
{
listTran = new List <SHBTransaction>();
var stringCmdGetAccount = $"select * from `transactions`";
var cmd = new MySqlCommand(stringCmdGetAccount, cnn);
var getListHistory = cmd.ExecuteReader();
while (getListHistory.Read())
{
transaction = new SHBTransaction()
{
TransactionCode = getListHistory.GetString("transactionCode"),
SenderAccountNumber = getListHistory.GetString("senderAccountNumber"),
ReceiverAccountNumber = getListHistory.GetString("receiverAccountNumber"),
Type = (TransactionType)getListHistory.GetInt32("type"),
Amount = getListHistory.GetDouble("amount"),
Fee = getListHistory.GetDouble("fee"),
Message = getListHistory.GetString("message"),
CreateAt = getListHistory.GetDateTime("createAt"),
UpdatedAt = getListHistory.GetDateTime("updatedAt"),
Status = (TransactionStatus)getListHistory.GetInt32("status")
};
listTran.Add(transaction);
}
cnn.Close();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(listTran);
}
protected void grdItem_ItemCommand(object sender, GridCommandEventArgs e)
{
if (Session["Usuario"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true);
}
if (!ConnectionHelpers.CheckForInternetConnection())
{
throw new ArgumentException("ERROR: Revisar su conexión a internet.");
}
try
{
if (e.CommandName == "Eliminar")
{
List <gsItem_BuscarResult> lstProductos = (List <gsItem_BuscarResult>)Session["lstProductos"];
lstProductos.Find(x => x.Item_ID.ToString() == e.CommandArgument.ToString() && x.Estado == 1).Estado = 0;
List <gsImpuesto_ListarPorItemResult> lstImpuestos;
lstImpuestos = ((List <gsImpuesto_ListarPorItemResult>)Session["lstImpuestos"]).FindAll(x => x.ID_Item == lstProductos.Find(p => p.Item_ID.ToString() == e.CommandArgument.ToString()).Item_ID);
foreach (gsImpuesto_ListarPorItemResult objImpuesto in lstImpuestos)
{
((List <gsImpuesto_ListarPorItemResult>)Session["lstImpuestos"]).Remove(objImpuesto);
}
//Calcular_Glosa();
//grdItem.DataSource = ((List<gsItem_BuscarResult>)Session["lstProductos"]).FindAll(x => x.Estado == 1).OrderBy(x => x.Item);
//grdItem.DataBind();
lblMensaje.Text = "Se eliminó el producto del GuiaVentasFlujo con código " + e.CommandArgument.ToString() + " del GuiaVentasFlujo.";
lblMensaje.CssClass = "mensajeExito";
}
}
catch (Exception ex)
{
lblMensaje.Text = "ERROR: " + ex.Message;
lblMensaje.CssClass = "mensajeError";
}
}
