public static bool AddShippingVendor(ShippingVendor shippingVendor, SqlConnection myConnection)
{
myConnection = myConnection ?? GetInventoryDbConnection();
try
{
var mySqlCommand = new SqlCommand("proc_InsertIntoShippingVendors", myConnection)
{
CommandType = CommandType.StoredProcedure
};
mySqlCommand.Parameters.AddWithValue("@name", shippingVendor.Name);
mySqlCommand.Parameters.AddWithValue("@address", shippingVendor.Address);
mySqlCommand.Parameters.AddWithValue("@city", shippingVendor.City);
mySqlCommand.Parameters.AddWithValue("@state", shippingVendor.State);
mySqlCommand.Parameters.AddWithValue("@country", shippingVendor.Country);
mySqlCommand.Parameters.AddWithValue("@zip", shippingVendor.Zip);
mySqlCommand.Parameters.AddWithValue("@phone", shippingVendor.Phone);
mySqlCommand.Parameters.AddWithValue("@contact", shippingVendor.Contact);
mySqlCommand.Parameters.AddWithValue("@contactEmail", shippingVendor.ContactEmail);
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 FrmUpdateShippingVendor(ShippingVendor vendor, AccessToken _myAccessToken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(_myAccessToken, this);
_myShippingVendorManager = new ShippingVendorManager();
_originalVendor = vendor;
this.Text = "Shipping Vendor ID: " + vendor.Id;
PopulateCountryCombo();
PopulateStateCombo();
txtAddress.Text = vendor.Address;
txtCity.Text = vendor.City;
txtContact.Text = vendor.Contact;
comboCountry.SelectedItem = vendor.Country;
txtEmail.Text = vendor.ContactEmail;
txtName.Text = vendor.Name;
txtPhone.Text = vendor.Phone;
txtZip.Text = vendor.Zip;
comboState.SelectedItem = vendor.State;
}
public static Boolean DeactivateVendor(ShippingVendor vendor, SqlConnection connection)
{
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_DeactivateShippingVendor", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@ShippingVendorId", vendor.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 btnAdd_Click(object sender, EventArgs e)
{
bool validShippingVendor = true;
string errorMessage = "Please correct the following errors:\n";
ShippingVendor newVendor;
if (txtEmail.TextLength > 50)
{
validShippingVendor = false;
errorMessage += "\nThe contact email must be less than 50 characters.";
txtEmail.Focus();
}
if (Validation.IsNullOrEmpty(txtContact.Text) || Validation.IsBlank(txtContact.Text))
{
validShippingVendor = false;
errorMessage += "\nYou must enter a primary contact.";
txtContact.Focus();
}
if (Validation.IsNullOrEmpty(txtPhone.Text) || Validation.IsBlank(txtPhone.Text))
{
validShippingVendor = false;
errorMessage += "\nYou must enter a phone.";
txtPhone.Focus();
}
if (Validation.IsNullOrEmpty(txtZip.Text) || Validation.IsBlank(txtZip.Text))
{
validShippingVendor = false;
errorMessage += "\nYou must enter a zip code.";
txtZip.Focus();
}
else if (!Validation.ValidateZip(txtZip.Text, comboState.SelectedItem.ToString()))
{
validShippingVendor = false;
errorMessage += "\nZip code " + txtZip.Text + " is not a valid zip code for the state of " + comboState.SelectedItem.ToString() + ".";
txtZip.Focus();
}
if (Validation.IsNullOrEmpty(txtCity.Text) || Validation.IsBlank(txtCity.Text))
{
validShippingVendor = false;
errorMessage += "\nYou must enter a city.";
txtCity.Focus();
}
if (txtCity.TextLength > 25)
{
validShippingVendor = false;
errorMessage += "\nThe city must be less than 25 characters.";
txtCity.Focus();
}
if (Validation.IsNullOrEmpty(txtAddress.Text) || Validation.IsBlank(txtAddress.Text))
{
validShippingVendor = false;
errorMessage += "\nYou must enter an address.";
txtAddress.Focus();
}
if (txtAddress.TextLength > 50)
{
validShippingVendor = false;
errorMessage += "\nThe address must be less than 50 characters.";
txtAddress.Focus();
}
if (Validation.IsNullOrEmpty(txtName.Text) || Validation.IsBlank(txtName.Text))
{
validShippingVendor = false;
errorMessage += "\nYou must enter a vendor name";
txtName.Focus();
}
if (txtName.TextLength > 50)
{
validShippingVendor = false;
errorMessage += "\nThe vendor name must be less than 50 characters.";
txtName.Focus();
}
if(validShippingVendor)
{
newVendor = new ShippingVendor();
newVendor.Name = txtName.Text;
newVendor.Address = txtAddress.Text;
newVendor.City = txtCity.Text;
newVendor.Country = comboCountry.SelectedItem.ToString();
newVendor.Contact = txtContact.Text;
newVendor.ContactEmail = txtEmail.Text;
newVendor.Phone = txtPhone.Text;
newVendor.Zip = txtZip.Text;
//newVendor.State = (String)comboState.SelectedItem;
newVendor.State = comboState.SelectedItem.ToString();
if (_myShippingVendorManager.Insert(newVendor))
{
this.DialogResult = DialogResult.OK;
MessageBox.Show("The vendor was created and added.");
ClearFields();
}
else
{
MessageBox.Show("The vendor was not created.");
}
}
else
{
MessageBox.Show(errorMessage);
}
}
public bool Insert(ShippingVendor vendor)
{
//Need to do error checking... Try/Catch.
return ShippingVendorDAL.AddShippingVendor(vendor, _connection);
}
public Boolean DeleteVendor(ShippingVendor shippingVendor)
{
if (shippingVendor == null) throw new ArgumentException("The shipping vendor was null, therefore it could not be deleted.");
return ShippingVendorDAL.DeleteVendor(shippingVendor, _connection);
}
public Boolean DeactivateVendor(ShippingVendor shippingVendor)
{
if (shippingVendor == null) throw new ArgumentException("The shipping vendor was null, therefore it cannot be set to inactive.");
return ShippingVendorDAL.DeactivateVendor(shippingVendor, _connection);
}
public bool Update(ShippingVendor vendor, ShippingVendor originalVendor)
{
//Need to do error checking... Try/Catch.
return ShippingVendorDAL.UpdateShippingVendor(vendor, originalVendor, _connection);
}
public static List<ShippingVendor> GetVendorsByActive(Boolean activeState, SqlConnection myConnection)
{
var shippingVendorList = new List<ShippingVendor>();
myConnection = myConnection ?? GetInventoryDbConnection();
try
{
var mySqlCommand = new SqlCommand("proc_GetShippingVendorsByActive", myConnection)
{
CommandType = CommandType.StoredProcedure
};
mySqlCommand.Parameters.AddWithValue("@Active", activeState ? 1 : 0);
myConnection.Open();
var mySqlReader = mySqlCommand.ExecuteReader();
if (mySqlReader.HasRows)
{
while (mySqlReader.Read())
{
var shippingVendor = new ShippingVendor(mySqlReader.GetInt32(0))
{
Name = mySqlReader.GetString(1),
Address = mySqlReader.GetString(2),
City = mySqlReader.GetString(3),
State = mySqlReader.GetString(4),
Country = mySqlReader.GetString(5),
Zip = mySqlReader.GetString(6),
Phone = mySqlReader.GetString(7),
Contact = mySqlReader.GetString(8),
ContactEmail = mySqlReader.GetString(9),
Active = mySqlReader.GetBoolean(10)
};
//Add item to list
shippingVendorList.Add(shippingVendor);
}
}
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 shippingVendorList;
}
