public static HR_JobResponsibility GetHR_JobResponsibilityByJobResponsibilityID(int JobResponsibilityID) { HR_JobResponsibility hR_JobResponsibility = new HR_JobResponsibility(); SqlHR_JobResponsibilityProvider sqlHR_JobResponsibilityProvider = new SqlHR_JobResponsibilityProvider(); hR_JobResponsibility = sqlHR_JobResponsibilityProvider.GetHR_JobResponsibilityByJobResponsibilityID(JobResponsibilityID); return hR_JobResponsibility; }
public static bool UpdateHR_JobResponsibility(HR_JobResponsibility hR_JobResponsibility) { SqlHR_JobResponsibilityProvider sqlHR_JobResponsibilityProvider = new SqlHR_JobResponsibilityProvider(); return sqlHR_JobResponsibilityProvider.UpdateHR_JobResponsibility(hR_JobResponsibility); }
public static int InsertHR_JobResponsibility(HR_JobResponsibility hR_JobResponsibility) { SqlHR_JobResponsibilityProvider sqlHR_JobResponsibilityProvider = new SqlHR_JobResponsibilityProvider(); return sqlHR_JobResponsibilityProvider.InsertHR_JobResponsibility(hR_JobResponsibility); }
public bool UpdateHR_JobResponsibility(HR_JobResponsibility hR_JobResponsibility) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_JobResponsibility", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@JobResponsibilityID", SqlDbType.Int).Value = hR_JobResponsibility.JobResponsibilityID; cmd.Parameters.Add("@JobResponsibilityName", SqlDbType.NVarChar).Value = hR_JobResponsibility.JobResponsibilityName; cmd.Parameters.Add("@JobResponsibilityName", SqlDbType.NVarChar).Value = hR_JobResponsibility.JobResponsibilityName; cmd.Parameters.Add("@JobResponsibilityName", SqlDbType.NVarChar).Value = hR_JobResponsibility.JobResponsibilityName; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_JobResponsibility.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_JobResponsibility.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_JobResponsibility(HR_JobResponsibility hR_JobResponsibility) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_JobResponsibility", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@JobResponsibilityID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@JobResponsibilityName", SqlDbType.NVarChar).Value = hR_JobResponsibility.JobResponsibilityName; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_JobResponsibility.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_JobResponsibility.AddedDate; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_JobResponsibility.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_JobResponsibility.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@JobResponsibilityID"].Value; } }
public HR_JobResponsibility GetHR_JobResponsibilityFromReader(IDataReader reader) { try { HR_JobResponsibility hR_JobResponsibility = new HR_JobResponsibility ( DataAccessObject.IsNULL<int>(reader["JobResponsibilityID"]), DataAccessObject.IsNULL<string>(reader["JobResponsibilityName"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_JobResponsibility; } catch(Exception ex) { return null; } }