protected void btnAdd_Click(object sender, EventArgs e)
{
EmployeeLeave employeeLeave = new EmployeeLeave();
employeeLeave.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
employeeLeave.LeaveDate = txtLeaveDate.Text;
employeeLeave.LeaveTypeID = Int32.Parse(ddlLeaveType.SelectedValue);
employeeLeave.AddedBy = txtAddedBy.Text;
employeeLeave.AddedDate = DateTime.Now;
employeeLeave.UpdatedBy = txtUpdatedBy.Text;
employeeLeave.UpdateDate = txtUpdateDate.Text;
employeeLeave.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = EmployeeLeaveManager.InsertEmployeeLeave(employeeLeave);
Response.Redirect("AdminEmployeeLeaveDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
EmployeeLeave employeeLeave = new EmployeeLeave();
employeeLeave = EmployeeLeaveManager.GetEmployeeLeaveByID(Int32.Parse(Request.QueryString["employeeLeaveID"]));
EmployeeLeave tempEmployeeLeave = new EmployeeLeave();
tempEmployeeLeave.EmployeeLeaveID = employeeLeave.EmployeeLeaveID;
tempEmployeeLeave.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
tempEmployeeLeave.LeaveDate = txtLeaveDate.Text;
tempEmployeeLeave.LeaveTypeID = Int32.Parse(ddlLeaveType.SelectedValue);
tempEmployeeLeave.AddedBy = txtAddedBy.Text;
tempEmployeeLeave.AddedDate = DateTime.Now;
tempEmployeeLeave.UpdatedBy = txtUpdatedBy.Text;
tempEmployeeLeave.UpdateDate = txtUpdateDate.Text;
tempEmployeeLeave.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = EmployeeLeaveManager.UpdateEmployeeLeave(tempEmployeeLeave);
Response.Redirect("AdminEmployeeLeaveDisplay.aspx");
}
public EmployeeLeave GetEmployeeLeaveFromReader(IDataReader reader)
{
try
{
EmployeeLeave employeeLeave = new EmployeeLeave
(
(int)reader["EmployeeLeaveID"],
reader["EmployeeID"].ToString(),
(DateTime)reader["LeaveDate"],
(int)reader["LeaveTypeID"],
reader["AddedBy"].ToString(),
(DateTime)reader["AddedDate"],
reader["UpdatedBy"].ToString(),
(DateTime)reader["UpdateDate"],
(int)reader["RowStatusID"]
);
try {
employeeLeave.EmployeeName = reader["EmployeeName"].ToString();
employeeLeave.EmployeeNo = reader["EmployeeNo"].ToString();
employeeLeave.LeaveName = reader["LeaveName"].ToString();
}
catch(Exception ex)
{
}
return employeeLeave;
}
catch(Exception ex)
{
return null;
}
}
private void showEmployeeLeaveData()
{
EmployeeLeave employeeLeave = new EmployeeLeave();
employeeLeave = EmployeeLeaveManager.GetEmployeeLeaveByID(Int32.Parse(Request.QueryString["employeeLeaveID"]));
ddlEmployee.SelectedValue = employeeLeave.EmployeeID.ToString();
txtLeaveDate.Text = employeeLeave.LeaveDate;
ddlLeaveType.SelectedValue = employeeLeave.LeaveTypeID.ToString();
txtAddedBy.Text = employeeLeave.AddedBy;
txtUpdatedBy.Text = employeeLeave.UpdatedBy;
txtUpdateDate.Text = employeeLeave.UpdateDate;
ddlRowStatus.SelectedValue = employeeLeave.RowStatusID.ToString();
}
public bool UpdateEmployeeLeave(EmployeeLeave employeeLeave)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Cuc_UpdateEmployeeLeave", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeeLeaveID", SqlDbType.Int).Value = employeeLeave.EmployeeLeaveID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = employeeLeave.EmployeeID;
cmd.Parameters.Add("@LeaveDate", SqlDbType.DateTime).Value = employeeLeave.LeaveDate;
cmd.Parameters.Add("@LeaveTypeID", SqlDbType.Int).Value = employeeLeave.LeaveTypeID;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = employeeLeave.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = employeeLeave.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = employeeLeave.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = employeeLeave.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = employeeLeave.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
