public void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction, Location location) { SqlConnection connection = sqlConnection; SqlTransaction transaction = sqlTransaction; if (connection == null) { connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL")); } bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction); try { transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator); new LocationDAL().LocationManageAuto(connection, transaction, location); CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator); } catch (Exception ex) { CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator); throw new Exception("Exception in Save", ex); } finally { CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator); } }
protected void saveButton_Click(object sender, EventArgs e) { if (validate()) { if (hidCode.Value.Length == 0) { errorControl.AddErrorText("Please select a location before saving"); errorControl.Visible = true; return; } Location location = new Location(); location.LocationName = hidCode.Value; location.Latitude = (latitudeTextBox.Text.Trim() == String.Empty) ? null : latitudeTextBox.Text.Trim(); location.Longitude = (longitudeTextBox.Text.Trim() == String.Empty) ? null : longitudeTextBox.Text.Trim(); if (location.Latitude != null || longitudeTextBox != null) { location.NextAttemptDate = null; } else { location.NextAttemptDate = (nextAttemptLiteral.Text == String.Empty ? location.NextAttemptDate : Convert.ToDateTime(nextAttemptLiteral.Text)); } location.IncludeInUI = includeInUICheckbox.Checked; location.LastModifiedDate = DateTime.Now; location.IsNew = false; BHLProvider bp = new BHLProvider(); bp.SaveLocation(location); } else { return; } Response.Redirect("/Admin/LocationEdit.aspx"); }
/// <summary> /// Update values in Location. Returns an object of type Location. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type Location.</param> /// <returns>Object of type Location.</returns> public Location LocationUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, Location value) { return LocationUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.LocationName, value.Latitude, value.Longitude, value.NextAttemptDate, value.IncludeInUI); }
/// <summary> /// Update values in Location. Returns an object of type Location. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Location.</param> /// <returns>Object of type Location.</returns> public Location LocationUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Location value) { return LocationUpdateAuto(sqlConnection, sqlTransaction, "BHL", value ); }
/// <summary> /// Manage Location object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in Location. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type Location.</param> /// <returns>Object of type CustomDataAccessStatus<Location>.</returns> public CustomDataAccessStatus<Location> LocationManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, Location value) { if (value.IsNew && !value.IsDeleted) { Location returnValue = LocationInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.LocationName, value.Latitude, value.Longitude, value.NextAttemptDate, value.IncludeInUI); return new CustomDataAccessStatus<Location>( CustomDataAccessContext.Insert, true, returnValue); } else if (!value.IsNew && value.IsDeleted) { if (LocationDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName, value.LocationName)) { return new CustomDataAccessStatus<Location>( CustomDataAccessContext.Delete, true, value); } else { return new CustomDataAccessStatus<Location>( CustomDataAccessContext.Delete, false, value); } } else if (value.IsDirty && !value.IsDeleted) { Location returnValue = LocationUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.LocationName, value.Latitude, value.Longitude, value.NextAttemptDate, value.IncludeInUI); return new CustomDataAccessStatus<Location>( CustomDataAccessContext.Update, true, returnValue); } else { return new CustomDataAccessStatus<Location>( CustomDataAccessContext.NA, false, value); } }
/// <summary> /// Manage Location object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in Location. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type Location.</param> /// <returns>Object of type CustomDataAccessStatus<Location>.</returns> public CustomDataAccessStatus<Location> LocationManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, Location value) { return LocationManageAuto( sqlConnection, sqlTransaction, "BHL", value ); }
public void SaveLocation(Location location) { GetLocationDalInstance().Save(null, null, location); }
private void fillLocations() { BHLProvider bp = new BHLProvider(); CustomGenericList<Location> locations = bp.LocationSelectAll(); Location emptyLocation = new Location(); emptyLocation.LocationName = String.Empty; emptyLocation.Latitude = String.Empty; emptyLocation.Longitude = String.Empty; emptyLocation.NextAttemptDate = DateTime.Now; emptyLocation.IncludeInUI = true; locations.Insert(0, emptyLocation); ddlLocations.DataSource = locations; ddlLocations.DataTextField = "LocationName"; ddlLocations.DataValueField = "LocationName"; ddlLocations.DataBind(); }