private void txtEmployeeID_Leave(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtEmployeeID.Text.TrimEnd()))
{
nsgEmployee = DB.NSGEmployees.Where(emp => emp.NSGEmployeeCode == txtEmployeeID.Text).FirstOrDefault();
if (nsgEmployee != null)
{
txtEmployeeName.Text = nsgEmployee.FirstName + " " + nsgEmployee.LastName;
cmbRank.SelectedValue = nsgEmployee.RankID;
cmbUnit.SelectedValue = nsgEmployee.UnitID;
if (nsgEmployee.QuarterTypeID != null)
{
cmbQuarterType.SelectedValue = nsgEmployee.QuarterTypeID;
}
if (nsgEmployee.QuarterNumber != null)
{
txtQuarterNumber.Text = nsgEmployee.QuarterNumber.ToString();
}
}
else
{
txtEmployeeName.Text = string.Empty;
cmbRank.SelectedIndex = -1;
cmbUnit.SelectedIndex = -1;
cmbQuarterType.SelectedIndex = -1;
txtQuarterNumber.Text = string.Empty;
}
}
}
private void txtEmployeeID_Leave(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtEmployeeID.Text.TrimEnd()))
{
btnCreate.Text = "&Create";
nsgEmployee = DB.NSGEmployees.Where(emp => emp.NSGEmployeeCode == txtEmployeeID.Text).FirstOrDefault();
if (nsgEmployee != null)
{
btnCreate.Text = "&Update";
txtFirstName.Text = nsgEmployee.FirstName;
txtLastName.Text = nsgEmployee.LastName;
if (nsgEmployee.Gender.ToUpper() == "MALE")
{
radMale.Checked = true;
}
else
{
radFemale.Checked = true;
}
cmbRank.SelectedValue = nsgEmployee.RankID;
cmbUnit.SelectedValue = nsgEmployee.UnitID;
cmbQuarterType.SelectedValue = nsgEmployee.QuarterTypeID;
txtQuarterNumber.Text = nsgEmployee.QuarterNumber.ToString();
coreUser = DB.CoreUsers.Where(cu => cu.EmployeeID.ToString() == txtEmployeeID.Text).FirstOrDefault();
if (coreUser != null)
{
txtUserName.Text = coreUser.UserName;
}
}
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
string successMsg = string.Empty;
try
{
if (ValidateControls())
{
btnCreate.Enabled = false;
btnCancel.Enabled = false;
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
if (nsgEmployee == null)
{
nsgEmployee = new NSGEmployee();
nsgEmployee.EntryDate = DateTime.Now;
nsgEmployee.EntryUserID = GlobalClass.LoggedInUserID;
}
else
{
nsgEmployee.UpdateDate = DateTime.Now;
nsgEmployee.UpdateUserID = GlobalClass.LoggedInUserID;
}
nsgEmployee.NSGEmployeeCode = txtEmployeeID.Text;
nsgEmployee.FirstName = txtFirstName.Text;
nsgEmployee.LastName = txtLastName.Text;
nsgEmployee.Gender = (radMale.Checked ? "Male" : "Female");
nsgEmployee.RankID = int.Parse(cmbRank.SelectedValue.ToString());
nsgEmployee.UnitID = int.Parse(cmbUnit.SelectedValue.ToString());
if (cmbQuarterType.SelectedIndex > -1)
{
nsgEmployee.QuarterTypeID = int.Parse(cmbQuarterType.SelectedValue.ToString());
}
nsgEmployee.QuarterNumber = int.Parse(txtQuarterNumber.Text);
nsgEmployee.IsActive = chkEmpActive.Checked;
DB.NSGEmployees.Add(nsgEmployee);
successMsg = "Employee created successfully.";
if (chkCreateLogin.Checked)
{
CoreUser coreDupUser;
if (coreUser == null)
{
coreDupUser = DB.CoreUsers.Where(cu => cu.UserName.ToUpper() == txtUserName.Text.ToUpper()).FirstOrDefault();
}
else
{
coreDupUser = DB.CoreUsers.Where(cu => cu.UserName.ToUpper() == txtUserName.Text.ToUpper() && cu.EmployeeID != txtEmployeeID.Text).FirstOrDefault();
}
if (coreDupUser == null)
{
if (coreUser == null)
{
coreUser = new CoreUser();
coreUser.EntryDate = DateTime.Now;
coreUser.EntryUserID = GlobalClass.LoggedInUserID;
}
else
{
coreUser.UpdateDate = DateTime.Now;
coreUser.UpdateUserID = GlobalClass.LoggedInUserID;
}
coreUser.UserName = txtUserName.Text;
coreUser.UserPassword = txtPassword.Text;
coreUser.EmployeeID = txtEmployeeID.Text;
coreUser.FirstName = txtFirstName.Text;
coreUser.LastName = txtLastName.Text;
coreUser.IsActive = chkUserActive.Checked;
DB.CoreUsers.Add(coreUser);
successMsg = "Employee and login created successfully.";
}
else
{
MessageBox.Show("This user name already exists.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtUserName.Text = string.Empty;
txtPassword.Text = string.Empty;
txtReTypePassword.Text = string.Empty;
txtUserName.Focus();
this.btnCreate.Enabled = true;
this.btnCancel.Enabled = true;
this.Cursor = System.Windows.Forms.Cursors.Default;
return;
}
}
DB.SaveChanges();
MessageBox.Show(successMsg, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Cursor = System.Windows.Forms.Cursors.Default;
this.Close();
}
}
catch (Exception ex)
{
this.Cursor = System.Windows.Forms.Cursors.Default;
MessageBox.Show(ex.Message, this.Text + " : btnCreate_Click : " + ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.btnCreate.Enabled = true;
this.btnCancel.Enabled = true;
this.Cursor = System.Windows.Forms.Cursors.Default;
}
}
private void RefreshMe()
{
if (visitorID == 0)
{
txtVisitorNumber.Text = string.Empty;
txtFirstName.Text = string.Empty;
txtLastName.Text = string.Empty;
cmbGender.SelectedIndex = -1;
txtMobileNo.Text = string.Empty;
cmbIdentityType.SelectedIndex = -1;
txtIdentityNumber.Text = string.Empty;
txtVisitorAddress.Text = string.Empty;
cmbState.SelectedIndex = -1;
cmbCity.SelectedIndex = -1;
txtVehicleNumber.Text = string.Empty;
txtPurpose.Text = string.Empty;
txtEmployeeID.Text = string.Empty;
txtEmployeeName.Text = string.Empty;
cmbRank.SelectedIndex = -1;
cmbUnit.SelectedIndex = -1;
cmbQuarterType.SelectedIndex = -1;
txtQuarterNumber.Text = string.Empty;
dgvCoVisitors.Rows.Clear();
picVisitorPhoto.Image = null;
btnPrint.Enabled = false;
isNewEntry = true;
isEditEntry = false;
visitor = null;
nsgEmployee = null;
coVisitors = new List <CoVisitor>();
coVisitorsRemoved = new List <CoVisitor>();
}
else
{
txtVisitorNumber.Text = visitorID.ToString();
if (!isEditEntry || visitor.OutTime != null)
{
txtVisitorNumber.ReadOnly = true;
txtFirstName.ReadOnly = true;
txtLastName.ReadOnly = true;
cmbGender.Enabled = false;
txtMobileNo.ReadOnly = true;
cmbIdentityType.Enabled = false;
txtIdentityNumber.ReadOnly = true;
txtVisitorAddress.ReadOnly = true;
cmbState.Enabled = false;
cmbCity.Enabled = false;
txtVehicleNumber.ReadOnly = true;
txtPurpose.ReadOnly = true;
txtEmployeeID.ReadOnly = true;
txtEmployeeName.ReadOnly = true;
cmbRank.Enabled = false;
cmbUnit.Enabled = false;
cmbQuarterType.Enabled = false;
txtQuarterNumber.ReadOnly = true;
dgvCoVisitors.Enabled = false;
}
btnPrint.Enabled = true;
}
}
private void btnEnter_Click(object sender, EventArgs e)
{
try
{
if (!ValidateControls())
{
return;
}
if (isNewEntry)
{
visitor = new Visitor();
visitor.InTime = DateTime.Now;
visitor.EntryDate = DateTime.Now;
visitor.EntryUserID = GlobalClass.LoggedInUserID;
}
else
{
if (!isEditEntry)
{
visitor.OutTime = DateTime.Now;
}
visitor.UpdateDate = DateTime.Now;
visitor.UpdateUserID = GlobalClass.LoggedInUserID;
}
visitor.MachineID = GlobalClass.MachineName;
visitor.FirstName = txtFirstName.Text;
visitor.LastName = txtLastName.Text;
visitor.Gender = cmbGender.Text;
visitor.MobileNo = txtMobileNo.Text;
visitor.IdentityTypeID = int.Parse(cmbIdentityType.SelectedValue.ToString());
visitor.IdentityNumber = txtIdentityNumber.Text;
visitor.VisitorAddress = txtVisitorAddress.Text;
visitor.StateID = int.Parse(cmbState.SelectedValue.ToString());
if (cmbCity.SelectedIndex > -1)
{
visitor.CityID = int.Parse(cmbCity.SelectedValue.ToString());
}
visitor.VehicleNumber = txtVehicleNumber.Text;
visitor.Purpose = txtPurpose.Text;
visitor.PersonEmpCode = txtEmployeeID.Text;
visitor.PersonName = txtEmployeeName.Text;
if (cmbRank.SelectedIndex != -1)
{
visitor.RankID = int.Parse(cmbRank.SelectedValue.ToString());
}
if (cmbUnit.SelectedIndex != -1)
{
visitor.UnitID = int.Parse(cmbUnit.SelectedValue.ToString());
}
if (cmbQuarterType.SelectedIndex != -1)
{
visitor.QuarterTypeID = int.Parse(cmbQuarterType.SelectedValue.ToString());
}
if (txtQuarterNumber.Text.TrimEnd() != string.Empty)
{
visitor.QuarterNumber = int.Parse(txtQuarterNumber.Text);
}
byte[] visitorImage = (byte[])imgConverter.ConvertTo(picVisitorPhoto.Image, typeof(byte[]));
visitor.VisitorPhoto = visitorImage;
if (isNewEntry)
{
DB.Visitors.Add(visitor);
}
if (isNewEntry && nsgEmployee == null && !string.IsNullOrEmpty(txtEmployeeID.Text.TrimEnd()))
{
nsgEmployee = new NSGEmployee();
nsgEmployee.NSGEmployeeCode = txtEmployeeID.Text;
nsgEmployee.FirstName = txtFirstName.Text;
nsgEmployee.Gender = "Male";
nsgEmployee.RankID = int.Parse(cmbRank.SelectedValue.ToString());
nsgEmployee.UnitID = int.Parse(cmbUnit.SelectedValue.ToString());
if (cmbQuarterType.SelectedIndex > -1)
{
nsgEmployee.QuarterTypeID = int.Parse(cmbQuarterType.SelectedValue.ToString());
}
if (txtQuarterNumber.Text.TrimEnd() != string.Empty)
{
nsgEmployee.QuarterNumber = int.Parse(txtQuarterNumber.Text);
}
nsgEmployee.IsActive = true;
nsgEmployee.EntryDate = DateTime.Now;
nsgEmployee.EntryUserID = GlobalClass.LoggedInUserID;
DB.NSGEmployees.Add(nsgEmployee);
}
DB.SaveChanges();
foreach (DataGridViewRow dgvRow in dgvCoVisitors.Rows)
{
if (dgvRow.Cells["CoVisitorName"].Value != null)
{
CoVisitor coVisitor = null;
if (dgvRow.Cells["CoVisitorID"].Value != null)
{
coVisitor = coVisitors.Find(cv => cv.CoVisitorID == long.Parse(dgvRow.Cells["CoVisitorID"].Value.ToString()));
coVisitor.UpdateDate = DateTime.Now;
coVisitor.UpdateUserID = GlobalClass.LoggedInUserID;
}
else
{
coVisitor = new CoVisitor();
coVisitor.EntryDate = DateTime.Now;
coVisitor.EntryUserID = GlobalClass.LoggedInUserID;
coVisitor = DB.CoVisitors.Add(coVisitor);
coVisitors.Add(coVisitor);
}
coVisitor.VisitorID = visitor.VisitorID;
coVisitor.CoVisitorName = dgvRow.Cells["CoVisitorName"].Value.ToString();
if (dgvRow.Cells["IdentityType"].Value != null)
{
coVisitor.IdentityTypeID = int.Parse(dgvRow.Cells["IdentityType"].Value.ToString());
}
if (dgvRow.Cells["IdentityNumber"].Value != null)
{
coVisitor.IdentityNumber = dgvRow.Cells["IdentityNumber"].Value.ToString();
}
coVisitor.Gender = dgvRow.Cells["Gender"].Value.ToString();
coVisitor.VisitorAddress = string.Empty;
coVisitor.RelationshipID = int.Parse(dgvRow.Cells["Relationship"].Value.ToString());
}
}
if (coVisitorsRemoved.Count > 0)
{
DB.CoVisitors.RemoveRange(coVisitorsRemoved);
}
DB.SaveChanges();
if (isNewEntry)
{
DialogResult msgResponse = MessageBox.Show("Visitor information saved successfully.\nDo you want to continue with Print?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
if (msgResponse == DialogResult.Yes)
{
btnPrint_Click(null, null);
}
msgResponse = MessageBox.Show("Do you want to continue with Visitor Entry?", this.Text, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
if (msgResponse == DialogResult.Yes)
{
RefreshMe();
}
else if (msgResponse == DialogResult.No)
{
btnCancel_Click(null, null);
}
else
{
visitorID = visitor.VisitorID;
RefreshMe();
}
}
else if (isEditEntry)
{
MessageBox.Show("Visitor information updated successfully.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnCancel_Click(null, null);
}
else
{
MessageBox.Show("Visitor exit saved successfully.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnCancel_Click(null, null);
}
}
catch (Exception ex)
{
this.Cursor = System.Windows.Forms.Cursors.Default;
MessageBox.Show(ex.Message, this.Text + " : btnEnter_Click : " + ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtUsername.Text))
{
txtUsername.Focus();
MessageBox.Show("Please enter Username.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty(txtPassword.Text))
{
txtPassword.Focus();
MessageBox.Show("Please enter Password.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["LicenseExpiry"]))
{
if (DateTime.Today > DateTime.Parse(ConfigurationManager.AppSettings["LicenseExpiry"].ToString()))
{
MessageBox.Show("Software License Expired, Please contact software administrator.");
return;
}
}
this.btnLogin.Enabled = false;
this.btnCancel.Enabled = false;
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
string username = txtUsername.Text.ToUpper();
CoreUser coreUser = DB.CoreUsers.Where(cu => cu.UserName.ToUpper() == txtUsername.Text.ToUpper() && cu.UserPassword == txtPassword.Text).FirstOrDefault();
if (coreUser != null)
{
GlobalClass.LoggedInUserID = coreUser.CoreUserID;
GlobalClass.EmployeeName = coreUser.FirstName + " " + coreUser.LastName;
NSGEmployee nsgEmp = DB.NSGEmployees.Where(em => em.NSGEmployeeCode == coreUser.EmployeeID).FirstOrDefault();
if (coreUser.UserName.ToUpper() == "NSGADMIN")
{
if (MessageBox.Show("Do you want to create user?", "Login", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
frmCreateUser createUserForm = new frmCreateUser();
this.Hide();
createUserForm.ShowDialog();
this.txtPassword.Text = string.Empty;
this.txtUsername.Text = string.Empty;
this.btnLogin.Enabled = true;
this.btnCancel.Enabled = true;
this.txtUsername.Focus();
this.Cursor = System.Windows.Forms.Cursors.Default;
this.Show();
}
else
{
//GlobalClass.LoggedInUserRank = DB.CoreRanks.Where(cr => cr.RankID == nsgEmp.RankID).FirstOrDefault().RankName;
//GlobalClass.LoggedInUserUnit = DB.CoreUnits.Where(cu => cu.UnitID == nsgEmp.UnitID).FirstOrDefault().UnitName;
this.btnLogin.Enabled = true;
this.btnCancel.Enabled = true;
this.Cursor = System.Windows.Forms.Cursors.Default;
this.Hide();
frmMainPage frmMainPage = new frmMainPage();
frmMainPage.ShowDialog();
this.Close();
}
}
else
{
GlobalClass.LoggedInUserRank = DB.CoreRanks.Where(cr => cr.RankID == nsgEmp.RankID).FirstOrDefault().RankName;
GlobalClass.LoggedInUserUnit = DB.CoreUnits.Where(cu => cu.UnitID == nsgEmp.UnitID).FirstOrDefault().UnitName;
this.btnLogin.Enabled = true;
this.btnCancel.Enabled = true;
this.Cursor = System.Windows.Forms.Cursors.Default;
this.Hide();
frmMainPage frmMainPage = new frmMainPage();
frmMainPage.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("Invalid username or password!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtPassword.Text = string.Empty;
txtUsername.Text = string.Empty;
txtUsername.Focus();
this.btnLogin.Enabled = true;
this.btnCancel.Enabled = true;
this.Cursor = System.Windows.Forms.Cursors.Default;
return;
}
}
