public static HR_Empoyee GetHR_EmpoyeeByID(int id)
{
HR_Empoyee hR_Empoyee = new HR_Empoyee();
SqlHR_EmpoyeeProvider sqlHR_EmpoyeeProvider = new SqlHR_EmpoyeeProvider();
hR_Empoyee = sqlHR_EmpoyeeProvider.GetHR_EmpoyeeByID(id);
return(hR_Empoyee);
}
public int InsertHR_Empoyee(HR_Empoyee hR_Empoyee)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertHR_Empoyee", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@HR_EmpoyeeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@HR_EmpoyeeName", SqlDbType.NVarChar).Value = hR_Empoyee.HR_EmpoyeeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@HR_EmpoyeeID"].Value;
}
}
public bool UpdateHR_Empoyee(HR_Empoyee hR_Empoyee)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateHR_Empoyee", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@HR_EmpoyeeID", SqlDbType.Int).Value = hR_Empoyee.HR_EmpoyeeID;
cmd.Parameters.Add("@HR_EmpoyeeName", SqlDbType.NVarChar).Value = hR_Empoyee.HR_EmpoyeeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_Empoyee GetHR_EmpoyeeFromReader(IDataReader reader)
{
try
{
HR_Empoyee hR_Empoyee = new HR_Empoyee
(
(int)reader["HR_EmpoyeeID"],
reader["HR_EmpoyeeName"].ToString()
);
return hR_Empoyee;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateHR_Empoyee(HR_Empoyee hR_Empoyee)
{
SqlHR_EmpoyeeProvider sqlHR_EmpoyeeProvider = new SqlHR_EmpoyeeProvider();
return(sqlHR_EmpoyeeProvider.UpdateHR_Empoyee(hR_Empoyee));
}
public static int InsertHR_Empoyee(HR_Empoyee hR_Empoyee)
{
SqlHR_EmpoyeeProvider sqlHR_EmpoyeeProvider = new SqlHR_EmpoyeeProvider();
return(sqlHR_EmpoyeeProvider.InsertHR_Empoyee(hR_Empoyee));
}
