private void FillScannerConfigDetl() { objFixedAsssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); try { if (cbSystemID.SelectedIndex > 0) { dt = objFixedAsssetDB.GetScannerConfigurationID(cbBranch.SelectedValue.ToString()).Tables[0]; } if (dt.Rows.Count > 0) { DataRow dr = dt.NewRow(); dr[0] = "--Select--"; dt.Rows.InsertAt(dr, 0); cbScanner.DataSource = dt; cbScanner.DisplayMember = "DisplayMember"; cbScanner.ValueMember = "ValueMember"; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objDb = null; dt = null; } }
private void FillEmployeeDetails() { objFixedAsssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); try { if (cbSystemID.SelectedIndex > 0) { dt = objFixedAsssetDB.GetAssetSlNos("", cbSystemID.SelectedValue.ToString()).Tables[0]; if (dt.Rows.Count > 0) { txtEmpName.Text = dt.Rows[0]["EmpName"].ToString(); txtMobileNo.Text = dt.Rows[0]["ContactNo"].ToString(); txtAssetTagNo.Text = dt.Rows[0]["TagNo"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objFixedAsssetDB = null; dt = null; } }
private void FillAssetConfigDetails() { objAssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); dtConfigDetl.Rows.Clear(); try { dt = objAssetDB.GetFixedAssetsConfigurationDetails(txtAssetSLNo.Text.ToString()).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { dtConfigDetl.Rows.Add(new object[] { "-1", dt.Rows[i]["Config_AssetId"].ToString(), dt.Rows[i]["Config_Capacity"].ToString(), dt.Rows[i]["Config_Type"].ToString(), dt.Rows[i]["Config_Make"].ToString(), dt.Rows[i]["Config_Model"].ToString(), dt.Rows[i]["Config_Qty"].ToString() }); GetAssetConfigDetails(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void FillSystemID() { objFixedAsssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); cbSystemID.DataSource = null; try { if (cbBranch.SelectedIndex > 0) { dt = objFixedAsssetDB.GetAssetSlNos(cbBranch.SelectedValue.ToString(), "").Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.NewRow(); dr[0] = "--Select--"; dt.Rows.InsertAt(dr, 0); cbSystemID.DataSource = dt; cbSystemID.DisplayMember = "DisplayMember"; cbSystemID.ValueMember = "ValueMember"; } else { cbSystemID.SelectedIndex = -1; cbMoniter.SelectedIndex = -1; cbMotherboard.SelectedIndex = -1; cbPrinter.SelectedIndex = -1; cbProcesor.SelectedIndex = -1; cbRAM.SelectedIndex = -1; cbScanner.SelectedIndex = -1; cbHDD.SelectedIndex = -1; cbDVDorCD.SelectedIndex = -1; cbWebCam.SelectedIndex = -1; cbBiometrcs.SelectedIndex = -1; cbOperatingSys.SelectedIndex = -1; cbAntivirus.SelectedIndex = -1; txtEmpName.Text = ""; txtMobileNo.Text = ""; txtAssetTagNo.Text = ""; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objDb = null; dt = null; } }
private void GetPreviousServiceDetails() { objAssetdb = new FixedAssetsDB(); DataTable dt = new DataTable(); gvAssetServiceDetails.Rows.Clear(); //string CompCode = cbCompany.SelectedValue.ToString(); //string BranCode = cbBranch.SelectedValue.ToString(); //string AssetType = cbAssetType.SelectedValue.ToString(); if (cbAssetId.SelectedIndex > 0) { try { dt = objAssetdb.GetFixedAssetsServiceDetails(cbAssetId.SelectedValue.ToString()).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { gvAssetServiceDetails.Rows.Add(); gvAssetServiceDetails.Rows[i].Cells["SLNO"].Value = (i + 1).ToString(); gvAssetServiceDetails.Rows[i].Cells["TransactionNo"].Value = dt.Rows[i]["ServiceTrnNo"].ToString(); gvAssetServiceDetails.Rows[i].Cells["AssetId"].Value = dt.Rows[i]["AssetSLNO"].ToString(); gvAssetServiceDetails.Rows[i].Cells["AssetType"].Value = dt.Rows[i]["AssetType"].ToString(); gvAssetServiceDetails.Rows[i].Cells["ServiceType"].Value = dt.Rows[i]["ServiceType"].ToString(); gvAssetServiceDetails.Rows[i].Cells["ServiceDate"].Value = Convert.ToDateTime(dt.Rows[i]["ServiceDate"].ToString()).ToString("dd/MMM/yyyy"); gvAssetServiceDetails.Rows[i].Cells["ServiceCost"].Value = dt.Rows[i]["ServiceCost"].ToString(); gvAssetServiceDetails.Rows[i].Cells["ServiceRemarks"].Value = dt.Rows[i]["ServiceRemarks"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objAssetdb = null; dt = null; } } }
private void FillSystemConfigurationDetails() { objFixedAsssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); try { dt = objFixedAsssetDB.GetSystemConfigDtails(cbSystemID.SelectedValue.ToString()).Tables[0]; if (dt.Rows.Count > 0) { flagUpdate = true; cbRAM.SelectedValue = dt.Rows[0]["Ram"].ToString(); cbHDD.SelectedValue = dt.Rows[0]["HDD"].ToString(); cbProcesor.SelectedValue = dt.Rows[0]["Processor"].ToString(); cbMotherboard.SelectedValue = dt.Rows[0]["MotherBoard"].ToString(); cbMoniter.SelectedValue = dt.Rows[0]["Moniter"].ToString(); cbDVDorCD.SelectedValue = dt.Rows[0]["CDorDvd"].ToString(); cbPrinter.SelectedValue = dt.Rows[0]["PrinterId"].ToString(); cbScanner.SelectedValue = dt.Rows[0]["ScannerId"].ToString(); cbBiometrcs.SelectedValue = dt.Rows[0]["BioMetricss"].ToString(); cbWebCam.SelectedValue = dt.Rows[0]["WebCam"].ToString(); cbOperatingSys.SelectedValue = dt.Rows[0]["OperatindSys"].ToString(); cbAntivirus.SelectedValue = dt.Rows[0]["Antivirus"].ToString(); } else { flagUpdate = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objDb = null; dt = null; } }
private void FillAssetsDetails() { objFixedAssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); if (txtAssetSLNo.Text != "") { try { dt = objFixedAssetDB.GetFixedAssetsData(txtAssetSLNo.Text.ToString()).Tables[0]; if (dt.Rows.Count > 0) { flagUpdate = true; //txtAssetTagNo.ReadOnly = true; //txtAssetCost.ReadOnly = true; //dtpGivenDate.Enabled = false; cbToComp.Enabled = false; cbToBranch.Enabled = false; //txtEcode.ReadOnly = true; txtAssetSLNo.Tag = dt.Rows[0]["AssetId"].ToString(); cbAssetType.SelectedValue = dt.Rows[0]["Asset_Type"].ToString(); cbAssetMake.SelectedValue = dt.Rows[0]["Asset_Make"].ToString(); cbAssetModel.SelectedValue = dt.Rows[0]["Asset_Model"].ToString(); dtpGivenDate.Value = Convert.ToDateTime(dt.Rows[0]["Given_Date"].ToString()); cbStatus.SelectedItem = dt.Rows[0]["Status"].ToString(); txtAssetTagNo.Text = dt.Rows[0]["TagNo"].ToString(); txtAssetCost.Text = dt.Rows[0]["AssetCost"].ToString(); AssetMovementId = Convert.ToInt32(dt.Rows[0]["Movement_Id"].ToString()); TrnNo = Convert.ToInt32(dt.Rows[0]["Trn_No"].ToString()); if (dt.Rows[0]["Trn_Type"].ToString().Equals("BR2GC")) { cbTrnType.Text = "BR2EMPLOYEE"; } else { cbTrnType.Text = dt.Rows[0]["Trn_Type"].ToString(); } cbToComp.SelectedValue = dt.Rows[0]["AtComp"].ToString(); cbToBranch.SelectedValue = dt.Rows[0]["AtBranch"].ToString(); txtDept.Text = dt.Rows[0]["DeptName"].ToString(); txtDesig.Text = dt.Rows[0]["DesigName"].ToString(); txtContactNo.Text = dt.Rows[0]["ContNo"].ToString(); string ToEcode = dt.Rows[0]["To_Ecode"].ToString(); txtEcode.Text = ToEcode; txtEcode_KeyUp(null, null); if (txtContactNo.Text.Length == 0) { txtContactNo.Text = dt.Rows[0]["ContNo"].ToString(); } } else if (dt.Rows.Count == 0) { GenerateAssetSLNo(); flagUpdate = false; isDetlUpdate = false; TrnNo = 0; AssetMovementId = 0; dtpGivenDate.Value = DateTime.Today; cbToComp.SelectedIndex = 0; cbToBranch.SelectedIndex = -1; txtEcode.Text = ""; txtEName.Text = ""; cbAssetType.SelectedIndex = 0; cbAssetModel.SelectedIndex = -1; cbAssetMake.SelectedIndex = -1; cbStatus.SelectedIndex = 0; txtDesig.Text = ""; txtDept.Text = ""; dtpGivenDate.Enabled = true; cbToComp.Enabled = true; cbToBranch.Enabled = true; txtEcode.ReadOnly = false; txtAssetTagNo.ReadOnly = false; txtAssetCost.ReadOnly = false; txtAssetTagNo.Text = ""; txtAssetCost.Text = ""; cbTrnType.SelectedIndex = 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objFixedAssetDB = null; dt = null; } } }
private void FillAssetsDetails() { objAssetDB = new FixedAssetsDB(); DataTable dt = new DataTable(); if (txtAssetSLNo.Text != "") { try { dt = objAssetDB.GetFixedAssetsData(txtAssetSLNo.Text.ToString()).Tables[0]; if (dt.Rows.Count > 0) { isHeadUpdate = true; cbAssetType.Enabled = false; cbAssetMake.Enabled = false; cbAssetModel.Enabled = false; cbSupplier.Enabled = false; dtpPurchaseDate.Enabled = false; txtAssetTagNo.ReadOnly = true; txtAssetCost.ReadOnly = true; dtpGivenDate.Enabled = false; cbToComp.Enabled = false; cbToBranch.Enabled = false; txtToEcode.ReadOnly = true; cbTrnType.Enabled = false; txtAssetSLNo.Tag = dt.Rows[0]["AssetId"].ToString(); cbAssetType.SelectedValue = dt.Rows[0]["Asset_Type"].ToString(); cbAssetMake.SelectedValue = dt.Rows[0]["Asset_Make"].ToString(); cbAssetModel.SelectedValue = dt.Rows[0]["Asset_Model"].ToString(); cbSupplier.SelectedValue = dt.Rows[0]["Supplier_Id"].ToString(); if (dt.Rows[0]["Purchase_Date"].ToString().Length > 0) { dtpPurchaseDate.Value = Convert.ToDateTime(dt.Rows[0]["Purchase_Date"]); } dtpGivenDate.Value = Convert.ToDateTime(dt.Rows[0]["Given_Date"].ToString()); cbStatus.SelectedItem = dt.Rows[0]["Status"].ToString(); AssetMovementId = Convert.ToInt32(dt.Rows[0]["Movement_Id"].ToString()); txtAssetTagNo.Text = dt.Rows[0]["TagNo"].ToString(); txtAssetCost.Text = dt.Rows[0]["AssetCost"].ToString(); TrnNo = Convert.ToInt32(dt.Rows[0]["Trn_No"].ToString()); if (dt.Rows[0]["Trn_Type"].ToString().Equals("BR2GC")) { cbTrnType.Text = "BR2EMPLOYEE"; } else { cbTrnType.Text = dt.Rows[0]["Trn_Type"].ToString(); } cbToComp.Text = dt.Rows[0]["To_Comp_Name"].ToString(); cbToBranch.SelectedValue = dt.Rows[0]["To_Branch"].ToString(); string ToEcode = dt.Rows[0]["To_Ecode"].ToString(); if (ToEcode.Length > 3) { txtToEcode.Text = ToEcode; } } else if (dt.Rows.Count == 0) { isHeadUpdate = false; isDetlUpdate = false; //cbAssetType.SelectedIndex = 0; GenerateAssetSLNo(); //cbAssetMake.SelectedIndex = -1; //cbAssetModel.SelectedIndex = -1; cbSupplier.SelectedIndex = 0; dtpPurchaseDate.Value = DateTime.Today; dtpGivenDate.Value = DateTime.Today; cbTrnType.SelectedIndex = 0; cbToComp.SelectedIndex = 0; cbToBranch.SelectedIndex = -1; txtToEcode.Text = ""; txtToEName.Text = ""; dtConfigDetl.Rows.Clear(); gvAssetConfigDetails.Rows.Clear(); cbStatus.SelectedIndex = 0; cbAssetType.Enabled = true; cbAssetMake.Enabled = true; cbAssetModel.Enabled = true; cbSupplier.Enabled = true; dtpPurchaseDate.Enabled = true; cbTrnType.Enabled = true; dtpGivenDate.Enabled = true; cbToComp.Enabled = true; cbToBranch.Enabled = true; txtToEcode.ReadOnly = false; txtAssetTagNo.ReadOnly = false; txtAssetCost.ReadOnly = false; txtAssetTagNo.Text = ""; txtAssetCost.Text = ""; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objAssetDB = null; dt = null; } } }