public int CreateCliente(DAOClients Cliente) { int result = 0; try { using (NpgsqlConnection connection = new NpgsqlConnection()) { connection.ConnectionString = GetConnection(); connection.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = connection; cmd.CommandText = "Insert into clients (BusinessID,Email,Phone,DataAdded,StartDate,EndDate,State)" + "values(@BusinessID,@Email,@Phone,@DataAdded,@StartDate,@EndDate,@State)"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new NpgsqlParameter("@BusinessID", Cliente.BusinessID)); cmd.Parameters.Add(new NpgsqlParameter("@Email", Cliente.Email)); cmd.Parameters.Add(new NpgsqlParameter("@Phone", Cliente.Phone)); cmd.Parameters.Add(new NpgsqlParameter("@DataAdded", Cliente.DataAdded)); cmd.Parameters.Add(new NpgsqlParameter("@StartDate", Cliente.StartDate)); cmd.Parameters.Add(new NpgsqlParameter("@EndDate", Cliente.EndDate)); cmd.Parameters.Add(new NpgsqlParameter("@State", Cliente.State)); result = cmd.ExecuteNonQuery(); cmd.Dispose(); connection.Close(); } } catch (Exception ex) { Logger.LogWrite("CreateCliente", ex.Message + "---" + ex.StackTrace); } return(result); }
public async Task <bool> UpdateClient(DAOClients Client, string UpdateFieldName, string UpdateFieldValue) { IMongoDatabase db = CreateConectionMongo(); var col = db.GetCollection <DAOClients>("Clients"); var filter = Builders <DAOClients> .Filter.Eq("sharedkey", Client.SharedKey); var update = Builders <DAOClients> .Update.Set(UpdateFieldName, UpdateFieldValue); var result = await col.UpdateOneAsync(filter, update); return(result.ModifiedCount != 0); }
public bool ActualizarCliente(DAOClients Cliente) { int result = 0; try { using (NpgsqlConnection connection = new NpgsqlConnection()) { connection.ConnectionString = GetConnection(); connection.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = connection; cmd.CommandText = "update clients set BusinessID=@BusinessID, Email=@Email," + "Phone = @Phone, DataAdded = @DataAdded,StartDate = @StartDate, " + "EndDate = @EndDate,State = @State " + " where SharedKey = @SharedKey"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new NpgsqlParameter("@SharedKey", Cliente.SharedKey)); cmd.Parameters.Add(new NpgsqlParameter("@BusinessID", Cliente.BusinessID)); cmd.Parameters.Add(new NpgsqlParameter("@Email", Cliente.Email)); cmd.Parameters.Add(new NpgsqlParameter("@Phone", Cliente.Phone)); cmd.Parameters.Add(new NpgsqlParameter("@DataAdded", Cliente.DataAdded)); cmd.Parameters.Add(new NpgsqlParameter("@StartDate", Cliente.StartDate)); cmd.Parameters.Add(new NpgsqlParameter("@EndDate", Cliente.EndDate)); cmd.Parameters.Add(new NpgsqlParameter("@State", Cliente.State)); result = cmd.ExecuteNonQuery(); cmd.Dispose(); connection.Close(); } } catch (Exception ex) { Logger.LogWrite("ActualizarCliente", ex.Message + "---" + ex.StackTrace); } if (result == 1) { return(true); } else { return(false); } }
private List <DAOClients> MappingInDao(DataTable table) { List <DAOClients> Listcliente = new List <DAOClients>(); foreach (DataRow item in table.Rows) { DAOClients nuevoCliente = new DAOClients() { SharedKey = Convert.ToInt32(item["SharedKey"].ToString()), BusinessID = item["BusinessID"].ToString(), Email = item["Email"].ToString(), Phone = item["Phone"].ToString(), DataAdded = Convert.ToDateTime(item["DataAdded"].ToString()), StartDate = Convert.ToDateTime(item["StartDate"].ToString()), EndDate = Convert.ToDateTime(item["EndDate"].ToString()), State = item["State"].ToString().ToLower().Trim() == "Activo" ? true : false }; Listcliente.Add(nuevoCliente); } return(Listcliente); }
public async void CreateClient(DAOClients Client) { IMongoDatabase db = CreateConectionMongo(); await db.GetCollection <DAOClients>("Clients").InsertOneAsync(Client); }