private void SaveData(int Age, String Fname, String Lname, int ManagerID, String Dept, String DeptType, String EmpType) { // saving data clsCMScon conSaveData = new clsCMScon(); try { conSaveData.Connect(); SqlCommand cmdSaveData = new SqlCommand(); cmdSaveData.CommandText = "InsertEmployee"; cmdSaveData.CommandType = CommandType.StoredProcedure; cmdSaveData.Connection = conSaveData.sqlConStr; SqlParameter paramAge = cmdSaveData.Parameters.Add("@Age", SqlDbType.Int, 4, "Age"); SqlParameter paramFname = cmdSaveData.Parameters.Add("@FName", SqlDbType.NVarChar, 30, "Fname"); SqlParameter paramLname = cmdSaveData.Parameters.Add("@Lname", SqlDbType.NVarChar, 30, "Lname"); SqlParameter paramManagerID = cmdSaveData.Parameters.Add("@ManageriD", SqlDbType.Int, 4, "ManagerID"); SqlParameter paramDeptName = cmdSaveData.Parameters.Add("@Deptname", SqlDbType.NChar, 30, "Dept"); SqlParameter paramDeptType = cmdSaveData.Parameters.Add("@DeptType", SqlDbType.NChar, 30, "DeptType"); SqlParameter paramEmpType = cmdSaveData.Parameters.Add("@Emptype", SqlDbType.NChar, 10, "EmpType"); paramAge.Value = Age; paramFname.Value = Fname; paramLname.Value = Lname; paramManagerID.Value = ManagerID; paramDeptName.Value = Dept; paramDeptType.Value = DeptType; paramEmpType.Value = EmpType; cmdSaveData.ExecuteNonQuery(); conSaveData.DisConnect(); MessageBox.Show("Saving Successful!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception err) { MessageBox.Show(err.Message, err.Source); } finally { conSaveData.DisConnect(); } }
private void LoadEmployeeType() { clsCMScon conEmployeeType = new clsCMScon(); try { conEmployeeType.Connect(); SqlDataAdapter daEmployeeType = new SqlDataAdapter("exec tjm_loadEmployeeType", conEmployeeType.sqlConStr); DataTable dtEmployeeType = new DataTable(); daEmployeeType.Fill(dtEmployeeType); cmbEmpType.DataSource = dtEmployeeType; cmbEmpType.DisplayMember = "Description"; cmbEmpType.ValueMember = "EmpType_ID"; cmbEmpType.SelectedValue = 0; conEmployeeType.DisConnect(); } catch (Exception err) { MessageBox.Show(err.Message, err.Source); StreamWriter sw = new StreamWriter("D:\\PW\\wowRox\\logs" + string.Format("{0:MM-dd-yyyy}", DateTime.Now) + ".log", true); sw.WriteLine(err.Message); sw.Flush(); sw.Dispose(); } finally { conEmployeeType.DisConnect(); } }
private void LoadDepartment() { clsCMScon conDepartment = new clsCMScon(); try { conDepartment.Connect(); SqlDataAdapter daDepartment = new SqlDataAdapter("exec tjm_LoadDeparment", conDepartment.sqlConStr); DataTable dtDepartment = new DataTable(); daDepartment.Fill(dtDepartment); cmbDept.DataSource = dtDepartment; cmbDept.DisplayMember = "Dept_Type"; cmbDept.ValueMember = "Dept_Name"; cmbDept.SelectedValue = 0; conDepartment.DisConnect(); } catch (Exception err) { MessageBox.Show(err.Message, err.Source); StreamWriter sw = new StreamWriter("D:\\PW\\wowRox\\logs" + string.Format("{0:MM-dd-yyyy}", DateTime.Now) + ".log", true); sw.WriteLine(err.Message); sw.Flush(); sw.Dispose(); } finally { conDepartment.DisConnect(); } }