private void func_Get_EUL_Id() { //Close existing connection SysCon.CloseConnection(); string EUL = "Select pk_EUL_Id from tbl_Estimated_Useful_Life where EUL_Name = '" + cboEUL.Text + "'"; SysCon.SystemConnect.Open(); //Get ID from EUL table SqlCommand SelectEUL_Id = new SqlCommand(EUL, SysCon.SystemConnect); SqlDataReader EULIdReader = SelectEUL_Id.ExecuteReader(); EULIdReader.Read(); EUL_Id = EULIdReader[0].ToString(); EULIdReader.Close(); EULIdReader.Dispose(); //Close connection SysCon.SystemConnect.Close(); // MessageBox.Show(EUL_Id); }
private void func_Delete_Category() { try { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); //execute deletion SqlCommand DeleteCategory = new SqlCommand(); DeleteCategory.CommandText = "Delete from tbl_Category where pk_Category_Id = '" + GlobalClass.GlobalCategoryId + "'"; DeleteCategory.CommandType = CommandType.Text; DeleteCategory.Connection = SysCon.SystemConnect; DeleteCategory.ExecuteNonQuery(); MessageBox.Show("Category has been successfully deleted!", "Delete Category", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); //Insert Activity to audit trail string user = "******" + GlobalClass.GlobalName + "', '" + GlobalClass.GlobalUser + "', '" + DateTime.Now.ToString() + "', 'Delete Category Name = ' + '" + txtCategoryName.Text + "'+ ' ; Code = '+ '" + txtCode.Text + "')"; SqlCommand AuditTrail = new SqlCommand(user, SysCon.SystemConnect); AuditTrail.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException) { MessageBox.Show("This data cannot be deleted due to some dependency issue. \nPlease contact the System Administrator for assistance.", "Delete Category", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void func_Add_Category() { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string NewCategory = "Insert into tbl_Category (Category_Code,Category_Name) Values('" + txtCode.Text + "', '" + txtCategoryName.Text + "')"; SqlCommand AddNewCategory = new SqlCommand(NewCategory, SysCon.SystemConnect); AddNewCategory.ExecuteNonQuery(); MessageBox.Show("New category has been successfully added!", "Add Category", MessageBoxButtons.OK, MessageBoxIcon.Information); //Insert Activity to audit trail string user = "******" + GlobalClass.GlobalName + "', '" + GlobalClass.GlobalUser + "', '" + DateTime.Now.ToString() + "', 'Add New Category Name = ' + '" + txtCategoryName.Text + "'+ ' ; Code = '+ '" + txtCode.Text + "')"; SqlCommand AuditTrail = new SqlCommand(user, SysCon.SystemConnect); AuditTrail.ExecuteNonQuery(); //Close Connection SysCon.SystemConnect.Close(); func_Reset(); }
private void func_Load_All_Services() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllServices = "Select * from tbl_Services"; SqlDataAdapter AllServicesAdapter = new SqlDataAdapter(AllServices, SysCon.SystemConnect); string srctbl = "tbl_Services"; DataSet ServicesData = new DataSet(); AllServicesAdapter.Fill(ServicesData, srctbl); dgvServices.DataSource = ServicesData.Tables["tbl_Services"]; dgvServices.RowHeadersWidth = 5; dgvServices.Columns[0].Visible = false; dgvServices.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_Load_All_Items() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllExItems = "Select pk_Id,Description,Serial_No,Old_Property_No,Status from view_Inventory_Details where (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier')"; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllExItems, SysCon.SystemConnect); string srctbl = "view_Inventory_Details"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Inventory_Details"]; dgvItems.RowHeadersWidth = 5; dgvItems.Columns[0].Visible = false; dgvItems.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); lblcount.Text = dgvItems.RowCount.ToString(); }
private void func_Load_All_Supplier() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllSupplier = "Select * from view_CatSupplier"; SqlDataAdapter AllCategoriesAdapter = new SqlDataAdapter(AllSupplier, SysCon.SystemConnect); string srctbl = "view_CatSupplier"; DataSet SupplierData = new DataSet(); AllCategoriesAdapter.Fill(SupplierData, srctbl); dgvSupplier.DataSource = SupplierData.Tables["view_CatSupplier"]; dgvSupplier.RowHeadersWidth = 5; dgvSupplier.Columns[0].Visible = false; dgvSupplier.Columns[1].Visible = false; dgvSupplier.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_Load_Disposal_History() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllExItems = "Select Description,Unit_Cost,Property_No,Serial_No,Date_Acquired,Mode_of_Disposal,Reason_For_Transfer,Date_Transferred,Recipient,Document_No from view_Disposal_Record"; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllExItems, SysCon.SystemConnect); string srctbl = "view_Disposal_Record"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Disposal_Record"]; dgvItems.RowHeadersWidth = 5; //dgvItems.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); lblcount.Text = dgvItems.RowCount.ToString(); }
private void func_Load_All_Items() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllExItems = "Select * from view_Existing_Items_Details where (Status = 'FOR ASSIGNMENT' or Status = 'FOR REASSIGNMENT') "; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllExItems, SysCon.SystemConnect); string srctbl = "view_Existing_Items_Details"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Existing_Items_Details"]; dgvItems.RowHeadersWidth = 5; dgvItems.Columns[0].Visible = false; dgvItems.Columns[1].Visible = false; dgvItems.Columns[2].Visible = false; dgvItems.Columns[3].Visible = false; dgvItems.Columns[4].Visible = false; dgvItems.Columns[5].Visible = false; dgvItems.Columns[6].Visible = false; dgvItems.Columns[7].Visible = false; dgvItems.Columns[8].Visible = false; SysCon.SystemConnect.Close(); }
private void func_Load_Inv_Items_Per_Service() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllExItems = "Select pk_Id,[Accountable Officer],[End User], Unit , Description, UOM, Old_Property_No,New_Property_No, Unit_Cost, Status, Location_Name, Inventory_Date, Remarks from view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier')"; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllExItems, SysCon.SystemConnect); string srctbl = "view_Inventory_Details"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Inventory_Details"]; dgvItems.RowHeadersWidth = 5; dgvItems.Columns[0].Visible = false; // dgvItems.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_Add_ESL() { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string NewESL = "Insert into tbl_Estimated_Useful_Life (EUL_Name) Values('" + txtESLDesc.Text + "')"; SqlCommand AddNewESL = new SqlCommand(NewESL, SysCon.SystemConnect); AddNewESL.ExecuteNonQuery(); MessageBox.Show("New EUL has been successfully added!", "Add ESL", MessageBoxButtons.OK, MessageBoxIcon.Information); //Insert Activity to audit trail string user = "******" + GlobalClass.GlobalName + "', '" + GlobalClass.GlobalUser + "', '" + DateTime.Now.ToString() + "', 'Add New ESL = ' + '" + txtESLDesc.Text + "'+ ' ; Id = '+ '" + ESLId + "')"; SqlCommand AuditTrail = new SqlCommand(user, SysCon.SystemConnect); AuditTrail.ExecuteNonQuery(); //Close Connection SysCon.SystemConnect.Close(); func_Reset(); func_Load_All_ESL(); }
private void func_Check_Duplication_UpdEUL() { if (ESLDesc != txtESLDesc.Text) { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string CheckDuplication_ESL = "Select EUL_Name from tbl_Estimated_Useful_Life where EUL_Name ='" + txtESLDesc.Text + "'"; SqlCommand CheckDuplicateESLCommand = new SqlCommand(CheckDuplication_ESL, SysCon.SystemConnect); SqlDataReader ESLReader = CheckDuplicateESLCommand.ExecuteReader(); if (ESLReader.Read()) { MessageBox.Show("EUL already exists!", "EUL", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtESLDesc.Focus(); return; } else { func_Update_EUL(); } ESLReader.Close(); ESLReader.Dispose(); } else { MessageBox.Show("No changes has been made!"); func_Reset(); } }
private void func_Check_Duplication_AddEUL() { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string CheckDuplication = "Select EUL_Name from tbl_Estimated_Useful_Life where EUL_Name ='" + txtESLDesc.Text + "'"; SqlCommand CheckRecordCommand = new SqlCommand(CheckDuplication, SysCon.SystemConnect); SqlDataReader CReader = CheckRecordCommand.ExecuteReader(); if (CReader.Read()) { MessageBox.Show("EUL already exists!", "New EUL", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtESLDesc.Focus(); return; } else { func_Add_ESL(); } CReader.Close(); CReader.Dispose(); }
private void func_Update_Password() { string UpdateRecord = "Update tbl_System_Users Set Password = '******' where User_Name = '" + GlobalClass.GlobalUser + "'"; //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); //execute query SqlCommand UpdateUser = new SqlCommand(); UpdateUser.CommandType = CommandType.Text; UpdateUser.CommandText = UpdateRecord; UpdateUser.Connection = SysCon.SystemConnect; UpdateUser.ExecuteNonQuery(); //Insert Activity to audit trail string user = "******" + GlobalClass.GlobalName + "', '" + GlobalClass.GlobalUser + "', '" + DateTime.Now.ToString() + "', 'Update Password , User = '******'" + GlobalClass.GlobalUser + "' )"; SqlCommand AuditTrail = new SqlCommand(user, SysCon.SystemConnect); AuditTrail.ExecuteNonQuery(); //close connection SysCon.SystemConnect.Close(); MessageBox.Show("User password has been successfully changed!", "Change Password", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void func_Validate_Password() { string UserAccount = "Select * from tbl_System_Users where User_Name = '" + GlobalClass.GlobalUser + "' and Password = '******' "; //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); SqlCommand SearchAccount = new SqlCommand(UserAccount, SysCon.SystemConnect); SqlDataReader AccountReader = SearchAccount.ExecuteReader(); //Check account if existing if (AccountReader.Read()) { func_Encrypt_NewPassword(); func_Update_Password(); func_Reset(); } else { MessageBox.Show("The old password you supply is incorrect "); } AccountReader.Close(); AccountReader.Dispose(); //Close Connection SysCon.SystemConnect.Close(); }
private void func_LoadLocationData() { string LocationData = "Select * from tbl_Locations"; //Close existing connection SysCon.CloseConnection(); //Open Connection SysCon.SystemConnect.Open(); //Loading all EUL Data SqlCommand LoadLocData = new SqlCommand(LocationData, SysCon.SystemConnect); SqlDataReader LocationReader = LoadLocData.ExecuteReader(); while (LocationReader.Read()) { cboLocation.Items.Add(LocationReader.GetValue(1)); } LocationReader.Close(); LocationReader.Dispose(); //Close connection SysCon.SystemConnect.Close(); }
private void func_Retrieve_Item() { string RetrieveItems = "Select pk_Id,Description,New_Property_No,Serial_No,Date_Acquired,Unit_Cost,EUL_Name from view_Inventory_Details where pk_Id = ' " + GlobalClass.GlobalInvItemId + "'"; //close current connection SysCon.CloseConnection(); //Open connection SysCon.SystemConnect.Open(); SqlCommand ItemFinder = new SqlCommand(RetrieveItems, SysCon.SystemConnect); SqlDataReader ItemReader = ItemFinder.ExecuteReader(); if (ItemReader.Read()) { Id = ItemReader[0].ToString(); txtItemDesc.Text = ItemReader[1].ToString(); txtPropertyNo.Text = ItemReader[2].ToString(); txtSerialNo.Text = ItemReader[3].ToString(); txtDateAcq.Text = ItemReader[4].ToString(); txtUnitCost.Text = ItemReader[5].ToString(); txtEUL.Text = ItemReader[6].ToString(); Date_Acquired = txtDateAcq.Text; EUL = txtEUL.Text; Unit_Cost = txtUnitCost.Text; } ItemReader.Close(); ItemReader.Dispose(); }
private void func_Load_All_Activity() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllActivities = "Select * from tbl_Audit_Trail"; SqlDataAdapter AllActivitiesAdapter = new SqlDataAdapter(AllActivities, SysCon.SystemConnect); string srctbl = "tbl_Audit_Trail"; DataSet ActivitiesData = new DataSet(); AllActivitiesAdapter.Fill(ActivitiesData, srctbl); dgvTrail.DataSource = ActivitiesData.Tables["tbl_Audit_Trail"]; dgvTrail.RowHeadersWidth = 5; //dgvTrail.Columns[0].Visible = false; //dgvTrail.Columns[1].Visible = false; dgvTrail.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_Check_Duplication_AddMOA() { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string CheckDuplication = "Select Mode_of_Acquisition from tbl_Mode_of_Acquisition where Mode_of_Acquisition ='" + txtMOA.Text + "'"; SqlCommand CheckRecordCommand = new SqlCommand(CheckDuplication, SysCon.SystemConnect); SqlDataReader CReader = CheckRecordCommand.ExecuteReader(); if (CReader.Read()) { MessageBox.Show("Mode of Acquisition already exists!", "New Record", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtMOA.Focus(); return; } else { func_Add_MOA(); } CReader.Close(); CReader.Dispose(); }
private void func_Load_All_Items() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllReItems = "Select * from view_Received_Items where Status != 'EXPIRED'"; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllReItems, SysCon.SystemConnect); string srctbl = "view_Received_Items"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Received_Items"]; dgvItems.RowHeadersWidth = 5; dgvItems.Columns[0].Visible = false; dgvItems.Columns[1].Visible = false; dgvItems.Columns[23].Visible = false; SysCon.SystemConnect.Close(); }
private void func_Add_MOA() { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string NewMOA = "Insert into tbl_Mode_of_Acquisition (Mode_of_Acquisition) Values('" + txtMOA.Text + "')"; SqlCommand AddNewMOA = new SqlCommand(NewMOA, SysCon.SystemConnect); AddNewMOA.ExecuteNonQuery(); MessageBox.Show("New Mode of Acquisition has been successfully added!", "Add New Record", MessageBoxButtons.OK, MessageBoxIcon.Information); //Insert Activity to audit trail string user = "******" + GlobalClass.GlobalName + "', '" + GlobalClass.GlobalUser + "', '" + DateTime.Now.ToString() + "', 'Add New Mode of Acquisition = ' + '" + txtMOA.Text + "')"; SqlCommand AuditTrail = new SqlCommand(user, SysCon.SystemConnect); AuditTrail.ExecuteNonQuery(); //Close Connection SysCon.SystemConnect.Close(); func_Reset(); func_Load_All_MOA(); }
private void func_Load_All_Items() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllExItems = "Select pk_Id,Category_Name,Subcategory_Name,Article_Name,Description,UOM,Serial_No,Unit_Cost,EUL_Name,Date_Acquired,Depreciated_Cost,Book_Value,Warranty_Validity,Old_Property_No,New_Property_No,Location_Name,Mode_of_Acquisition,Status,Document_No,Date_Issued,Date_Received,[Accountable Officer],Designation,[End User],[End User Unit],Inventory_Date,Remarks,IsSubscribed,EOS,Office from view_Inventory_Details where Status != 'CANCELLED PROPERTY NO.'"; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllExItems, SysCon.SystemConnect); string srctbl = "view_Inventory_Details"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Inventory_Details"]; dgvItems.Columns[0].Visible = false; dgvItems.RowHeadersWidth = 5; //string query = "Select SUM (Unit_Cost) from view_Inventory_Details"; //using (System.Data.IDbCommand command = new System.Data.OleDb.OleDbCommand(query)) //{ // object result = command.ExecuteScalar(); // lblCost.Text = Convert.ToString(result); //} SysCon.SystemConnect.Close(); }
private void func_Check_Duplication_UpdMOA() { if (MOADesc != txtMOA.Text) { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string CheckDuplication_MOA = "Select Mode_of_Acquisition from tbl_Mode_of_Acquisition where Mode_of_Acquisition ='" + txtMOA.Text + "'"; SqlCommand CheckDuplicateMOACommand = new SqlCommand(CheckDuplication_MOA, SysCon.SystemConnect); SqlDataReader MOAReader = CheckDuplicateMOACommand.ExecuteReader(); if (MOAReader.Read()) { MessageBox.Show("Record already exists!", "Mode of Acquisition", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtMOA.Focus(); return; } else { func_Update_MOA(); } MOAReader.Close(); MOAReader.Dispose(); } else { MessageBox.Show("No changes has been made!"); func_Reset(); } }
private void func_Load_All_Items() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllExItems = "Select * from view_Existing_Items_Details where Status != 'CANCELLED PROPERTY NO.' "; SqlDataAdapter AllItemsAdapter = new SqlDataAdapter(AllExItems, SysCon.SystemConnect); string srctbl = "view_Existing_Items_Details"; DataSet ItemsData = new DataSet(); AllItemsAdapter.Fill(ItemsData, srctbl); dgvItems.DataSource = ItemsData.Tables["view_Existing_Items_Details"]; dgvItems.RowHeadersWidth = 5; dgvItems.Columns[0].Visible = false; dgvItems.Columns[1].Visible = false; dgvItems.Columns[2].Visible = false; dgvItems.Columns[3].Visible = false; dgvItems.Columns[4].Visible = false; dgvItems.Columns[5].Visible = false; dgvItems.Columns[6].Visible = false; dgvItems.Columns[7].Visible = false; dgvItems.Columns[8].Visible = false; //dgvItems.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_Load_All_MOA() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllESL = "Select * from tbl_Mode_of_Acquisition"; SqlDataAdapter AllESLAdapter = new SqlDataAdapter(AllESL, SysCon.SystemConnect); string srctbl = "tbl_Mode_of_Acquisition"; DataSet ESLData = new DataSet(); AllESLAdapter.Fill(ESLData, srctbl); dgvSOE.DataSource = ESLData.Tables["tbl_Mode_of_Acquisition"]; dgvSOE.RowHeadersWidth = 5; dgvSOE.Columns[0].Visible = false; dgvSOE.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_Check_Duplication_AddCat() { //close connection SysCon.CloseConnection(); //open connection SysCon.SystemConnect.Open(); string CheckDuplication = "Select Category_Code, Category_Name from tbl_Category where Category_Name = '" + txtCategoryName.Text + "'or Category_Code = '" + txtCode.Text + "'"; SqlCommand CheckRecordCommand = new SqlCommand(CheckDuplication, SysCon.SystemConnect); SqlDataReader CReader = CheckRecordCommand.ExecuteReader(); if (CReader.Read()) { MessageBox.Show("Category already exists!", "Category", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtCategoryName.Focus(); return; } else { func_Add_Category(); } CReader.Close(); CReader.Dispose(); }
private void func_Retrieve_Item() { string RetrieveItems = "Select Description,Unit_Cost,Old_Property_No,Location_Name,Serial_No,Date_Acquired,Subcategory_Code,Article_Code,New_Property_No from view_Existing_Items_Details where pk_Id = ' " + GlobalClass.GlobalInvItemId + "'"; //close current connection SysCon.CloseConnection(); //Open connection SysCon.SystemConnect.Open(); SqlCommand ItemFinder = new SqlCommand(RetrieveItems, SysCon.SystemConnect); SqlDataReader ItemReader = ItemFinder.ExecuteReader(); if (ItemReader.Read()) { txtItemDesc.Text = ItemReader[0].ToString(); txtUnitCost.Text = ItemReader[1].ToString(); txtPropertyNo.Text = ItemReader[2].ToString(); txtSerialNo.Text = ItemReader[4].ToString(); Acq_Date = ItemReader[5].ToString(); Sub_Code = ItemReader[6].ToString(); Art_Code = ItemReader[7].ToString(); txtnewpn.Text = ItemReader[8].ToString(); cboLocation.Text = ItemReader[3].ToString(); } ItemReader.Close(); ItemReader.Dispose(); }
private void func_Retrieve_Category_Details() { string RetrieveCategory = "Select Category_Code,Category_Name from tbl_Category where pk_Category_Id = ' " + GlobalClass.GlobalCategoryId + "'"; //close current connection SysCon.CloseConnection(); //Open connection SysCon.SystemConnect.Open(); SqlCommand CategoryFinder = new SqlCommand(RetrieveCategory, SysCon.SystemConnect); SqlDataReader CategoryReader = CategoryFinder.ExecuteReader(); if (CategoryReader.Read()) { CategoryCode = CategoryReader[0].ToString(); CategoryName = CategoryReader[1].ToString(); txtCode.Text = CategoryReader[0].ToString(); txtCategoryName.Text = CategoryReader[1].ToString(); txtCategoryName.Focus(); } btnSaveUpdate.Text = "Update"; btnDelete.Enabled = true; }
private void button1_Click(object sender, EventArgs e) { string Date = dgvItems.CurrentRow.Cells[12].Value.ToString(); string lastTwoDigitsOfYear = Date.Substring(8, 2); string UACS = dgvItems.CurrentRow.Cells[13].Value.ToString(); string ArtCode = dgvItems.CurrentRow.Cells[14].Value.ToString(); //Get Serial # string strCount = "Select count(*) FROM tbl_Inventory_Details WHERE New_Property_No like '%" + ArtCode + "%'"; //Close existing connection SysCon.CloseConnection(); SqlCommand comd = new SqlCommand(strCount, SysCon.SystemConnect); SysCon.SystemConnect.Open(); int count = Convert.ToInt32(comd.ExecuteScalar()); count = (Convert.ToInt32(count) + 1); string New_Property_No = UACS + '-' + cboOffice.Text + '-' + ArtCode + lastTwoDigitsOfYear + '-' + count.ToString("0000"); MessageBox.Show(New_Property_No); //MessageBox.Show(new_code + '-'+ count.ToString("0000")); //sProperty_No = Code + '-' + count.ToString("0000"); //End of code for generating Property No. SysCon.CloseConnection(); }
private void func_Load_All_Employees() { //Close current connection SysCon.CloseConnection(); SysCon.SystemConnect.Open(); string AllEmployees = "Select * from view_EmployeeDivision where Employment_Status = 'Permanent'"; SqlDataAdapter AllEmpAdapter = new SqlDataAdapter(AllEmployees, SysCon.SystemConnect); string srctbl = "view_EmployeeDivision"; DataSet EmployeeData = new DataSet(); AllEmpAdapter.Fill(EmployeeData, srctbl); dgvEmployees.DataSource = EmployeeData.Tables["view_EmployeeDivision"]; dgvEmployees.RowHeadersWidth = 5; dgvEmployees.Columns[0].Visible = false; dgvEmployees.Columns[1].Visible = false; dgvEmployees.Columns[6].Visible = false; dgvEmployees.Columns[7].Visible = false; dgvEmployees.Columns[8].Visible = false; dgvEmployees.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; SysCon.SystemConnect.Close(); }
private void func_LoadEULData() { string EULData = "Select pk_EUL_Id,EUL_Name from tbl_Estimated_Useful_Life"; //Close existing connection SysCon.CloseConnection(); //Open Connection SysCon.SystemConnect.Open(); //Loading all EUL Data SqlCommand LoadEULData = new SqlCommand(EULData, SysCon.SystemConnect); SqlDataReader EULReader = LoadEULData.ExecuteReader(); while (EULReader.Read()) { cboEUL.Items.Add(EULReader.GetValue(1)); } EULReader.Close(); EULReader.Dispose(); //Close connection SysCon.SystemConnect.Close(); }