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