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; } } }