public void ReportAbsence(ReportedAbsenceEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ReportAbsence", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Date", t.Date); cmd.Parameters.AddWithValue("@AbsenceEmployeeId", t.AbsenceEmployeeId); cmd.Parameters.AddWithValue("@ManagerEmployeeId", t.ManagerEmployeeId); cmd.Parameters.AddWithValue("@Notes", t.Notes); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
protected void ProceedButton_Click(object sender, EventArgs e) { ReportedAbsenceEntity entity = new ReportedAbsenceEntity(); entity.ManagerEmployeeId = new UserMapper().GetUserByUserName(UserPrincipal.Current.SamAccountName).EmployeeId; entity.AbsenceEmployeeId = Convert.ToInt32(AbsenceEmployeeDropDownList.SelectedValue); entity.Notes = OtherInfoTextBox.Text; entity.Date = DateTime.Now; new ReportedAbsenceMapper().ReportAbsence(entity); Response.Redirect("~/Dashboard.aspx"); }