public void AddCustomer(int tenantId, Customer customer) { var sql = BuildInsertCustomerSql(); ExecuteNonQuery( sql, CommandType.Text, command => { AddTenantParameters(command, tenantId); AddCommonParameters(customer, command); }); }
private Customer CreateCustomerFromData(DbDataReader reader) { var customer = new Customer(); customer.Id = (int) reader["Id"]; customer.Username = DataHelper.GetStringValueOrEmptyString(reader["Username"]); customer.Name = DataHelper.GetStringValueOrEmptyString(reader["Name"]); customer.IdNumber = DataHelper.GetStringValueOrEmptyString(reader["IdNumber"]); customer.UniqueId = (Guid) reader["UniqueId"]; customer.Phone = DataHelper.GetStringValueOrEmptyString(reader["Phone"]); customer.Email = DataHelper.GetStringValueOrEmptyString(reader["Email"]); customer.Address = DataHelper.GetStringValueOrEmptyString(reader["Address"]); customer.City = DataHelper.GetStringValueOrEmptyString(reader["City"]); customer.LastModified = DataHelper.DateAsUtc(DataHelper.GetSafeValue<DateTime?>(reader["LastModified"])); customer.CreatedAt = DataHelper.DateAsUtc(DataHelper.GetSafeValue<DateTime>(reader["CreatedAt"])); return customer; }
private void AddCustomer_Click(object sender, EventArgs e) { var customers = CustomersGrid.DataSource as Customer[]; var index = 1; if (customers != null) { index = customers.Length + 1; } var customer = new Customer { Username ="******", Name = "לקוח חדש #" + index, Address = "כתובת ללקוח " + index, City = "עיר ל" + index, Phone = "052525360", Email = "*****@*****.**", IdNumber = "IdNum#" + index, UniqueId = Guid.NewGuid() }; var ds = new CustomersDataService(); ds.AddCustomer(GetTenantId(), customer); ReloadCustomers(); }
public void Post(Customer[] customers) { var dataService = ServiceProvider.Get<ICustomersDataService>(); //customers.ForEach(customer => { dataService.SaveCustomer(1, customer); }); }
public void UpdateCustomer(int tenantId, Customer customer) { var sql = BuildUpdateCustomerSql(); ExecuteNonQuery( sql, CommandType.Text, command => { AddTenantParameters(command, tenantId); AddCommonParameters(customer, command); DataHelper.AddParameterWithValue(command, "@Id", DbType.Int32, customer.Id); }); }
private static void AddCommonParameters(Customer customer, DbCommand command) { DataHelper.AddParameterWithValue(command, "@UserName", DbType.String, customer.Username); DataHelper.AddParameterWithValue(command, "@Name", DbType.String, customer.Name); DataHelper.AddParameterWithValue(command, "@IdNumber", DbType.String, customer.IdNumber); DataHelper.AddParameterWithValue(command, "@Phone", DbType.String, customer.Phone); DataHelper.AddParameterWithValue(command, "@Email", DbType.String, customer.Email); DataHelper.AddParameterWithValue(command, "@Address", DbType.String, customer.Address); DataHelper.AddParameterWithValue(command, "@City", DbType.String, customer.City); DataHelper.AddParameterWithValue(command, "@UniqueId", DbType.Guid, customer.UniqueId); DataHelper.AddParameterWithValue(command, "@CreatedAt", DbType.DateTime, DateTime.UtcNow); }