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