/* TODO ERROR: Skipped EndRegionDirectiveTrivia */
/* TODO ERROR: Skipped RegionDirectiveTrivia */
public void PopulateInventoryInfo(VW_BagInventory InvInfo)
{
selectedInventory = InvInfo;
var mdlFtp = new MdlFtp();
lblCustomer.Text = InvInfo.CustomerName;
lblQuantity.Text = InvInfo.TotalQuantity.ToString();
lblRemaining.Text = InvInfo.Remaining.ToString();
lblStorageDate.Text = InvInfo.StorageDate.ToString();
dgvBagLocations.DataSource = BagInventoryService.GetBagLocationsByInvId((int)InvInfo.BagInventoryId);
lblBagSize.Text = InvInfo.BagSizeName;
lblBagWeight.Text = InvInfo.BagWeightName + " " + InvInfo.BagUnit;
lblBagColor.Text = InvInfo.BagColor;
lblColorType.Text = InvInfo.ColorType;
lblBagDescription.Text = InvInfo.BagDescription;
lblLogoDescription.Text = InvInfo.LogoDescription;
lblLogoYear.Text = InvInfo.BagYear;
try
{
pbBagImage.Image = mdlFtp.GetFTPImage(InvInfo.ImagePath);
if (!Information.IsNothing(pbBagImage.Image))
{
// pbBagImage.Image.RotateFlip(RotateFlipType.Rotate90FlipNone)
}
}
catch
{
if (!InvInfo.ImagePath.Equals("N/A"))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error loading bag image", "The bag image is not accessible or does not exist on the ftp server.", My.MyProject.Forms.FrmParentScreen);
}
}
}
public static void fillTextBoxes()
{
int selectedRow = employeDataGridView.CurrentRow.Index;
employeeID = Conversions.ToInteger(employeDataGridView.Rows[selectedRow].Cells[6].Value);
foreach (DataRow employee in (IEnumerable)db.getEmployee(employeeID).Rows)
{
userID = Conversions.ToInteger(employee["ID"]);
My.MyProject.Forms.FrmAddNewEmployee.firstNameTextBox.Text = Conversions.ToString(employee["First_Name"]);
My.MyProject.Forms.FrmAddNewEmployee.lastNameTextBox.Text = Conversions.ToString(employee["Last_Name"]);
My.MyProject.Forms.FrmAddNewEmployee.aliasTextBox.Text = Conversions.ToString(employee["Alias"]);
My.MyProject.Forms.FrmAddNewEmployee.typeComboBox.Text = Conversions.ToString(employee["Type"]);
My.MyProject.Forms.FrmAddNewEmployee.yardComboBox.Text = Conversions.ToString(employee["Yard"]);
My.MyProject.Forms.FrmAddNewEmployee.adressTextBox.Text = Conversions.ToString(employee["Address"]);
My.MyProject.Forms.FrmAddNewEmployee.phoneNumberTextBox.Text = Conversions.ToString(employee["Phone_Number"]);
My.MyProject.Forms.FrmAddNewEmployee.startDateDateTimePicker.Value = Conversions.ToDate(employee["Start_Date"]);
My.MyProject.Forms.FrmAddNewEmployee.emergencyFirstNameTextBox.Text = Conversions.ToString(employee["FirstName_Emerg_Contact"]);
My.MyProject.Forms.FrmAddNewEmployee.emergencyLastNameTextBox.Text = Conversions.ToString(employee["LastName_Emerg_Contact"]);
My.MyProject.Forms.FrmAddNewEmployee.emergencyPhoneNumberTextBox.Text = Conversions.ToString(employee["PhoneNumber_Emerg_Contact"]);
My.MyProject.Forms.FrmAddNewEmployee.relationshipTextBox.Text = Conversions.ToString(employee["Relationship_Emerg_Contact"]);
My.MyProject.Forms.FrmAddNewEmployee.birthdateDateTimePicker.Value = Conversions.ToDate(employee["Birth_Date"]);
My.MyProject.Forms.FrmAddNewEmployee.SINumbTextBox.Text = Conversions.ToString(employee["SIN_Number"]);
My.MyProject.Forms.FrmAddNewEmployee.genderComboBox.SelectedItem = employee["Gender"];
My.MyProject.Forms.FrmAddNewEmployee.jobDescriptionComboBox.SelectedItem = employee["Job_Description"];
My.MyProject.Forms.FrmAddNewEmployee.payMehodComboBox.SelectedItem = employee["Pay_Method"];
My.MyProject.Forms.FrmAddNewEmployee.supervisorTextBox.Text = Conversions.ToString(employee["Supervisor"]);
My.MyProject.Forms.FrmAddNewEmployee.emailTextBox.Text = Conversions.ToString(employee["Email"]);
if (!employee["Card_ID"].Equals("Not assigned"))
{
My.MyProject.Forms.FrmAddNewEmployee.cardAddignedLabel.BackColor = Color.Green;
My.MyProject.Forms.FrmAddNewEmployee.cardAddignedLabel.Text = "Assigned";
}
var ftpModule = new MdlFtp();
Bitmap ImageFromDB;
if (!Information.IsDBNull(employee["EmployeePicturePath"]) && !employee["EmployeePicturePath"].Equals(""))
{
ImageFromDB = ftpModule.GetFTPImage(Conversions.ToString(employee["EmployeePicturePath"]));
My.MyProject.Forms.FrmAddNewEmployee.employeePictureBox.BackgroundImage = ImageFromDB;
My.MyProject.Forms.FrmAddNewEmployee.SkillsCertificationPictureBox.BackgroundImage = ImageFromDB;
My.MyProject.Forms.FrmAddNewEmployee.remoteFtpPath = Conversions.ToString(employee["EmployeePicturePath"]);
My.MyProject.Forms.FrmAddNewEmployee.OldPictureRemotelPath = Conversions.ToString(employee["EmployeePicturePath"]);
}
else
{
My.MyProject.Forms.FrmAddNewEmployee.remoteFtpPath = "";
My.MyProject.Forms.FrmAddNewEmployee.OldPictureRemotelPath = "";
}
fillSkillsCheckBoxes();
}
// FrmEmployeeManagement.newEmployeeTabControl.TabPages.Remove(FrmAddNewEmployee.cardIDTabPage)
}
private void populateInfo()
{
int selectedItem = employeesListView.FocusedItem.Index;
foreach (DataRow employee in (IEnumerable)db.getEmployee(Conversions.ToInteger(employeesListView.Items[selectedItem].SubItems[1].Text)).Rows)
{
NameTextBox.Text = Conversions.ToString(Operators.AddObject(Operators.AddObject(employee["First_Name"], " "), employee["Last_Name"]));
nameLabel.Text = NameTextBox.Text;
PositionTextBox.Text = Conversions.ToString(employee["Job_Description"]);
positionLabel.Text = PositionTextBox.Text;
IDTextBox.Text = Conversions.ToString(employee["ID"]);
string zeros = "";
for (int i = IDTextBox.Text.Length; i <= 4; i++)
{
zeros += "0";
}
idLabel.Text = zeros + IDTextBox.Text;
barcodeLabel.Text = "*" + idLabel.Text + "*";
var ftpModule = new MdlFtp();
Bitmap ImageFromDB;
if (!Information.IsDBNull(employee["EmployeePicturePath"]) && !employee["EmployeePicturePath"].Equals(""))
{
ImageFromDB = ftpModule.GetFTPImage(Conversions.ToString(employee["EmployeePicturePath"]));
employeePictureBox.BackgroundImage = ImageFromDB;
}
else
{
employeePictureBox.BackgroundImage = null;
}
}
string[] names;
var namesModified = default(string);
nameLabel.Text = Strings.Trim(nameLabel.Text);
names = nameLabel.Text.Split(' ');
for (int i = 0, loopTo = names.Count() - 1; i <= loopTo; i++)
{
string name_ = names[i];
if (!name_.Equals(""))
{
name_ = name_.ToLower();
name_ = name_.Substring(0, 1).ToUpper() + name_.Substring(1, name_.Length - 1);
namesModified += name_.ToString() + " ";
}
}
nameLabel.Text = Strings.Trim(namesModified);
lowNameLabel.Text = nameLabel.Text;
lowPictureBox.BackgroundImage = employeePictureBox.BackgroundImage;
lowPositionLabe.Text = positionLabel.Text;
lowIdLabel.Text = idLabel.Text;
}
private void btnOkLogo_Click(object sender, EventArgs e)
{
if (dgvLogos.Rows.Count > 0)
{
selectedLogo = (BagLogo)dgvLogos.CurrentRow.DataBoundItem;
selectedLogoId = selectedLogo.BagLogoId;
lblBagLogo.Text = selectedLogo.LogoDescription;
var ftp = new MdlFtp();
var image = ftp.GetFTPImage(selectedLogo.ImagePath);
pbLogo.Image = image;
panelLogoList.Hide();
}
else
{
lblWarning.Text = "No logo selected. Please add a logo.";
}
}
public void LoadEditInfo(VW_Bag BagInfo)
{
FocusedBagInv = BagInfo;
// cboCustomer.SelectedValue = BagInfo.CustomerId
cboBagSize.SelectedValue = BagInfo.BagSizeId;
cboBagWeight.SelectedValue = BagInfo.BagWeightId;
cboBagColor.SelectedValue = BagInfo.ColorId;
cboColortype.SelectedItem = BagInfo.ColorType;
tbBagDescription.Text = BagInfo.BagDescription;
string path = "Operations/EmptyBags/BagPictures";
var ftp = new MdlFtp();
if (!BagInfo.ImagePath.Equals("N/A"))
{
selectedLogo = BagInventoryService.GetBagLogoById(BagInfo.BagLogoId);
var image = ftp.GetFTPImage(BagInfo.ImagePath);
pbLogo.Image = image;
}
}
/* TODO ERROR: Skipped EndRegionDirectiveTrivia */
/* TODO ERROR: Skipped RegionDirectiveTrivia */
public void LoadEditInfo(BagLogo BagInfo)
{
var ftp = new MdlFtp();
tbLogoDescription.Text = BagInfo.LogoDescription;
SelectedLogoInfo = BagInfo;
if (BagInfo.BagYear.Equals("N/A"))
{
cbNoBagYear.Checked = true;
nudBagYear.Value = 0m;
}
else
{
cbNoBagYear.Checked = false;
nudBagYear.Value = Conversions.ToDecimal(BagInfo.BagYear);
}
if (!BagInfo.ImagePath.Equals("N/A"))
{
pbBagLogo.Image = ftp.GetFTPImage(BagInfo.ImagePath);
}
}
private void loginButton_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(usernameTextBox.Text) | string.IsNullOrEmpty(passwordTextBox.Text))
{
warningLabel.Text = "Fields cannot be empty";
}
else
{
db.checkLogin(Strings.Trim(usernameTextBox.Text), Strings.Trim(passwordTextBox.Text));
if (db._userExists)
{
var employee = EmployeeService.GetById(db._ID);
db.getClearanceLevel();
_employeeName = (employee.First_Name + " " + employee.Last_Name).ToUpper();
payMethod = employee.Pay_Method;
warningLabel.Text = "";
_userID = employee.ID;
Hide();
MdlOptionsManagement.checkProbationReminders();
MdlOptionsManagement.checkHolidayReminders();
MdlOptionsManagement.checkBlockedContainers();
My.MyProject.Forms.FrmParentScreen.Show();
My.MyProject.Forms.FrmParentScreen.employeeNameLabel.Text = _employeeName;
VesselVoyageService.UpdateIsActiveDateLRDLessThanYesterday();
// Dim newMstream As New System.IO.MemoryStream(CType(db.getEmployeePicture(_userID), Byte()))
// 'Create a new image from the bytes from the memory
// Dim ImageFromDB As New Bitmap(newMstream)
var ftpMdl = new MdlFtp();
var ImageFromDB = ftpMdl.GetFTPImage(employee.EmployeePicturePath);
My.MyProject.Forms.FrmParentScreen.profileShapedPictureBox1.Image = ImageFromDB;
}
else
{
warningLabel.Text = "Wrong username or password";
}
}
}
private bool SaveBagImageLogo()
{
// Dim ftpPath As String = "Emilio.2020", path As String = "Operations/EmptyBags/BagPictures"
string imageName = tbLogoDescription.Text.Replace(" ", "") + "-" + DateAndTime.Now.ToString("ddMMMyyyyHHmmss") + SelectedLogo.Extension;
var ftpMdl = new MdlFtp();
bool imageUploaded;
// Dim name = pbBagLogo.Image.Tag
if (isNewLogo == false && !SelectedLogoInfo.ImagePath.Equals("N/A"))
{
var isDeleted = ftpMdl.deleteFTPImage(SelectedLogoInfo.ImagePath);
}
if (!Information.IsNothing(pbBagLogo.Image))
{
string remotePath = "/Operations/EmptyBags/BagPictures/";
imageUploaded = ftpMdl.uploadFtpFile(SelectedLogo.Name, remotePath, imageName);
if (imageUploaded == false)
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Image not saved", @"An error occured while saving the image into FTP server.Please make sure you are connected to WTC network.
If problem persist, contact the IT department.", this);
imagePath = "N/A";
}
else
{
imagePath = "Operations/EmptyBags/BagPictures/" + imageName;
}
}
else
{
imagePath = "N/A";
imageUploaded = true;
}
return(imageUploaded);
}
public static void fillEmployeeDetails(int employeeID)
{
foreach (DataRow employee in (IEnumerable)db.getEmployee(employeeID).Rows)
{
My.MyProject.Forms.FrmEmployeeDetails.empIDLabel.Text = employee["ID"].ToString();
userID = Conversions.ToInteger(employee["ID"].ToString());
My.MyProject.Forms.FrmEmployeeDetails.empNameLabel.Text = Conversions.ToString(Operators.AddObject(Operators.AddObject(employee["First_Name"], " "), employee["Last_Name"]));
if (!employee["Card_ID"].Equals("Not assigned"))
{
My.MyProject.Forms.FrmAddNewEmployee.cardAddignedLabel.BackColor = Color.Green;
My.MyProject.Forms.FrmAddNewEmployee.cardAddignedLabel.Text = "Assigned";
My.MyProject.Forms.FrmEmployeeDetails.cardStatusLabel.Text = "Assigned";
My.MyProject.Forms.FrmEmployeeDetails.cardStatusLabel.BackColor = Color.Green;
}
var ftpModule = new MdlFtp();
Bitmap ImageFromDB;
if (!Information.IsDBNull(employee["EmployeePicturePath"]) && !employee["EmployeePicturePath"].Equals(""))
{
ImageFromDB = ftpModule.GetFTPImage(Conversions.ToString(employee["EmployeePicturePath"]));
My.MyProject.Forms.FrmEmployeeDetails.PictureBox.BackgroundImage = ImageFromDB;
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.PictureBox.BackgroundImage = null;
}
if (employee["Status"].Equals("Active"))
{
My.MyProject.Forms.FrmEmployeeDetails.statusLabel.Text = " Active";
My.MyProject.Forms.FrmEmployeeDetails.statusLabel.ImageKey = "roundedGradientGreen.png";
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.statusLabel.Text = " Not Active";
My.MyProject.Forms.FrmEmployeeDetails.statusLabel.ImageKey = "redBall.png";
}
My.MyProject.Forms.FrmEmployeeDetails.TypeLabel.Text = Conversions.ToString(employee["Type"]);
My.MyProject.Forms.FrmEmployeeDetails.yardLabel.Text = Conversions.ToString(employee["Yard"]);
My.MyProject.Forms.FrmEmployeeDetails.jobDescriptionLabel.Text = Conversions.ToString(employee["Job_Description"]);
if (employee["Supervisor"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.supervisorLabel.Text = "N/A";
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.supervisorLabel.Text = Conversions.ToString(employee["Supervisor"]);
}
My.MyProject.Forms.FrmEmployeeDetails.aliasLabel.Text = Conversions.ToString(employee["Alias"]);
My.MyProject.Forms.FrmEmployeeDetails.genderLabel.Text = Conversions.ToString(employee["Gender"]);
if (MdlOptionsManagement.allowedToSensitiveInformation == false)
{
My.MyProject.Forms.FrmEmployeeDetails.sinLabel.Text = "******";
My.MyProject.Forms.FrmEmployeeDetails.birthdayLabel.Text = "******";
My.MyProject.Forms.FrmEmployeeDetails.PayMethodLabel.Text = "******";
My.MyProject.Forms.FrmEmployeeDetails.addressLabel.Text = "******";
My.MyProject.Forms.FrmEmployeeDetails.endDateLabel.Text = "******";
My.MyProject.Forms.FrmEmployeeDetails.startDateLabel19.Text = "******";
}
else
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(employee["SIN_Number"], 0, false)))
{
My.MyProject.Forms.FrmEmployeeDetails.sinLabel.Text = "N/A";
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.sinLabel.Text = Conversions.ToString(employee["SIN_Number"]);
}
if (!employee["Birth_Date"].Equals(""))
{
DateTime bd;
bd = Convert.ToDateTime(employee["Birth_Date"]);
My.MyProject.Forms.FrmEmployeeDetails.birthdayLabel.Text = bd.Date.ToString("MMM-dd-yyyy");
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.birthdayLabel.Text = "N/A";
}
My.MyProject.Forms.FrmEmployeeDetails.PayMethodLabel.Text = Conversions.ToString(employee["Pay_Method"]);
if (!employee["Address"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.addressLabel.Text = Conversions.ToString(employee["Address"]);
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.addressLabel.Text = "N/A";
}
var sd = Convert.ToDateTime(employee["Start_Date"]);
My.MyProject.Forms.FrmEmployeeDetails.startDateLabel19.Text = sd.Date.ToString("MMM-dd-yyyy");
if (!Information.IsDBNull(employee["End_Date"]))
{
sd = Convert.ToDateTime(employee["End_Date"]);
My.MyProject.Forms.FrmEmployeeDetails.endDateLabel.Text = sd.Date.ToString("MMM-dd-yyyy");
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.endDateLabel.Text = "N/A";
}
}
if (!employee["Phone_Number"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.phoneLabel.Text = Conversions.ToString(employee["Phone_Number"]);
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.phoneLabel.Text = "N/A";
}
if (!employee["Email"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.emailLabel.Text = Conversions.ToString(employee["Email"]);
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.emailLabel.Text = "N/A";
}
if (!employee["FirstName_Emerg_Contact"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.emergNameLabel.Text = Conversions.ToString(Operators.AddObject(Operators.AddObject(employee["FirstName_Emerg_Contact"], " "), employee["LastName_Emerg_Contact"]));
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.emergNameLabel.Text = "N/A";
}
if (!employee["PhoneNumber_Emerg_Contact"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.emergPhoneNumbLabel.Text = Conversions.ToString(employee["PhoneNumber_Emerg_Contact"]);
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.emergPhoneNumbLabel.Text = "N/A";
}
if (!employee["Relationship_Emerg_Contact"].Equals(""))
{
My.MyProject.Forms.FrmEmployeeDetails.relationshipLabel.Text = Conversions.ToString(employee["Relationship_Emerg_Contact"]);
}
else
{
My.MyProject.Forms.FrmEmployeeDetails.relationshipLabel.Text = "N/A";
}
fillSkillsCheckBoxes();
break;
}
}
private void Button2_Click(object sender, EventArgs e)
{
var ftpModule = new MdlFtp();
string imageName;
if (string.IsNullOrEmpty(firstNameTextBox.Text) | string.IsNullOrEmpty(lastNameLabel.Text) | typeComboBox.SelectedIndex == -1 | yardComboBox.SelectedIndex == -1 | genderComboBox.SelectedIndex == -1 | string.IsNullOrEmpty(jobDescriptionComboBox.Text) | payMehodComboBox.SelectedIndex == -1)
{
MdlControllerModifier.warning("incomplete information", titlePersonalInfoLabel);
}
else if (personalInfoButton.Text.Equals("Save and Continue"))
{
if (!Information.IsNothing(remoteFtpPath) && remoteFtpPath.Equals(""))
{
imageName = Strings.Trim(aliasTextBox.Text).Replace("/", "").Replace(@"\", "").Replace(" ", "") + DateAndTime.Now.ToString("dd-MMMd-yyyy_HHmmss") + pictureExtendsion;
remoteFtpPath = "/Operations/EmployeeManagement/EmployeePictures/";
ftpModule.uploadFtpFile(PictureLocalPath, remoteFtpPath, imageName);
}
else
{
remoteFtpPath = "";
}
if (Conversions.ToBoolean(db.saveEmployee()))
{
if (!newEmployeeTabControl.TabPages.Contains(certificationsTabPage))
{
newEmployeeTabControl.TabPages.Add(certificationsTabPage);
newEmployeeTabControl.SelectTab(1);
}
_employeeFirstName = firstNameTextBox.Text;
_employeeLasttName = lastNameTextBox.Text;
_alias = aliasTextBox.Text;
SkillsCertificationPictureBox.BackgroundImage = employeePictureBox.BackgroundImage;
titlePersonalInfoLabel.ForeColor = Color.FromArgb(64, 64, 64);
titlePersonalInfoLabel.Text = "Fill up all that apply";
}
else
{
MdlControllerModifier.warning("user already exists", titlePersonalInfoLabel);
}
}
else
{
if (!PictureLocalPath.Equals(""))
{
imageName = Strings.Trim(aliasTextBox.Text).Replace("/", "").Replace(@"\", "").Replace(" ", "") + DateAndTime.Now.ToString("dd-MMMd-yyyy_HHmmss") + pictureExtendsion;
remoteFtpPath = "/Operations/EmployeeManagement/EmployeePictures/" + imageName;
if ((OldPictureRemotelPath ?? "") != (remoteFtpPath ?? "") && !OldPictureRemotelPath.Equals(""))
{
ftpModule.deleteFTPImage(OldPictureRemotelPath);
}
ftpModule.uploadFtpFile(PictureLocalPath, "/Operations/EmployeeManagement/EmployeePictures/", imageName);
SkillsCertificationPictureBox.BackgroundImage = employeePictureBox.BackgroundImage;
ScanCardPictureBox.BackgroundImage = employeePictureBox.BackgroundImage;
}
else
{
remoteFtpPath = "";
}
db.updateEmployeeInfo(MdlModifyData.userID);
if (!newEmployeeTabControl.TabPages.Contains(certificationsTabPage))
{
newEmployeeTabControl.TabPages.Add(certificationsTabPage);
newEmployeeTabControl.SelectTab(1);
}
MdlModifyData.fillSkillsCheckBoxes();
newEmployeeTabControl.SelectTab(1);
}
}
