public ActionResult GetSupplierInfo(int supplierID)
{
SupplierResult result = new SupplierResult()
{
Code = SystemConst.MSG_ERR_UNKNOWN,
Message = String.Empty
};
try
{
SupplierPara supplierInfo = new SupplierPara();
using (var db = new TravelEntities())
{
supplierInfo.travelProjects = (from travelProject in db.T_TravelProjects
join projectType in db.T_TravelProjectTypes on travelProject.ProjectTypeID equals projectType.ProjectTypeID into temp
from i in temp.DefaultIfEmpty()
where travelProject.SupplierID == supplierID
select new TravelProjectDto
{
ProjectID = travelProject.ProjectID,
ProjectName = travelProject.ProjectName,
AdultFee = travelProject.AdultFee,
ChildFee = travelProject.ChildFee,
AgentAdultFee = travelProject.AgentAdultFee,
AgentChildFee = travelProject.AgentChildFee,
ProjectTypeID = travelProject.ProjectTypeID,
ProjectTypeName = i.ProjectTypeName,
Remark = travelProject.Remark,
Description = travelProject.Description,
CoverPic = travelProject.CoverPic,
SupplierID = travelProject.SupplierID
}).ToList();
supplierInfo.hotels = (from hotel in db.T_LiveProjects.Where(a => a.SupplierID == supplierID)
select new HotelDto
{
HouseID = hotel.HouseID,
HouseName = hotel.HouseName,
Fee = hotel.Fee,
SupplierID = hotel.SupplierID,
AgentFee = hotel.AgentFee,
CoverPic = hotel.CoverPic,
Description = hotel.Description,
Remark = hotel.Remark,
Pics = hotel.Pics,
Location = hotel.Location,
RoomCount = hotel.RoomCount
}).ToList();
}
result.Code = SystemConst.MSG_SUCCESS;
result.Data = supplierInfo;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Content(AppUtils.JsonSerializer(result)));
}
private void dgSuppliers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
int editColumnIndex = -1;
int selectColumnIndex = -1;
if (_IsSelectDialog)
{
editColumnIndex = senderGrid.Columns.Count - 1;
selectColumnIndex = senderGrid.Columns.Count - 2;
}
else
{
editColumnIndex = senderGrid.Columns.Count - 1;
}
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
_SelectedSupplier = senderGrid.Rows[e.RowIndex].DataBoundItem as SupplierResult;
if (_SelectedSupplier != null)
{
if (e.ColumnIndex == selectColumnIndex)
{
var supplier = _DataContext.SupplierSet.Single(a => a.id == _SelectedSupplier.SupplierId);
SupplierSelected(supplier);
}
else if (e.ColumnIndex == editColumnIndex)
{
var frmSupplierDetail = new frmSupplierDetail(_DataContext, _SelectedSupplier.SupplierId, _buildingId);
var dialogResult = frmSupplierDetail.ShowDialog();
if (dialogResult == DialogResult.OK)
{
btnSearch.PerformClick();
}
}
}
}
}
/// <summary>
/// Kelsey Blount
/// Created 2015/04/07
/// submits data to bll for supplier application
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmitApplication_Click(object sender, EventArgs e)
{
clearBorderColors();
int errorCount = 0;
lblFinish.Text = "";
//Validate
if (validateText(txtCompanyName, "Please enter a company name"))
{
errorCount++;
}
if (validateName(txtFirstName, "Please enter your first name"))
{
errorCount++;
}
if (validateName(txtLastName, "Please enter your second name"))
{
errorCount++;
}
if (validateText(txtAddress, "Please enter your address"))
{
errorCount++;
}
//check zips
bool goodZip = false;
foreach (var zip in zips)
{
if (txtZip.Text == zip.Zip)
{
goodZip = true;
}
}
if (!goodZip)
{
txtZip.ToolTip = "Please enter a valid Zip Code";
txtZip.BorderColor = Color.Red;
errorCount++;
}
if (validateText(txtDescription, "Please enter your description"))
{
errorCount++;
}
if (!txtEmail.Text.ValidateEmail())
{
txtEmail.ToolTip = "Please enter a valid e-mail";
txtEmail.BorderColor = Color.Red;
errorCount++;
}
else
{
txtEmail.ToolTip = "";
txtEmail.BorderColor = Color.Empty;
}
if (!txtPhoneNumber.Text.ValidatePhone())
{
txtPhoneNumber.ToolTip = "Please enter a valid phone number";
txtPhoneNumber.BorderColor = Color.Red;
}
else
{
txtPhoneNumber.ToolTip = "";
txtPhoneNumber.BorderColor = Color.Empty;
}
if (errorCount > 0)
{
showError("You have " + errorCount + " errors that need to be fixed.");
return;
}
else
{
//reset border colors
clearBorderColors();
try
{
//create new Suppler Application
SupplierApplication application = new SupplierApplication(txtCompanyName.Text, txtDescription.Text, txtFirstName.Text, txtLastName.Text, txtAddress.Text, txtAddress2.Text, txtZip.Text, txtPhoneNumber.Text, txtEmail.Text, DateTime.Now);
SupplierResult result = ApplicationManager.AddASupplierApplication(application);
if (result == SupplierResult.Success)
{
showError("Thank you for your Application!<br /> We will be in contact once we have reviewed the information. ");
clearForm();
}
}
catch (Exception ex)
{
showError(ex.Message);
}
}
}
/// <summary>
/// Miguel Santana
/// Created: 2015/04/04
/// Takes user input to send to business logic layer
/// </summary>
/// <remarks>
/// Pat Banks
/// Added rejected/approved/pending combo box
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btnSubmit_Click(object sender, RoutedEventArgs e)
{
//validates data from form
if (!Validate())
{
return;
}
try
{
if (CboAppStatus.SelectedValue.ToString().Equals(ApplicationStatus.Approved.ToString()))
{
bool validUserName = MyLoginManager.CheckSupplierUserName(TxtUserName.Text);
if (validUserName)
{
//get data from form
GetFormData();
decimal supplyCost = (decimal)(NumSupplyCost.Value);
SupplierResult result = MySupplierManager.ApproveSupplierApplication(CurrentSupplierApplication, UpdatedSupplierApplication, TxtUserName.Text, supplyCost);
if (result == SupplierResult.Success)
{
await this.ShowMessageDialog("Supplier application approved: Supplier added.");
DialogResult = true;
Close();
}
else
{
throw new WanderingTurtleException(this, "DB Error");
}
}
else
{
TxtUserName.Text = "";
throw new WanderingTurtleException(this, "UserName already used. Please choose another one.");
}
}
else if (CboAppStatus.SelectedValue.ToString().Equals(ApplicationStatus.Rejected.ToString()) || CboAppStatus.SelectedValue.ToString().Equals(ApplicationStatus.Pending.ToString()))
{
//get data from form
GetFormData();
SupplierResult result = MySupplierManager.EditSupplierApplication(CurrentSupplierApplication, UpdatedSupplierApplication);
if (result == SupplierResult.Success)
{
await this.ShowMessageDialog("Supplier application updated.");
DialogResult = true;
Close();
}
else
{
throw new WanderingTurtleException(this, "DB Error");
}
}
else
{
throw new WanderingTurtleException(this, "DB Error.");
}
}
catch (SqlException ex)
{
// ShowErrorMessage("UserName already used. Please choose another one.");
throw new WanderingTurtleException(this, "UserName already used. Please choose another one.", ex);
}
catch (Exception ex)
{
throw new WanderingTurtleException(this, ex);
}
}
