private void ToolStripButtonsave_Click(object sender, EventArgs e) { using (AccetManagementEntities db = new AccetManagementEntities()) { VENDOR vENDOR = new VENDOR { CONTACTNAME = txtContactName.Text, COUNTRY = txtCountry.Text, EMAIL = txtEmail.Text, PHONENO = txtphoneNumber.Text, POSTALADDRESS = txtAdress.Text, TOWN = txtTown.Text, VENDORNAME = txtVendorName.Text, VENDORNO = txtVendorNumber.Text, WEBSITE = txtWebsite.Text }; db.VENDORs.Add(vENDOR); db.SaveChanges(); this.Close(); MessageBox.Show("Saved Successfully to Database."); Application.Restart();; } }
internal void PopulateControls(string vendno) { using (AccetManagementEntities db = new AccetManagementEntities()) { var vendorDetails = db.VENDORs.Where(c => c.VENDORNO == vendno).ToList(); txtContactName.Text = vendorDetails[0].CONTACTNAME; txtCountry.Text = vendorDetails[0].COUNTRY; txtEmail.Text = vendorDetails[0].EMAIL; txtphoneNumber.Text = vendorDetails[0].PHONENO; txtAdress.Text = vendorDetails[0].POSTALADDRESS; txtTown.Text = vendorDetails[0].TOWN; txtVendorName.Text = vendorDetails[0].VENDORNAME; txtVendorNumber.Text = vendorDetails[0].VENDORNO; txtWebsite.Text = vendorDetails[0].VENDORNO; this.Text = "Edit Vendor " + vendorDetails[0].VENDORNO; //this.userControl11.Show(); //userControl11.BringToFront(); } }
private void UpdateAssetTable() { List <Asset> empAsset = new List <Asset>(); Save_NewMembers saveEmp = new Save_NewMembers(); int staId, locId; using (AccetManagementEntities db = new AccetManagementEntities()) { var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList(); // UPDATE ASSETS TABLE staId = statusId[0]; locId = LocationId[0]; empAsset.Add(new Asset() { AssetNo = this.dgvCheckin.CurrentRow.Cells[0].Value.ToString(), Comment = richTextBoxComent.Text.ToString().Trim(), EmpName = "", CheckoinDate = DateTime.Now, StatusId = statusId[0], LocationId = LocationId[0], EmpId = "" }); } saveEmp.CheckinUpdate(empAsset); }
public void CheckinUpdate(List <Asset> assets) { try { using (AccetManagementEntities db = new AccetManagementEntities()) { foreach (var empDetails in assets) { //get the Asset table var assetTableData = db.ASSETs.Where(c => c.ASSETNO == empDetails.AssetNo).OrderBy(c => c.ASSETNO).ToList(); var results = db.ASSETs.SingleOrDefault(a => a.ASSETNO == empDetails.AssetNo); if (results != null) { results.CHECKOUTCOMMENT = empDetails.Comment; results.EMPNAME = ""; results.STATUSID = empDetails.StatusId; results.LOCATIONID = empDetails.LocationId; db.SaveChanges(); } } // db.EMPLOYEETABLEs.Add(employeeTable); } } catch (Exception) { throw; } //update the row }
public void SaveMember(List <Employee> empid) { try { using (AccetManagementEntities db = new AccetManagementEntities()) { foreach (var empDetails in empid) { employeeTable.EMPID = empDetails.EmpId; employeeTable.FNAME = empDetails.Fname; employeeTable.LNAME = empDetails.Lname; employeeTable.WORKPHONE = empDetails.Workno; employeeTable.MOBILEPHONE = empDetails.MobilePhone; employeeTable.EMAIL = empDetails.Email; employeeTable.STATUSID = empDetails.Statusid; employeeTable.GROUPID = empDetails.GROUPID; employeeTable.TITLEID = empDetails.TITLEID; employeeTable.IMAGEID = empDetails.IMAGEID; } db.EMPLOYEETABLEs.Add(employeeTable); db.SaveChanges(); } } catch (Exception) { throw; } }
private void RptAssignedUserControl_Load(object sender, EventArgs e) { using (AccetManagementEntities db = new AccetManagementEntities()) { rPTASSIGNEDALLASSETBindingSource.DataSource = db.RPTASSIGNEDALLASSETS.ToList(); } }
private void RptEmployeeUserControl_Load(object sender, EventArgs e) { using (AccetManagementEntities db = new AccetManagementEntities()) { vIEWALLEMPBindingSource.DataSource = db.VIEWALLEMPs.ToList(); } }
private void ToolStripBtnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure you want to delete this record?", "DELETE ASSET?", MessageBoxButtons.YesNo) == DialogResult.Yes) { var assno = Convert.ToString(this.dgvAllAssets.CurrentRow.Cells["ASSETNO"].Value); //delete image if any. DeleteImage(assno); //delete finance attatched to the asset DeleteAssetFinance(assno); using (AccetManagementEntities db = new AccetManagementEntities()) { var empname = db.VIEWALLASSETS.Where(x => x.ASSETNO == assno).Select(x => x.EMPNAME).FirstOrDefault(); if (empname == "" || empname == null) { int rows = dgvAllAssets.RowCount; for (int i = rows - 1; i >= 0; i--) { if (dgvAllAssets.Rows[i].Selected) { iEWALLASSET.ASSETNO = assno; iEWALLASSET = db.ASSETs.Where(x => x.ASSETNO == iEWALLASSET.ASSETNO).FirstOrDefault(); var entry = db.Entry(iEWALLASSET); if (entry.State == EntityState.Unchanged) { db.ASSETs.Attach(iEWALLASSET); db.ASSETs.Remove(iEWALLASSET); db.SaveChanges(); LoadGrid(); if (dgvAllAssets.CurrentRow == null) { MessageBox.Show("All Items deleted successfully"); } else { dgvAllAssets.Rows[0].Selected = false; } } //db.VIEWALLASSETS.Remove(dgvAllAssets.Rows[i].DataBoundItem as VIEWALLASSET); //vIEWALLASSETBindingSource.RemoveAt(dgvAllAssets.Rows[i].Index); } } } else { MessageBox.Show("This particular Item cannot be deleted because it's been assigned to an Employee " + empname + " CheckIn the Item first for it to be deleted"); } } } }
private void LoadGridView() { dgvSearch.DataSource = null; using (AccetManagementEntities db = new AccetManagementEntities()) { dgvSearch.AutoGenerateColumns = false; dgvSearch.DataSource = db.VIEWCHECKOUTsearches.ToList <VIEWCHECKOUTsearch>(); //db.VIEWCHECKOUTsearches.ToList<VIEWCHECKOUTsearches>(); } }
private void SaveCloseToolStripMenuItem_Click(object sender, EventArgs e) { var serial = userControl11.Controls.Find("txtserial", true); var status = userControl11.Controls.Find("cmBStatus", true); var condition = userControl11.Controls.Find("cmBCondition", true); var checkedOutto = userControl11.Controls.Find("txtcheckedOutto", true); var datepicker = userControl11.Controls.Find("dueDatepicker", true); var txtNotes = userControl11.Controls.Find("txtNotes", true); var r = condition[0].Text; var currentStatus = status[0].Text; try { using (AccetManagementEntities db = new AccetManagementEntities()) { var currentConditionId = db.CONDITIONs.Where(c => c.CONDITIONNAME == r).OrderBy(c => c.CONDITIONID).Select(c => c.CONDITIONID).ToList(); var assetId = db.ASSETTYPEs.Where(c => c.ASSETTYPE1 == cmBAssetType.Text).OrderBy(c => c.ASSETTYPEID).Select(c => c.ASSETTYPEID).ToList(); var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmBLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList(); var statusId = db.STATUS.Where(c => c.STATUSNAME == currentStatus).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); myAsset.ASSETNO = txtAssetNumber.Text.Trim(); myAsset.DESCRIPTION = txtDesription.Text.Trim(); myAsset.ASSETTYPEID = assetId[0]; myAsset.LOCATIONID = LocationId[0]; myAsset.MANUFACTURER = txtmanu.Text.Trim(); myAsset.BRAND = txtBrand.Text.Trim(); myAsset.MODEL = "NO MODEL YET"; myAsset.SERIALNUMBER = serial[0].Text; // data.serial; myAsset.STATUSID = statusId[0]; //data.statusId; myAsset.CONDITIONID = currentConditionId[0]; //data.conditionId; myAsset.EMPNAME = checkedOutto[0].Text.ToString().Trim(); // data.Emp; myAsset.DUEDATE = Convert.ToDateTime(datepicker[0].Text); myAsset.NOTES = txtNotes[0].Text.ToString().Trim(); myAsset.ASSETIMAGEID = 1; myAsset.CHECKOUTDATE = DateTime.Now; myAsset.CHECKOUTCOMMENT = ""; myAsset.EMPID = ""; myAsset.RECEIVEDDATE = DateTime.Now; db.ASSETs.Add(myAsset); db.SaveChanges(); this.Close(); MessageBox.Show("Saved Successfully to Database."); Application.Restart(); //Main newMain = new Main(); //newMain.ShowDialog(); } } catch (Exception ex) { MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex); //throw; } }
private void FormCheckin_Load(object sender, EventArgs e) { using (AccetManagementEntities db = new AccetManagementEntities()) { dgvCheckin.AutoGenerateColumns = false; //dgvChqInOut.DataSource = db.VIEWCHECKOUTsearches.ToList<VIEWCHECKOUTsearch>(); dgvCheckin.DataSource = db.VIEWEMPCHECKOUTLISTs.Where(a => a.EMPID == CommonData.PersonalNumber).ToList <VIEWEMPCHECKOUTLIST>(); } }
public void LoadDatagridView(List <string> assNo) { dgvItemsCheckedOut.DataSource = null; using (AccetManagementEntities db = new AccetManagementEntities()) { //dgvItemsCheckedOut.DataSource = db.VIEWCHECKOUTsearches.Where(e => assNo.Contains(e.ASSETNO)).ToList<VIEWCHECKOUTsearches>(); dgvItemsCheckedOut.DataSource = db.VIEWCHECKOUTsearches.Where(e => assNo.Contains(e.ASSETNO)).ToList <VIEWCHECKOUTsearch>(); } }
private void ToolStripButtonDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure you want to delete this record?", "DELETE VENDOR?", MessageBoxButtons.YesNo) == DialogResult.Yes) { var vendNo = Convert.ToString(this.dgvVendor.CurrentRow.Cells[1].Value); using (AccetManagementEntities db = new AccetManagementEntities()) { var getvendorFromDb = db.FINANCEs.Where(x => x.VENDORNO == vendNo).Select(x => x.VENDORNO).FirstOrDefault(); if (getvendorFromDb == null) { int rows = dgvVendor.RowCount; for (int i = rows - 1; i >= 0; i--) { if (dgvVendor.Rows[i].Selected) { VENDOR iVendor = new VENDOR { VENDORNO = vendNo }; iVendor = db.VENDORs.Where(x => x.VENDORNO == iVendor.VENDORNO).FirstOrDefault(); var entry = db.Entry(iVendor); if (entry.State == EntityState.Unchanged) { db.VENDORs.Attach(iVendor); db.VENDORs.Remove(iVendor); db.SaveChanges(); LoadGrid(); if (dgvVendor.CurrentRow == null) { MessageBox.Show("All Items deleted successfully"); } else { dgvVendor.Rows[0].Selected = false; } } //db.VIEWALLASSETS.Remove(dgvAllAssets.Rows[i].DataBoundItem as VIEWALLASSET); //vIEWALLASSETBindingSource.RemoveAt(dgvAllAssets.Rows[i].Index); } } } else { MessageBox.Show("Vendor is currently attached to an Asset"); } } } }
public void LoadGrid() { dgvAllAssets.DataSource = null; this.dgvAllAssets.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dgvAllAssets.MultiSelect = false; using (AccetManagementEntities db = new AccetManagementEntities()) { dgvAllAssets.AutoGenerateColumns = false; dgvAllAssets.DataSource = db.VIEWALLASSETS.ToList <VIEWALLASSET>(); } }
public void LoadGrid() { dgvEmployee.DataSource = null; using (AccetManagementEntities db = new AccetManagementEntities()) { dgvEmployee.AutoGenerateColumns = false; dgvEmployee.DataSource = db.VIEWALLEMPs.ToList <VIEWALLEMP>(); //this.dgvEmployee.SelectionMode = //DataGridViewSelectionMode.FullRowSelect; //this.dgvEmployee.MultiSelect = false; } }
public void LoadGrid() { dgvVendor.DataSource = null; this.dgvVendor.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dgvVendor.MultiSelect = false; using (AccetManagementEntities db = new AccetManagementEntities()) { dgvVendor.AutoGenerateColumns = false; dgvVendor.DataSource = db.VENDORs.ToList <VENDOR>(); } }
private void ToolStripButtonDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure you want to delete this record?", "DELETE EMPLOYEE?", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (AccetManagementEntities db = new AccetManagementEntities()) { EMPLOYEETABLE eMPLOYEETABLE = new EMPLOYEETABLE { EMPID = Convert.ToString(this.dgvEmployee.CurrentRow.Cells["EMPNUMBER"].Value) }; var empname = db.ASSETs.Where(x => x.EMPID == eMPLOYEETABLE.EMPID).Select(x => x.EMPNAME).FirstOrDefault(); if (empname == "" || empname == null) { int rows = dgvEmployee.RowCount; for (int i = rows - 1; i >= 0; i--) { if (dgvEmployee.Rows[i].Selected) { eMPLOYEETABLE = db.EMPLOYEETABLEs.Where(x => x.EMPID == eMPLOYEETABLE.EMPID).FirstOrDefault(); var entry = db.Entry(eMPLOYEETABLE); if (entry.State == EntityState.Unchanged) { db.EMPLOYEETABLEs.Attach(eMPLOYEETABLE); db.EMPLOYEETABLEs.Remove(eMPLOYEETABLE); db.SaveChanges(); LoadGrid(); if (dgvEmployee.CurrentRow == null) { MessageBox.Show("All Items deleted successfully"); } else { dgvEmployee.Rows[0].Selected = false; } } //db.VIEWALLASSETS.Remove(dgvAllAssets.Rows[i].DataBoundItem as VIEWALLASSET); //vIEWALLASSETBindingSource.RemoveAt(dgvAllAssets.Rows[i].Index); } } } else { MessageBox.Show("Employee Cannot be deleted because there is an asset attatched to " + empname); } } } }
private void BtnCompleteCheckout_Click(object sender, EventArgs e) { CHECKOUTIN choi = new CHECKOUTIN(); try { using (AccetManagementEntities db = new AccetManagementEntities()) { var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList(); // UPDATE ASSETS TABLE staId = statusId[0]; locId = LocationId[0]; UpdateAssetTable(); choi.EMPNAME = cmbCheckout.Text.ToString().Trim();// CommonData.Fname + " " + CommonData.Lname; choi.ASSETNO = this.dgvItemsCheckedOut.CurrentRow.Cells[1].Value.ToString(); choi.COMMENT = rctComment.Text.ToString(); choi.DUEDATE = Convert.ToDateTime(dtpDate.Text.ToString()); choi.STATUSID = statusId[0]; choi.LOCATIONID = LocationId[0]; choi.DESCRIPTION = this.dgvItemsCheckedOut.CurrentRow.Cells[0].Value.ToString(); choi.CHECKOUTDATE = DateTime.Now; choi.COMPNAME = Environment.MachineName; //choi.EMPID = CommonData.PersonalNumber; db.CHECKOUTINs.Add(choi); db.SaveChanges(); this.Close(); MessageBox.Show("Saved Successfully to Database."); Application.Restart(); //Main newMain = new Main(); //newMain.ShowDialog(); } } catch (Exception ex) { MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex); //throw; } }
void LoadCombobox() { //Clear combobox items first cmBAssetType.Items.Clear(); cmBLocation.Items.Clear(); //get the items from db using (AccetManagementEntities db = new AccetManagementEntities()) { var assettypequery = db.ASSETTYPEs .Select(e => e.ASSETTYPE1).ToList(); cmBAssetType.DataSource = assettypequery; var locationquery = db.LOCATIONs .Select(a => a.LOCATIONNAME).ToList(); cmBLocation.DataSource = locationquery; } }
private void LoadComboboxItems() { //Clear combobox items first cmbStatus.Items.Clear(); cmbLocation.Items.Clear(); //get the items from db using (AccetManagementEntities db = new AccetManagementEntities()) { var statusquery = db.STATUS .Select(a => a.STATUSNAME).ToList(); cmbStatus.DataSource = statusquery; var locationquery = db.LOCATIONs .Select(a => a.LOCATIONNAME).ToList(); cmbLocation.DataSource = locationquery; } }
public void populateControl(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { //var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList(); //var statusId = assDetails[0].STATUSID; //var dd = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList(); //var cond = assDetails[0].CONDITIONID; //var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList(); //txtserial.SelectedText = assDetails[0].SERIALNUMBER; //cmBStatus.Text = dd[0].ToString(); //txtcheckedOutto.Text = assDetails[0].EMPNAME; //dueDatepicker.Text = assDetails[0].DUEDATE.ToString(); //txtNotes.Text = assDetails[0].NOTES; } }
private void InsetCheckinTable() { CHECKOUTIN choi = new CHECKOUTIN(); try { using (AccetManagementEntities db = new AccetManagementEntities()) { var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList(); choi.EMPNAME = CommonData.Fname + " " + CommonData.Lname; choi.ASSETNO = this.dgvCheckin.CurrentRow.Cells[0].Value.ToString(); choi.COMMENT = richTextBoxComent.Text.ToString(); choi.DUEDATE = Convert.ToDateTime(this.dgvCheckin.CurrentRow.Cells[3].Value.ToString()); choi.STATUSID = statusId[0]; choi.LOCATIONID = LocationId[0]; choi.DESCRIPTION = this.dgvCheckin.CurrentRow.Cells[1].Value.ToString(); choi.CHECKOUTDATE = Convert.ToDateTime(this.dgvCheckin.CurrentRow.Cells[2].Value.ToString()); choi.COMPNAME = Environment.MachineName; choi.CHECKINDATE = DateTime.Now; //choi.EMPID = CommonData.PersonalNumber; db.CHECKOUTINs.Add(choi); db.SaveChanges(); this.Close(); MessageBox.Show("Saved Successfully to Database."); Application.Restart(); //Main newMain = new Main(); //newMain.ShowDialog(); } } catch (Exception ex) { MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex); //throw; } }
void LoadCombobox() { //Clear combobox items first // cmdDepreciation.Items.Clear(); cmdVendor.Items.Clear(); //get the items from db using (AccetManagementEntities db = new AccetManagementEntities()) { //var depquery = db.Depreciations // .Select(e => e.DepresiationName).ToList(); //cmdDepreciation.DataSource = depquery; //TO DO: ONCE DONE WITH VENDOR PAGE, LOAD VENDORS HERE var vendorName = db.VENDORs .Select(a => a.VENDORNAME).ToList(); cmdVendor.DataSource = vendorName; } }
private void DeleteImage(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { ASSETIMAGE aSSETIMAGE = new ASSETIMAGE(); var assImage = db.ASSETIMAGEs.SingleOrDefault(x => x.ASSETID == assno); aSSETIMAGE = db.ASSETIMAGEs.Where(x => x.ASSETID == assno).FirstOrDefault(); if (aSSETIMAGE != null) { var entry = db.Entry(aSSETIMAGE); if (entry.State == EntityState.Unchanged) { db.ASSETIMAGEs.Attach(aSSETIMAGE); db.ASSETIMAGEs.Remove(aSSETIMAGE); db.SaveChanges(); } } } }
internal void PopulateControls(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { var financeTableData = db.FINANCEs.SingleOrDefault(c => c.ASSETNO == assno); var vendorId = db.VENDORs.Where(e => e.VENDORNO == financeTableData.VENDORNO).ToList(); Finances.VendorName = vendorId[0].VENDORNAME; Finances.TxtPoNumber = financeTableData.PONO; cmdVendor.Text = Finances.VendorName; txtPoNumber.Text = Finances.TxtPoNumber; recPeriod.Value = financeTableData.RECOVERYPERIOD; txtPurchasePrice.Text = financeTableData.PURCHASEPRICE.ToString(); txtMarketVlaue.Text = financeTableData.MARKETVALUE.ToString(); txtScrapValue.Text = financeTableData.SCRAPEVALUE.ToString(); dtpPurchase.Value = financeTableData.PURCHASEDATE; dtpWarranty.Value = financeTableData.WARRANTYEND; dtpService.Value = financeTableData.INSERVICEDATE; } }
private void DeleteAssetFinance(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { FINANCE aFinance = new FINANCE(); //var assFinance = db.FINANCEs.SingleOrDefault(x => x.ASSETNO == assno); aFinance = db.FINANCEs.SingleOrDefault(x => x.ASSETNO == assno); //db.ASSETIMAGEs.Where(x => x.ASSETID == assno).FirstOrDefault(); if (aFinance != null) { var entry = db.Entry(aFinance); if (entry.State == EntityState.Unchanged) { db.FINANCEs.Attach(aFinance); db.FINANCEs.Remove(aFinance); db.SaveChanges(); } } } }
void LoadCombobox() { //Clear combobox items first cmBStatus.Items.Clear(); cmBCondition.Items.Clear(); //get the items from db using (AccetManagementEntities db = new AccetManagementEntities()) { var statusquery = db.STATUS .Select(e => e.STATUSNAME).ToList(); cmBStatus.DataSource = statusquery; var locationquery = db.CONDITIONs .Select(a => a.CONDITIONNAME).ToList(); cmBCondition.DataSource = locationquery; } if (txtcheckedOutto.Text == " ") { btnUser.Enabled = false; } }
internal void PopulateControls(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList(); var assetId = assDetails[0].ASSETTYPEID; var dd = db.ASSETTYPEs.Where(e => e.ASSETTYPEID == assetId).Select(e => e.ASSETTYPE1).ToList(); var loc = assDetails[0].LOCATIONID; var ddLoc = db.LOCATIONs.Where(e => e.LOCATIONID == loc).Select(e => e.LOCATIONNAME).ToList(); var statusId = assDetails[0].STATUSID; var ddsi = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList(); var cond = assDetails[0].CONDITIONID; var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList(); txtDesription.Text = assDetails[0].DESCRIPTION; cmBAssetType.Text = dd[0].ToString(); cmBLocation.Text = ddLoc[0].ToString(); txtmanu.Text = assDetails[0].MANUFACTURER; txtBrand.Text = assDetails[0].BRAND; txtAssetNumber.Text = assDetails[0].ASSETNO; //userControl11.txtserial.Text = assDetails[0].SERIALNUMBER; //userControl11.cmBStatus.Text = ddsi[0].ToString(); //userControl11.cmBCondition.Text = ddCon[0].ToString(); //userControl11.txtcheckedOutto.Text = assDetails[0].EMPNAME.ToString(); //userControl11.dueDatepicker.Text = assDetails[0].DUEDATE.ToString(); //userControl11.txtNotes.Text = assDetails[0].NOTES; //this.userControl11.Show(); //userControl11.BringToFront(); } }
private void SaveCloseToolStripMenuItem_Click_1(object sender, EventArgs e) { UserControlFinance userControlFinance = new UserControlFinance(); var serial = userControl11.Controls.Find("txtserial", true); var status = userControl11.Controls.Find("cmBStatus", true); var condition = userControl11.Controls.Find("cmBCondition", true); var checkedOutto = userControl11.Controls.Find("txtcheckedOutto", true); var datepicker = userControl11.Controls.Find("dueDatepicker", true); var txtNotes = userControl11.Controls.Find("txtNotes", true); var r = condition[0].Text; var currentStatus = status[0].Text; var assetImage = userControl11.pictureBox1; try { using (AccetManagementEntities db = new AccetManagementEntities()) { var currentConditionId = db.CONDITIONs.Where(c => c.CONDITIONNAME == r).OrderBy(c => c.CONDITIONID).Select(c => c.CONDITIONID).ToList(); var assetId = db.ASSETTYPEs.Where(c => c.ASSETTYPE1 == cmBAssetType.Text).OrderBy(c => c.ASSETTYPEID).Select(c => c.ASSETTYPEID).ToList(); var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmBLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList(); var statusId = db.STATUS.Where(c => c.STATUSNAME == currentStatus).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); var aSSETs = txtAssetNumber.Text.Trim().ToString(); var assetTableData = db.ASSETs.SingleOrDefault(c => c.ASSETNO == aSSETs); if (assetTableData == null) { userControlFinance.GetControls(txtAssetNumber.Text.Trim()); myAsset.ASSETNO = txtAssetNumber.Text.Trim(); myAsset.DESCRIPTION = txtDesription.Text.Trim(); myAsset.ASSETTYPEID = assetId[0]; myAsset.LOCATIONID = LocationId[0]; myAsset.MANUFACTURER = txtmanu.Text.Trim(); myAsset.BRAND = txtBrand.Text.Trim(); myAsset.MODEL = "NO MODEL YET"; myAsset.SERIALNUMBER = serial[0].Text; // data.serial; myAsset.STATUSID = statusId[0]; //data.statusId; myAsset.CONDITIONID = currentConditionId[0]; //data.conditionId; myAsset.EMPNAME = checkedOutto[0].Text.ToString().Trim(); // data.Emp; myAsset.DUEDATE = Convert.ToDateTime(datepicker[0].Text); myAsset.NOTES = txtNotes[0].Text.ToString().Trim(); myAsset.ASSETIMAGEID = 1; myAsset.CHECKOUTDATE = DateTime.Now; myAsset.CHECKOUTCOMMENT = ""; myAsset.EMPID = ""; myAsset.RECEIVEDDATE = DateTime.Now; db.ASSETs.Add(myAsset); //save Picture if (pictureBox1.Image != null) { ASSETIMAGE aSSETIMAGE = new ASSETIMAGE { ASSETID = aSSETs, ASSETIMAGEID = 1, Filepath = CommonData.Filename ?? "" }; db.ASSETIMAGEs.Add(aSSETIMAGE); } } else { // check whether userImage is in the database var assImage = db.ASSETIMAGEs.SingleOrDefault(x => x.ASSETID == aSSETs); string fileNamePth = CommonData.Filename ?? ""; if (assImage == null) { if (pictureBox1.Image != null) { ASSETIMAGE aSSETIMAGE = new ASSETIMAGE { ASSETID = aSSETs, ASSETIMAGEID = 1, Filepath = fileNamePth }; db.ASSETIMAGEs.Add(aSSETIMAGE); } } else { assImage.ASSETIMAGEID = 1; assImage.ASSETID = aSSETs; assImage.Filepath = fileNamePth; } //save finances changes first userControlFinance.GetControls(txtAssetNumber.Text.Trim()); assetTableData.ASSETNO = txtAssetNumber.Text.Trim(); assetTableData.DESCRIPTION = txtDesription.Text.Trim(); assetTableData.ASSETTYPEID = assetId[0]; assetTableData.LOCATIONID = LocationId[0]; assetTableData.MANUFACTURER = txtmanu.Text.Trim(); assetTableData.BRAND = txtBrand.Text.Trim(); assetTableData.MODEL = "NO MODEL YET"; assetTableData.SERIALNUMBER = serial[0].Text; // data.serial; assetTableData.STATUSID = statusId[0]; //data.statusId; assetTableData.CONDITIONID = currentConditionId[0]; //data.conditionId; assetTableData.EMPNAME = checkedOutto[0].Text.ToString().Trim(); // data.Emp; assetTableData.DUEDATE = Convert.ToDateTime(datepicker[0].Text); assetTableData.NOTES = txtNotes[0].Text.ToString().Trim(); assetTableData.ASSETIMAGEID = 1; assetTableData.CHECKOUTDATE = DateTime.Now; assetTableData.CHECKOUTCOMMENT = ""; assetTableData.EMPID = ""; assetTableData.RECEIVEDDATE = DateTime.Now; } db.SaveChanges(); this.Close(); MessageBox.Show("Saved Successfully to Database."); Application.Restart(); //Main newMain = new Main(); //newMain.ShowDialog(); } } catch (Exception ex) { MessageBox.Show("Invalid entry. Ensure you do not repeat the same entry on AssetNo" + ex); //throw; } }
internal void PopulateControls(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList(); var assetId = assDetails[0].ASSETTYPEID; var dd = db.ASSETTYPEs.Where(e => e.ASSETTYPEID == assetId).Select(e => e.ASSETTYPE1).ToList(); var loc = assDetails[0].LOCATIONID; var ddLoc = db.LOCATIONs.Where(e => e.LOCATIONID == loc).Select(e => e.LOCATIONNAME).ToList(); var statusId = assDetails[0].STATUSID; var ddsi = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList(); var cond = assDetails[0].CONDITIONID; var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList(); txtDesription.Text = assDetails[0].DESCRIPTION; cmBAssetType.Text = dd[0].ToString(); cmBLocation.Text = ddLoc[0].ToString(); txtmanu.Text = assDetails[0].MANUFACTURER; txtBrand.Text = assDetails[0].BRAND; txtAssetNumber.Text = assDetails[0].ASSETNO; userControl11.txtserial.Text = assDetails[0].SERIALNUMBER; userControl11.cmBStatus.Text = ddsi[0].ToString(); userControl11.cmBCondition.Text = ddCon[0].ToString(); userControl11.txtcheckedOutto.Text = assDetails[0].EMPNAME.ToString(); userControl11.dueDatepicker.Text = assDetails[0].DUEDATE.ToString(); userControl11.txtNotes.Text = assDetails[0].NOTES; this.Text = "Edit Asset " + assDetails[0].ASSETNO; var er = userControlFinance1.Controls.Find("txtPoNumber", true); var financeTableData = db.FINANCEs.SingleOrDefault(c => c.ASSETNO == assno); if (financeTableData != null) { if (financeTableData.VENDORNO != "") { var vendorId = db.VENDORs.Where(e => e.VENDORNO == financeTableData.VENDORNO).ToList(); userControlFinance1.txtPoNumber.Text = financeTableData.PONO; userControlFinance1.cmdVendor.Text = vendorId[0].VENDORNAME; userControlFinance1.recPeriod.Value = financeTableData.RECOVERYPERIOD; userControlFinance1.txtPurchasePrice.Text = financeTableData.PURCHASEPRICE.ToString(); userControlFinance1.txtScrapValue.Text = financeTableData.SCRAPEVALUE.ToString(); userControlFinance1.txtMarketVlaue.Text = financeTableData.MARKETVALUE.ToString(); userControlFinance1.dtpPurchase.Value = financeTableData.PURCHASEDATE; userControlFinance1.dtpWarranty.Value = financeTableData.WARRANTYEND; userControlFinance1.dtpService.Value = financeTableData.INSERVICEDATE; } } CommonData.SelectedEmpId = assDetails[0].EMPID; //picture string fileName = db.ASSETIMAGEs.Where(f => f.ASSETID == assno).Select(f => f.Filepath).FirstOrDefault(); if (fileName != null && fileName != "") { userControl11.pictureBox1.Image = UserControl1.ResizeImage(Image.FromFile(fileName), this.Width, this.Height); } else { } } }