private void btnDelete_Click(object sender, EventArgs e) { tblLogFault fault = new tblLogFault(); if (dgvViewLog.CurrentRow.Index != -1) { model.LogID = Convert.ToInt32(dgvViewLog.CurrentRow.Cells["LogID"].Value); using (MacrocommEntities db = new MacrocommEntities()) { model = db.tblViewLogs.Where(x => x.LogID == model.LogID).FirstOrDefault(); if (MessageBox.Show("Are you sure to delete this record ?", "EF CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes) { var entry = db.Entry(model); if (entry.State == EntityState.Detached) { db.tblViewLogs.Attach(model); } db.tblViewLogs.Remove(model); db.SaveChanges(); MessageBox.Show("Deleted Successfully"); } } } }
private void btnSubmit_Click(object sender, EventArgs e) { try { MacrocommEntities context = new MacrocommEntities(); tblLogOther objOther = new tblLogOther(); objOther.Fault_Type = cmbFaultType.Text; objOther.ConsumerType = cmbCustomerType.Text; objOther.Location = txtLocation.Text; objOther.Comment = txtComment.Text; context.tblLogOthers.Add(objOther); context.SaveChanges(); MessageBox.Show("Request Logged successfully", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); Clear(); cmbFaultType.Focus(); } catch { MessageBox.Show("Request not logged, Please check all fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Clear(); cmbFaultType.Focus(); } }
private void frmViewLog_Load(object sender, EventArgs e) { using (MacrocommEntities db = new MacrocommEntities()) { tblViewLogBindingSource.DataSource = db.tblViewLogs.ToList(); } }
private void frmRegistration_Load(object sender, EventArgs e) { using (MacrocommEntities db = new MacrocommEntities()) { tblRegistrationBindingSource.DataSource = db.tblRegistrations.ToList(); } }
private void frmDashboard_Load(object sender, EventArgs e) { using (MacrocommEntities db = new MacrocommEntities()) { tblRegistrationBindingSource.DataSource = db.tblRegistrations.ToList(); } // Circular progress bar for fixed for (int x = 1; x <= 80; x++) { Thread.Sleep(5); cbFixed.Value = x; cbFixed.Update(); } // Circular progress bar for Not fixed for (int x = 1; x <= 90; x++) { Thread.Sleep(5); cbNotFixed.Value = x; cbNotFixed.Update(); } // Circular progress bar for Total for (int x = 1; x <= 60; x++) { Thread.Sleep(5); cbTotal.Value = x; cbTotal.Update(); } }
void populateDataGridview() { dataGridView1.AutoGenerateColumns = false; using (MacrocommEntities db = new MacrocommEntities()) { dataGridView1.DataSource = db.tblRegistrations.ToList <tblRegistration>(); } }
private void btnSubmit_Click(object sender, EventArgs e) { MacrocommEntities context = new MacrocommEntities(); tblLogFault objLog = new tblLogFault(); if (cmbFaultType.Text == "" || cmbCustomerType.Text == "" || txtComment.Text == "") { MessageBox.Show("Please enter all requered field.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { // Adding logs to the FaultLogs table. objLog.Log_Type = cmbFaultType.Text; objLog.Consumer_Type = cmbCustomerType.Text; objLog.Comment = txtComment.Text; context.tblLogFaults.Add(objLog); context.SaveChanges(); MessageBox.Show("Log request Successfully logged.", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); Clear(); } catch { MessageBox.Show("Something went wrong please try again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Clear(); } } using (MacrocommEntities db = new MacrocommEntities()) { tblViewLog view = new tblViewLog(); var logg = (from p in db.tblLogFaults join r in db.tblViewLogs on p.Ref_No equals r.LogID where p.Log_Type == "Water,Electricity,Refuse,Sawege" select new { ID = p.Ref_No, cmbFaultType = p.Log_Type, cmbCustomerType = p.Consumer_Type, txtComment = p.Comment, lID = r.LogID, fault = r.Fault_Type, comsumer = r.Consumer_Status, comments = r.Comment }).ToList(); context.tblViewLogs.Add(view); context.SaveChanges(); } }
private void ViewProfile_Load(object sender, EventArgs e) { if (roleVUp == "Administrator" || roleVUp == "Management") { btnAddUser.Visible = true; } else { btnAddUser.Visible = false; } using (MacrocommEntities db = new MacrocommEntities()) { tblRegistrationBindingSource.DataSource = db.tblRegistrations.ToList(); } }
private void btnSearch_Click(object sender, EventArgs e) { string x = txtSearch.Text.Trim(); int result = System.Int32.Parse(x); model.Ref_No = result; using (MacrocommEntities db = new MacrocommEntities()) { //dgvViewLog.Visible = true; //dgvViewLog.Visible = false; dgvViewLog.DataSource = ef.tblViewLogs.SqlQuery("SELECT * FROM tblViewLog WHERE Ref_No=" + txtSearch.Text).ToList <tblViewLog>(); } txtSearch.Text = ""; }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to delete this record ?", "EF CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (MacrocommEntities db = new MacrocommEntities()) { var entry = db.Entry(model); if (entry.State == EntityState.Detached) { db.tblRegistrations.Attach(model); } db.tblRegistrations.Remove(model); db.SaveChanges(); MessageBox.Show("Deleted Successfully"); this.Close(); } } }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentRow.Index != -1) { model.UserID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["UserID"].Value); using (MacrocommEntities db = new MacrocommEntities()) { model = db.tblRegistrations.Where(x => x.UserID == model.UserID).FirstOrDefault(); imageVUp = byteArrayToImage(model.images); roleVUp = model.UserRole; nameVUp = model.FirstName; emailVUp = model.Email; mobileVUp = model.Mobile; surnameVUp = model.Surname; } } frmUserProfile ViewUserProfile = new frmUserProfile(imageVUp, roleVUp, nameVUp, emailVUp, mobileVUp, surnameVUp, model, oldRoleVUP); ViewUserProfile.Show(); }
private void btnSave_Click(object sender, EventArgs e) { //txtFirstName.Visible = false; //txtEmail.Visible = false; //txtMobile.Visible = false; //txtSurname.Visible = false; //tblroles.Visible = false; //btnUpload.Visible = false; //btnSave.Visible = false; //btnEditProfile.Visible = true; //lblFirstName.Visible = true; //lblEmail.Visible = true; //lblMobile.Visible = true; //lblrole.Visible = true; //lblSurname.Visible = true; if (txtFirstName.Text == "" || txtSurname.Text == "" || txtMobile.Text == "" || txtEmail.Text == "" || imgProfile.Image == null) { MessageBox.Show("Please enter all fields"); txtFirstName.Visible = true; txtSurname.Visible = true; txtEmail.Visible = true; txtMobile.Visible = true; tblroles.Visible = true; cmbUserRole.Visible = true; btnUpload.Visible = true; btnSave.Visible = true; btnEditProfile.Visible = false; btnCancel.Visible = false; btnDelete.Visible = false; btnCancel2.Visible = true; lblFirstName.Visible = false; lblSurname.Visible = false; lblrole.Visible = false; lblEmail.Visible = false; lblMobile.Visible = false; } else { try { //MacrocommEntities context = new MacrocommEntities(); model.FirstName = txtFirstName.Text; model.Surname = txtSurname.Text; model.Email = txtEmail.Text; model.UserRole = cmbUserRole.Text; model.Mobile = txtMobile.Text; //model.images = ConvertFiltoByte(this.imgProfile.ImageLocation); using (MacrocommEntities context = new MacrocommEntities()) { context.Entry(model).State = EntityState.Modified; context.SaveChanges(); } MessageBox.Show("Record Modified", "Confirmation"); txtFirstName.Visible = false; txtEmail.Visible = false; txtMobile.Visible = false; txtSurname.Visible = false; tblroles.Visible = false; cmbUserRole.Visible = false; btnUpload.Visible = false; btnSave.Visible = false; btnEditProfile.Visible = true; btnCancel2.Visible = true; btnDelete.Visible = false; lblFirstName.Visible = true; lblEmail.Visible = true; lblMobile.Visible = true; lblrole.Visible = true; lblSurname.Visible = true; } catch { txtFirstName.Visible = true; txtSurname.Visible = true; txtEmail.Visible = true; txtMobile.Visible = true; tblroles.Visible = true; btnUpload.Visible = true; btnSave.Visible = true; btnEditProfile.Visible = false; btnCancel.Visible = false; btnDelete.Visible = false; btnCancel2.Visible = true; lblFirstName.Visible = false; lblSurname.Visible = false; lblrole.Visible = false; lblEmail.Visible = false; lblMobile.Visible = false; MessageBox.Show("User not Updated", "Confirmation"); } } }