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