public FrmUpdateShippingTerm(ShippingTerm term, AccessToken _myAccessToken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(_myAccessToken, this);
_myShippingTermManager = new ShippingTermManager();
_myShippingVendorManager = new ShippingVendorManager();
vendors = _myShippingVendorManager.GetVendors();
_originalTerm = term;
PopulateVendorCombo();
txtDesc.Text = term.Description;
this.Text = "Shipping Term: " + term.Id;
}
public static Boolean DeactivateTerm(ShippingTerm term, SqlConnection connection)
{
//?? Null-coalescing operator.
//If the connection is null a new connection will be returned.
SqlConnection conn = connection ?? GetInventoryDbConnection();
try
{
//Establishes the connection.
conn.Open();
//Creates the command object, passing the SP and connection object.
SqlCommand sqlCmd = new SqlCommand("proc_DeactivateTerm", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@ShippingTermId", term.Id);
//If the procedure returns 1 set to true, if 0 remain false.
if (sqlCmd.ExecuteNonQuery() == 1)
{
return true;
}
}
catch (DataException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex);
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("SqlException"), ex);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("Exception"), ex);
}
finally
{
conn.Close();
}
return false;
}
private void btnEdit_Click_1(object sender, EventArgs e)
{
ShippingTerm term;
bool validShippingTerm = true;
string errorMessage = "Please correct the following errors:\n";
if(Validation.IsNullOrEmpty(txtDesc.Text) || Validation.IsBlank(txtDesc.Text))
{
validShippingTerm = false;
errorMessage += "You must enter a description.";
txtDesc.Focus();
}
if (txtDesc.TextLength > 250)
{
validShippingTerm = false;
errorMessage += "The description must be 250 characters or less.";
txtDesc.Focus();
}
if (validShippingTerm)
{
term = new ShippingTerm()
{
Description = txtDesc.Text,
ShippingVendorId = ((KeyValuePair<int, string>)comboVendors.SelectedItem).Key,
Id = _originalTerm.Id
};
if (_myShippingTermManager.Update(term, _originalTerm))
{
this.DialogResult = DialogResult.OK;
MessageBox.Show("Shipping term " + _originalTerm.Id + " was updated.");
}
else
{
MessageBox.Show("The shipping term was not updated.");
}
}
else
{
MessageBox.Show(errorMessage);
}
}
public static bool AddShippingTerm(ShippingTerm shippingTerm, SqlConnection myConnection)
{
myConnection = myConnection ?? GetInventoryDbConnection();
try
{
var mySqlCommand = new SqlCommand("proc_InsertIntoShippingTerm", myConnection)
{
CommandType = CommandType.StoredProcedure
};
mySqlCommand.Parameters.AddWithValue("@shippingVendorID",shippingTerm.ShippingVendorId);
mySqlCommand.Parameters.AddWithValue("@description", shippingTerm.Description);
myConnection.Open();
if (mySqlCommand.ExecuteNonQuery() == 1)
{
return true;
}
}
catch (DataException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex);
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("SqlException"), ex);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("Exception"), ex);
}
finally
{
myConnection.Close();
}
return false;
}
public static ShippingTerm GetShippingTermsById(int id, SqlConnection myConnection)
{
var shippingTerm = new ShippingTerm();
myConnection = myConnection ?? GetInventoryDbConnection();
try
{
var mySqlCommand = new SqlCommand("proc_GetShippingTermsByID", myConnection)
{
CommandType = CommandType.StoredProcedure
};
mySqlCommand.Parameters.AddWithValue("@shippingTermID", id);
myConnection.Open();
var mySqlReader = mySqlCommand.ExecuteReader();
if (mySqlReader.HasRows)
{
while (mySqlReader.Read())
{
shippingTerm = new ShippingTerm(mySqlReader.GetInt32(0))
{
ShippingVendorId = mySqlReader.GetInt32(1),
Description = mySqlReader.GetString(2),
ShippingVendorName = mySqlReader.GetString(3),
Active = mySqlReader.GetBoolean(10)
};
}
}
mySqlReader.Close();
}
catch (DataException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex);
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("SqlException"), ex);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("Exception"), ex);
}
finally
{
myConnection.Close();
}
return shippingTerm;
}
public static List<ShippingTerm> GetAllShippingTerms(SqlConnection myConnection)
{
var shippingTermList = new List<ShippingTerm>();
myConnection = myConnection ?? GetInventoryDbConnection();
try
{
var mySqlCommand = new SqlCommand("proc_GetAllShippingTerms", myConnection)
{
CommandType = CommandType.StoredProcedure
};
myConnection.Open();
var mySqlReader = mySqlCommand.ExecuteReader();
if (mySqlReader.HasRows)
{
while (mySqlReader.Read())
{
var shippingTerm = new ShippingTerm(mySqlReader.GetInt32(0))
{
ShippingVendorId = mySqlReader.GetInt32(1),
Description = mySqlReader.GetString(2),
ShippingVendorName = mySqlReader.GetString(3),
Active = mySqlReader.GetBoolean(4)
};
//Add item to list
shippingTermList.Add(shippingTerm);
}
}
mySqlReader.Close();
}
catch (DataException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex);
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("SqlException"), ex);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new ApplicationException(Messeges.GetMessage("Exception"), ex);
}
finally
{
myConnection.Close();
}
return shippingTermList;
}
public bool Insert(ShippingTerm term)
{
//Need to do error checking.
return ShippingTermDAL.AddShippingTerm(term, _connection);
}
public Boolean DeleteTerm(ShippingTerm shippingTerm)
{
if (shippingTerm == null) throw new ArgumentException("The shipping term was null, therefore it cannot be deleted.");
return ShippingTermDAL.DeleteTerm(shippingTerm, _connection);
}
public bool Update(ShippingTerm term, ShippingTerm originalTerm)
{
//Need to do error checking.
return ShippingTermDAL.UpdateShippingTerms(term, originalTerm, _connection);
}
public Boolean ReactivateTerm(ShippingTerm shippingTerm)
{
if (shippingTerm == null) throw new ArgumentException("The shipping term was null, therefore it cannot be set to active.");
return ShippingTermDAL.ReactivateTerm(shippingTerm, _connection);
}