public static HR_PersonalDocuments GetHR_PersonalDocumentsByPersonalDocumentsID(int PersonalDocumentsID) { HR_PersonalDocuments hR_PersonalDocuments = new HR_PersonalDocuments(); SqlHR_PersonalDocumentsProvider sqlHR_PersonalDocumentsProvider = new SqlHR_PersonalDocumentsProvider(); hR_PersonalDocuments = sqlHR_PersonalDocumentsProvider.GetHR_PersonalDocumentsByPersonalDocumentsID(PersonalDocumentsID); return hR_PersonalDocuments; }
public static HR_PersonalDocuments GetHR_EmployeeByEmployeeID(string EmployeeID) { HR_PersonalDocuments hR_PersonalDocuments = new HR_PersonalDocuments(); SqlHR_PersonalDocumentsProvider sqlHR_PersonalDocumentsProvider = new SqlHR_PersonalDocumentsProvider(); hR_PersonalDocuments = sqlHR_PersonalDocumentsProvider.GetHR_PersonalDocumentsByEmployeeID(EmployeeID); return hR_PersonalDocuments; }
public bool UpdateHR_PersonalDocuments(HR_PersonalDocuments hR_PersonalDocuments) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_PersonalDocuments", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PersonalDocumentsID", SqlDbType.Int).Value = hR_PersonalDocuments.PersonalDocumentsID; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_PersonalDocuments.EmployeeID; cmd.Parameters.Add("@FileName", SqlDbType.NVarChar).Value = hR_PersonalDocuments.FileName; cmd.Parameters.Add("@FileLocationUrl", SqlDbType.NVarChar).Value = hR_PersonalDocuments.FileLocationUrl; cmd.Parameters.Add("@FileLocationUrl", SqlDbType.NVarChar).Value = hR_PersonalDocuments.FileLocationUrl; cmd.Parameters.Add("@FileLocationUrl", SqlDbType.NVarChar).Value = hR_PersonalDocuments.FileLocationUrl; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_PersonalDocuments.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_PersonalDocuments.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_PersonalDocuments GetHR_PersonalDocumentsFromReader(IDataReader reader) { try { HR_PersonalDocuments hR_PersonalDocuments = new HR_PersonalDocuments ( DataAccessObject.IsNULL<int>(reader["PersonalDocumentsID"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()), DataAccessObject.IsNULL<string>(reader["FileName"]), DataAccessObject.IsNULL<string>(reader["FileLocationUrl"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_PersonalDocuments; } catch(Exception ex) { return null; } }
public static int InsertHR_PersonalDocuments(HR_PersonalDocuments hR_PersonalDocuments) { SqlHR_PersonalDocumentsProvider sqlHR_PersonalDocumentsProvider = new SqlHR_PersonalDocumentsProvider(); return sqlHR_PersonalDocumentsProvider.InsertHR_PersonalDocuments(hR_PersonalDocuments); }
public static bool UpdateHR_PersonalDocuments(HR_PersonalDocuments hR_PersonalDocuments) { SqlHR_PersonalDocumentsProvider sqlHR_PersonalDocumentsProvider = new SqlHR_PersonalDocumentsProvider(); return sqlHR_PersonalDocumentsProvider.UpdateHR_PersonalDocuments(hR_PersonalDocuments); }