private void btnDelete_Click(object sender, EventArgs e) { try { List <CategoryInfo> inf = (from category in EFERTDbUtility.mEFERTDb.CategoryInfo where category != null select category).ToList(); if (string.IsNullOrEmpty(this.txtId.Text)) { return; } int id = Convert.ToInt32(this.txtId.Text); CategoryInfo catInfo = inf.Find(cat => cat.CategoryId == id); if (catInfo != null) { EFERTDbUtility.mEFERTDb.Entry(catInfo).State = System.Data.Entity.EntityState.Deleted; EFERTDbUtility.mEFERTDb.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(this, "Some error occurred in deleting Cadre.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }
private void btnDisableAlerts_Click(object sender, EventArgs e) { bool disableAlert = Convert.ToBoolean(this.btnDisableAlerts.Tag); AlertInfo alertInfo = (from alert in EFERTDbUtility.mEFERTDb.AlertInfos where alert != null && alert.CNICNumber == this.mCNICNumber select alert).FirstOrDefault(); if (alertInfo == null) { alertInfo = new AlertInfo(); alertInfo.CNICNumber = this.mCNICNumber; if (disableAlert) { alertInfo.DisableAlert = true; alertInfo.DisableAlertDate = DateTime.Now; alertInfo.EnableAlertDate = DateTime.MaxValue; } else { alertInfo.DisableAlert = false; alertInfo.EnableAlertDate = DateTime.Now; } EFERTDbUtility.mEFERTDb.AlertInfos.Add(alertInfo); } else { if (disableAlert) { alertInfo.DisableAlert = true; alertInfo.DisableAlertDate = DateTime.Now; } else { alertInfo.DisableAlert = false; alertInfo.EnableAlertDate = DateTime.Now; } EFERTDbUtility.mEFERTDb.Entry(alertInfo).State = System.Data.Entity.EntityState.Modified; } try { EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); return; } }
private void btnSave_Click(object sender, EventArgs e) { int dayToEmailNotification = Convert.ToInt32(this.nuNoEmailNotificationDays.Value); int daysToBlock = Convert.ToInt32(this.nuNoOfBlockUserDays.Value); if (daysToBlock < dayToEmailNotification) { MessageBox.Show("Days to block can not be less than day to email notification."); return; } try { if (this.mSettings == null) { this.mSettings = new SystemSetting(); this.mSettings.DaysToEmailNotification = Convert.ToInt32(this.nuNoEmailNotificationDays.Value); this.mSettings.DaysToBlockUser = Convert.ToInt32(this.nuNoOfBlockUserDays.Value); this.mSettings.SmtpServer = this.tbxSmtpServer.Text; this.mSettings.SmtpPort = this.tbxSmtpPort.Text; this.mSettings.FromEmailAddress = this.tbxUserName.Text; this.mSettings.FromEmailPassword = this.tbxPassword.Text; this.mSettings.IsSmptSSL = this.chbIsSSL.Checked; this.mSettings.IsSmptAuthRequired = this.chbAuthReq.Checked; EFERTDbUtility.mEFERTDb.SystemSetting.Add(this.mSettings); } else { this.mSettings.DaysToEmailNotification = Convert.ToInt32(this.nuNoEmailNotificationDays.Value); this.mSettings.DaysToBlockUser = Convert.ToInt32(this.nuNoOfBlockUserDays.Value); this.mSettings.SmtpServer = this.tbxSmtpServer.Text; this.mSettings.SmtpPort = this.tbxSmtpPort.Text; this.mSettings.FromEmailAddress = this.tbxUserName.Text; this.mSettings.FromEmailPassword = this.tbxPassword.Text; this.mSettings.IsSmptSSL = this.chbIsSSL.Checked; this.mSettings.IsSmptAuthRequired = this.chbAuthReq.Checked; EFERTDbUtility.mEFERTDb.Entry(this.mSettings).State = System.Data.Entity.EntityState.Modified; } EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some save system settings.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }
private void dataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { try { CadreInfo cadre = e.Row.Tag as CadreInfo; EFERTDbUtility.mEFERTDb.Entry(cadre).State = System.Data.Entity.EntityState.Deleted; EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { MessageBox.Show(this, "Some error occurred in deleting Cadre.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); e.Cancel = true; } }
private void btnUpdate_Click(object sender, EventArgs e) { List <CategoryInfo> inf = (from category in EFERTDbUtility.mEFERTDb.CategoryInfo where category != null select category).ToList(); //category not already exist string categoryName = this.txtName.Text.Trim(); string blockInfo = this.cbxBlockCriteria.SelectedItem.ToString(); string location = this.cbxLoction.SelectedItem.ToString(); if (string.IsNullOrEmpty(this.txtId.Text)) { return; } int id = Convert.ToInt32(this.txtId.Text); CategoryInfo catInfo = inf.Find(cat => cat.CategoryId == id); if (catInfo != null) { if (!string.IsNullOrEmpty(categoryName) && (catInfo.CategoryLocation != location || catInfo.CategoryBlockCriteria != blockInfo || catInfo.CategoryName != categoryName)) { try { catInfo.CategoryName = categoryName; catInfo.CategoryBlockCriteria = blockInfo; catInfo.CategoryLocation = location; EFERTDbUtility.mEFERTDb.Entry(catInfo).State = System.Data.Entity.EntityState.Modified; EFERTDbUtility.mEFERTDb.SaveChanges(); this.dgvCategoryInfo.DataSource = (from category in EFERTDbUtility.mEFERTDb.CategoryInfo where category != null select category).ToList(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in updating category.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } } } }
private void btnAdd_Click(object sender, EventArgs e) { List <CategoryInfo> inf = (from category in EFERTDbUtility.mEFERTDb.CategoryInfo where category != null select category).ToList(); string categoryName = this.txtName.Text.Trim(); string blockInfo = this.cbxBlockCriteria.SelectedItem.ToString(); string location = this.cbxLoction.SelectedItem.ToString(); bool alreadyAdded = inf.Exists(cat => cat.CategoryName != null && cat.CategoryName.ToLower() == categoryName.ToLower()); if (!string.IsNullOrEmpty(categoryName) && !alreadyAdded) { try { CategoryInfo catInof = new CategoryInfo() { CategoryName = categoryName, CategoryBlockCriteria = blockInfo, CategoryLocation = location }; EFERTDbUtility.mEFERTDb.CategoryInfo.Add(catInof); EFERTDbUtility.mEFERTDb.SaveChanges(); this.dgvCategoryInfo.DataSource = (from category in EFERTDbUtility.mEFERTDb.CategoryInfo where category != null select category).ToList(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in Adding category.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } } }
//private void dgvPlantLocations_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e) //{ // if (e.RowIndex < mLstPlantLocations.Count - 1) // { // this.dgvPlantLocations.Rows[e.RowIndex].Tag = mLstPlantLocations[e.RowIndex]; // } //} //private void dgvColonyLocations_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e) //{ // if (e.RowIndex < mLstColonyLocations.Count - 1) // { // this.dgvColonyLocations.Rows[e.RowIndex].Tag = mLstColonyLocations[e.RowIndex]; // } //} //private void dgvPlantLocations_UserAddedRow(object sender, DataGridViewRowEventArgs e) //{ // try // { // string newValue = e.Row.Cells[1].Value as string; // VisitingLocations newLoacation = new VisitingLocations() // { // IsOnPlant = true, // Location = newValue // }; // EFERTDbUtility.mEFERTDb.VisitingLocations.Add(newLoacation); // EFERTDbUtility.mEFERTDb.SaveChanges(); // EFERTDbUtility.mVisitingLocations.Add(newLoacation); // e.Row.Tag = newLoacation; // } // catch (Exception ex) // { // MessageBox.Show(this, "Some error occurred in deleting location.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); // } //} private void dgvPlantLocations_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { try { VisitingLocations visitingLocations = e.Row.Tag as VisitingLocations; EFERTDbUtility.mEFERTDb.Entry(visitingLocations).State = System.Data.Entity.EntityState.Deleted; EFERTDbUtility.mEFERTDb.SaveChanges(); EFERTDbUtility.mVisitingLocations.Remove(visitingLocations); } catch (Exception ex) { MessageBox.Show(this, "Some error occurred in deleting location.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); e.Cancel = true; } }
private void dgvColonyLocations_CellEndEdit(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = this.dgvColonyLocations.Rows[e.RowIndex]; string location = row.Cells[1].Value as string; if (row == null || string.IsNullOrEmpty(location)) { this.dgvColonyLocations.CancelEdit(); return; } if (!string.IsNullOrEmpty(location)) { location = location.Trim().ToLower(); } List <VisitingLocations> visitingLocations = EFERTDbUtility.mEFERTDb.VisitingLocations.ToList(); bool locAlradyExist = visitingLocations.Exists(c => c.Location.Trim().ToLower() == location && !c.IsOnPlant); if (locAlradyExist) { this.dgvColonyLocations.CancelEdit(); return; } VisitingLocations visitingLocation = null; if (row.Tag == null) { visitingLocation = new VisitingLocations() { Location = row.Cells[1].Value as String, IsOnPlant = false }; EFERTDbUtility.mEFERTDb.VisitingLocations.Add(visitingLocation); } else { visitingLocation = row.Tag as VisitingLocations; visitingLocation.Location = row.Cells[1].Value as String; EFERTDbUtility.mEFERTDb.Entry(visitingLocation).State = System.Data.Entity.EntityState.Modified; } try { EFERTDbUtility.mEFERTDb.SaveChanges(); if (row.Tag == null) { EFERTDbUtility.mVisitingLocations.Add(visitingLocation); row.Tag = visitingLocation; } else { EFERTDbUtility.mVisitingLocations[EFERTDbUtility.mVisitingLocations.IndexOf(visitingLocation)] = visitingLocation; } } catch (Exception ex) { EFERTDbUtility.RollBack(); this.dgvColonyLocations.CancelEdit(); MessageBox.Show(this, "Some error occurred in updating visiting locations.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }
private void btnCheckIn_Click(object sender, EventArgs e) { string cardNumber = this.tbxCheckInCardNumber.Text; if (!this.tbxCnicNumber.MaskCompleted) { MessageBox.Show(this, "Please Enter correct CNIC NUMBER."); this.tbxCnicNumber.ReadOnly = false; this.tbxCnicNumber.BackColor = System.Drawing.Color.White; return; } bool validtated = EFERTDbUtility.ValidateInputs(new List <TextBox>() { this.tbxFirstName, this.tbxCheckInCardNumber }); if (validtated && this.cbxVFCategory.SelectedItem == null || string.IsNullOrEmpty(this.cbxVFCategory.SelectedItem.ToString().Trim())) { validtated = false; } if (!validtated) { MessageBox.Show(this, "Please fill mandatory fields first."); return; } bool isCardNotReturned = this.mCheckIns.Any(checkInInfo => checkInInfo.CheckedIn && checkInInfo.CardNumber == cardNumber); CCFTCentralDb.CCFTCentral ccftCentralDb = new CCFTCentralDb.CCFTCentral(); bool cardExist = ccftCentralDb.Cardholders.Any(card => card.LastName == cardNumber); if (cardExist && !isCardNotReturned) { var cardAlreadyIssued = (from checkin in EFERTDbUtility.mEFERTDb.CheckedInInfos where checkin != null && checkin.CheckedIn && checkin.CardNumber == cardNumber select new { checkin.CheckedIn, checkin.CNICNumber }).FirstOrDefault(); if (cardAlreadyIssued != null && cardAlreadyIssued.CheckedIn) { MessageBox.Show(this, "This card is already issue to the person with CNIC number: " + cardAlreadyIssued.CNICNumber); return; } if (this.mVisitor == null) { VisitorCardHolder visitor = new VisitorCardHolder(); visitor.CNICNumber = this.tbxCnicNumber.Text; visitor.Gender = this.cbxGender.SelectedItem == null ? string.Empty : this.cbxGender.SelectedItem as String; visitor.FirstName = this.tbxFirstName.Text; visitor.LastName = this.tbxLastName.Text; visitor.Address = this.tbxAddress.Text; visitor.PostCode = this.tbxPostCode.Text; visitor.City = this.tbxCity.Text; visitor.State = this.tbxState.Text; visitor.CompanyName = this.tbxCompanyName.Text; visitor.ContactNo = this.tbxPhoneNumber.Text; visitor.EmergencyContantPerson = this.tbxEmergencyContact.Text; visitor.EmergencyContantPersonNumber = this.tbxEmergencyContactNumber.Text; visitor.VisitorType = this.cbxVisitorType.SelectedItem == null ? string.Empty : this.cbxVisitorType.SelectedItem as String; visitor.IsOnPlant = SearchForm.mIsPlant; if (this.pbxSnapShot.Image != null) { visitor.Picture = EFERTDbUtility.ImageToByteArray(this.pbxSnapShot.Image); } if (this.mSchoolingStaff) { visitor.SchoolName = this.cbxSchoolCollege.SelectedItem == null ? string.Empty : this.cbxSchoolCollege.SelectedItem as String; } visitor.VisitorInfo = this.mVisitorInfo; EFERTDbUtility.mEFERTDb.Visitors.Add(visitor); //EFERTDbUtility.mEFERTDb.SaveChanges(); this.mVisitor = visitor; } CheckInAndOutInfo checkedInInfo = new CheckInAndOutInfo(); checkedInInfo.CheckInToPlant = SearchForm.mIsPlant; checkedInInfo.CheckInToPlant = !SearchForm.mIsPlant; checkedInInfo.FirstName = this.mVisitor.FirstName; checkedInInfo.Visitors = this.mVisitor; checkedInInfo.CNICNumber = this.mCNICNumber; checkedInInfo.CardNumber = this.tbxCheckInCardNumber.Text; checkedInInfo.VehicleNmuber = this.tbxCheckInVehicleNumber.Text; checkedInInfo.NoOfMaleGuest = this.nuNoOfMaleGuest.Value; checkedInInfo.NoOfFemaleGuest = this.nuNoOfFemaleGuest.Value; checkedInInfo.DurationOfStay = this.numCheckInDurationOfStay.Value; checkedInInfo.NoOfChildren = this.nuCheckInNoOfChildren.Value; checkedInInfo.AreaOfVisit = this.cbxAreaOfVisit.SelectedItem == null ? string.Empty : this.cbxAreaOfVisit.SelectedItem as String; checkedInInfo.HostName = this.tbxCheckInHostName.Text; checkedInInfo.DateTimeIn = Convert.ToDateTime(this.tbxCheckInDateTimeIn.Text); checkedInInfo.DateTimeOut = DateTime.MaxValue; checkedInInfo.CheckedIn = true; checkedInInfo.Category = this.mVisitorInfo; try { EFERTDbUtility.mEFERTDb.CheckedInInfos.Add(checkedInInfo); EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in issuing card.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); return; } this.btnCheckIn.Enabled = false; this.btnCheckOut.Enabled = true; this.Close(); } else { if (!cardExist) { MessageBox.Show(this, "Please enter valid card number."); } else if (isCardNotReturned) { MessageBox.Show(this, "Card is already issued to some one else."); } } }
private void btnUnBlock_Click(object sender, EventArgs e) { if (!this.tbxCnicNumber.MaskCompleted) { MessageBox.Show(this, "Please Enter correct CNIC NUMBER."); this.tbxCnicNumber.ReadOnly = false; this.tbxCnicNumber.BackColor = System.Drawing.Color.White; return; } bool validtated = EFERTDbUtility.ValidateInputs(new List <TextBox>() { this.tbxFirstName, this.tbxUnBlockedBy, this.tbxUnblockReason }); if (!validtated) { MessageBox.Show(this, "Please fill mandatory fields first."); return; } DialogResult result = MessageBox.Show(this, "Are you sure you want to block this person?", "Confirmation Dialog", MessageBoxButtons.YesNo); if (result == DialogResult.No) { return; } if (this.mBlocks.Exists(blocked => blocked.Blocked && blocked.CNICNumber == this.mCNICNumber)) { BlockedPersonInfo blockedPerson = this.mBlocks.Find(blocked => blocked.Blocked && blocked.CNICNumber == this.mCNICNumber); blockedPerson.Blocked = false; blockedPerson.UnBlockTime = DateTime.Now; blockedPerson.UnBlockedBy = this.tbxUnBlockedBy.Text; blockedPerson.UnBlockedReason = this.tbxUnblockReason.Text; try { EFERTDbUtility.mEFERTDb.Entry(blockedPerson).State = System.Data.Entity.EntityState.Modified; EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in unblocking cardholder.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); return; } if (this.mCheckIns.Exists(checkedIn => checkedIn.CheckedIn && checkedIn.CNICNumber == this.mCNICNumber)) { this.btnCheckIn.Enabled = false; this.btnCheckOut.Enabled = true; } else { this.btnCheckIn.Enabled = true; this.btnCheckOut.Enabled = false; } this.mBlocks = this.mVisitor.BlockingInfos; this.tbxBlockedBy.Text = string.Empty; this.tbxBlockedReason.Text = string.Empty; this.lblVisitorStatus.Text = "Allowed"; this.lblVisitorStatus.BackColor = Color.Green; this.tbxUnBlockTime.Text = blockedPerson.UnBlockTime.ToString(); this.btnBlock.Enabled = true; this.btnUnBlock.Enabled = false; this.tbxBlockedBy.ReadOnly = false; this.tbxBlockedReason.ReadOnly = false; this.tbxBlockedBy.BackColor = System.Drawing.Color.White; this.tbxBlockedReason.BackColor = System.Drawing.Color.White; this.tbxUnBlockedBy.ReadOnly = true; this.tbxUnblockReason.ReadOnly = true; this.tbxUnBlockedBy.BackColor = System.Drawing.SystemColors.ButtonFace; this.tbxUnblockReason.BackColor = System.Drawing.SystemColors.ButtonFace; } else { MessageBox.Show(this, "This user is not blocked."); } }
private BlockedPersonInfo BlockPerson(string blockedBy, string blockedReason) { BlockedPersonInfo blockedPerson = new BlockedPersonInfo() { Blocked = true, BlockedBy = blockedBy, BlockedReason = blockedReason, CNICNumber = this.mCNICNumber, BlockedTime = DateTime.Now, UnBlockTime = DateTime.MaxValue }; blockedPerson.BlockedInPlant = SearchForm.mIsPlant; blockedPerson.BlockedInColony = !SearchForm.mIsPlant; if (this.mVisitor == null) { MessageBox.Show(this, "Unable to Block visitor. Some error occured in getting visitor information."); return(null); } else { blockedPerson.Visitors = this.mVisitor; } try { EFERTDbUtility.mEFERTDb.BlockedPersons.Add(blockedPerson); EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in blocking visitor.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); return(null); } this.mBlocks = this.mVisitor.BlockingInfos; return(blockedPerson); }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = this.dgvDepartments.Rows[e.RowIndex]; string depart = row.Cells[1].Value as string; if (row == null || string.IsNullOrEmpty(depart)) { this.dgvDepartments.CancelEdit(); return; } if (!string.IsNullOrEmpty(depart)) { depart = depart.Trim().ToLower(); } List <DepartmentInfo> departments = EFERTDbUtility.mEFERTDb.Departments.ToList(); bool departAlradyExist = departments.Exists(c => c.DepartmentName.Trim().ToLower() == depart); if (departAlradyExist) { this.dgvDepartments.CancelEdit(); return; } DepartmentInfo department = null; if (row.Tag == null) { department = new DepartmentInfo() { DepartmentName = row.Cells[1].Value as String }; EFERTDbUtility.mEFERTDb.Departments.Add(department); } else { department = row.Tag as DepartmentInfo; department.DepartmentName = row.Cells[1].Value as String; EFERTDbUtility.mEFERTDb.Entry(department).State = System.Data.Entity.EntityState.Modified; } try { EFERTDbUtility.mEFERTDb.SaveChanges(); if (row.Tag == null) { //EFERTDbUtility.mVisitingLocations.Add(department); row.Tag = department; } else { //EFERTDbUtility.mVisitingLocations[EFERTDbUtility.mVisitingLocations.IndexOf(department)] = department; } } catch (Exception ex) { EFERTDbUtility.RollBack(); this.dgvDepartments.CancelEdit(); MessageBox.Show(this, "Some error occurred in updating visiting locations.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }
private void dgvEmails_CellEndEdit(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = this.dgvEmails.Rows[e.RowIndex]; if (row == null || (string.IsNullOrEmpty(row.Cells[1].Value as string) && string.IsNullOrEmpty(row.Cells[1].Value as string))) { this.dgvEmails.CancelEdit(); } EmailAddress email = null; string name = row.Cells[1].Value as String ?? string.Empty; string emailAddress = row.Cells[2].Value as String ?? string.Empty; if (row.Tag == null) { email = new EmailAddress() { Name = name, Email = emailAddress }; EFERTDbUtility.mEFERTDb.EmailAddresses.Add(email); } else { email = row.Tag as EmailAddress; email.Name = name; email.Email = emailAddress; EFERTDbUtility.mEFERTDb.Entry(email).State = System.Data.Entity.EntityState.Modified; } try { EFERTDbUtility.mEFERTDb.SaveChanges(); if (row.Tag == null) { //EFERTDbUtility.mVisitingLocations.Add(cadre); row.Tag = email; } else { //EFERTDbUtility.mVisitingLocations[EFERTDbUtility.mVisitingLocations.IndexOf(cadre)] = cadre; } } catch (Exception ex) { EFERTDbUtility.RollBack(); this.dgvEmails.CancelEdit(); MessageBox.Show(this, "Some error occurred in updating visiting locations.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }
private void btnCheckIn_Click(object sender, EventArgs e) { string cardNumber = this.tbxCheckInCardNumber.Text; if (string.IsNullOrEmpty(cardNumber)) { MessageBox.Show(this, "Card number can not be empty."); return; } bool isCardNotReturned = this.mCheckIns.Any(checkInInfo => checkInInfo.CheckedIn && checkInInfo.CardNumber == cardNumber); bool cardExist = false; CCFTCentralDb.CCFTCentral ccftCentralDb = new CCFTCentralDb.CCFTCentral(); cardExist = ccftCentralDb.Cardholders.Any(card => card.LastName == cardNumber); CardHolderInfo cardHolderInfo = this.mCardHolderInfo; if (cardExist && !isCardNotReturned) { var cardAlreadyIssued = (from checkin in EFERTDbUtility.mEFERTDb.CheckedInInfos where checkin != null && checkin.CheckedIn && checkin.CardNumber == cardNumber select new { checkin.CheckedIn, checkin.CNICNumber }).FirstOrDefault(); if (cardAlreadyIssued != null && cardAlreadyIssued.CheckedIn) { MessageBox.Show(this, "This card is already issue to the person with CNIC number: " + cardAlreadyIssued.CNICNumber); return; } if (cardHolderInfo == null) { MessageBox.Show(this, "Unable to Issue Card. Some error occured in getting cardholder information."); return; } CheckInAndOutInfo checkedInInfo = new CheckInAndOutInfo(); checkedInInfo.CheckInToPlant = SearchForm.mIsPlant; checkedInInfo.CheckInToColony = !SearchForm.mIsPlant; checkedInInfo.FirstName = cardHolderInfo.FirstName; checkedInInfo.CardHolderInfos = cardHolderInfo; checkedInInfo.CNICNumber = this.mCNICNumber; checkedInInfo.CardNumber = cardNumber; checkedInInfo.VehicleNmuber = this.tbxCheckInVehicleNumber.Text; checkedInInfo.DateTimeIn = Convert.ToDateTime(this.tbxCheckInDateTimeIn.Text); checkedInInfo.DateTimeOut = DateTime.MaxValue; checkedInInfo.CheckedIn = true; try { EFERTDbUtility.mEFERTDb.CheckedInInfos.Add(checkedInInfo); EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in issuing card.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); return; } this.btnCheckIn.Enabled = false; this.btnCheckOut.Enabled = true; this.Close(); } else { if (!cardExist) { MessageBox.Show(this, "Please enter valid card number."); } else if (isCardNotReturned) { MessageBox.Show(this, "Card is already issued to some one else."); } } }
private void btnCheckOut_Click(object sender, EventArgs e) { if (this.mCheckIns.Exists(checkedOut => checkedOut.CheckedIn && checkedOut.CNICNumber == this.mCNICNumber)) { CheckInAndOutInfo checkedOutInfo = this.mCheckIns.Find(checkedOut => checkedOut.CheckedIn && checkedOut.CNICNumber == this.mCNICNumber); checkedOutInfo.CheckedIn = false; checkedOutInfo.DateTimeOut = Convert.ToDateTime(this.tbxCheckInDateTimeOut.Text); try { EFERTDbUtility.mEFERTDb.Entry(checkedOutInfo).State = System.Data.Entity.EntityState.Modified; EFERTDbUtility.mEFERTDb.SaveChanges(); } catch (Exception ex) { EFERTDbUtility.RollBack(); MessageBox.Show(this, "Some error occurred in returning card.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); return; } this.btnCheckIn.Enabled = true; this.btnCheckOut.Enabled = false; this.Close(); } else { MessageBox.Show(this, "This user is not checked in."); } }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = this.dgvCadres.Rows[e.RowIndex]; string caderVal = row.Cells[1].Value as String; if (row == null || string.IsNullOrEmpty(caderVal)) { this.dgvCadres.CancelEdit(); return; } else { string str = caderVal.Replace(" ", String.Empty); if (string.IsNullOrEmpty(str)) { this.dgvCadres.CancelEdit(); return; } } if (!string.IsNullOrEmpty(caderVal)) { caderVal = caderVal.Trim().ToLower(); } List <CadreInfo> caders = EFERTDbUtility.mEFERTDb.Cadres.ToList(); bool caderAlradyExist = caders.Exists(c => c.CadreName.Trim().ToLower() == caderVal); if (caderAlradyExist) { this.dgvCadres.CancelEdit(); return; } CadreInfo cadre = null; if (row.Tag == null) { cadre = new CadreInfo() { CadreName = row.Cells[1].Value as String }; EFERTDbUtility.mEFERTDb.Cadres.Add(cadre); } else { cadre = row.Tag as CadreInfo; cadre.CadreName = row.Cells[1].Value as String; EFERTDbUtility.mEFERTDb.Entry(cadre).State = System.Data.Entity.EntityState.Modified; } try { EFERTDbUtility.mEFERTDb.SaveChanges(); if (row.Tag == null) { //EFERTDbUtility.mVisitingLocations.Add(cadre); row.Tag = cadre; } else { //EFERTDbUtility.mVisitingLocations[EFERTDbUtility.mVisitingLocations.IndexOf(cadre)] = cadre; } } catch (Exception ex) { EFERTDbUtility.RollBack(); this.dgvCadres.CancelEdit(); MessageBox.Show(this, "Some error occurred in updating visiting locations.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = this.dgvSections.Rows[e.RowIndex]; string sectionVal = row.Cells[1].Value as string; if (row == null || string.IsNullOrEmpty(sectionVal)) { this.dgvSections.CancelEdit(); return; } if (!string.IsNullOrEmpty(sectionVal)) { sectionVal = sectionVal.Trim().ToLower(); } List <SectionInfo> sections = EFERTDbUtility.mEFERTDb.Sections.ToList(); bool secAlradyExist = sections.Exists(c => c.SectionName.Trim().ToLower() == sectionVal); if (secAlradyExist) { this.dgvSections.CancelEdit(); return; } SectionInfo section = null; if (row.Tag == null) { section = new SectionInfo() { SectionName = row.Cells[1].Value as String }; EFERTDbUtility.mEFERTDb.Sections.Add(section); } else { section = row.Tag as SectionInfo; section.SectionName = row.Cells[1].Value as String; EFERTDbUtility.mEFERTDb.Entry(section).State = System.Data.Entity.EntityState.Modified; } try { EFERTDbUtility.mEFERTDb.SaveChanges(); if (row.Tag == null) { //EFERTDbUtility.mVisitingLocations.Add(Section); row.Tag = section; } else { //EFERTDbUtility.mVisitingLocations[EFERTDbUtility.mVisitingLocations.IndexOf(Section)] = Section; } } catch (Exception ex) { EFERTDbUtility.RollBack(); this.dgvSections.CancelEdit(); MessageBox.Show(this, "Some error occurred in updating visiting locations.\n\n" + EFERTDbUtility.GetInnerExceptionMessage(ex)); } }